Mail Merge in Google Sheets & Gmail (for free)

[@KevinStratvert]

Continue learning Google Sheets with FREE Official Training offered by Google: ✅ Google Sheets Getting Started course: bit.ly/3UwekAu ✅ Google Sheets Advanced Topics course: bit.ly/3tpxDj2 ✅ Google Sheets Functions, Formulas, and Charts course: bit.ly/3UNI9vV

[@edwardpovey5568]

Hi all, a really useful tip. When drafting your email, make sure you've changed to plain text mode, otherwise the {{}} tags in the body of your email won't get read by the script and will appear blank when you hit send. Like me, if you want your email to have a fancy footer and some nice fonts, you can copy and paste your plain text email body into a new draft in normal mode. As long as the {{}} tags are in plain text the script will read them and the merge will work. It's basically taken me about a day to work this out, in which time I could have written all the emails I needed to send out by hand!

[@jonfortier9614]

Thanks for the info, I was struggling with this as well.

[@shikhagoli]

Please help me .. everything is coming in one line .. I have formatted the mail but still everything is coming in one line in mail body.

[@MrEdpovey]

@@shikhagoli Hi, I’m afraid I don’t know what’s going on there. So sorry. Does it happen when the whole message is in plain text or when you’ve switched back to normal mode? Maybe try just putting the {{}} tags in plain text.

[@cybraxe]

Hey can anyone indicate why after row 8 it stops printing the time just the date any way to fix this? Please

[@chrisrobinson9994]

@@shikhagoli Did you ever solve this one? Everything on my end looks great except the Signature section, which all comes on one line. Trying to get it to be vertical which is the natural format for Best regards, name, phone # and website.

[@ankithabhaskara3408]

Hi everyone, For those who were facing problem with the First Name not appearing in the email, try this out. In the link where you download the google sheets file you will see instructions on how to use Mail Merge. There you will find a highlighted text which says {{First Name}} . Copy that onto your email and then try. But make sure to format the font, size and background color to match the rest of your email. I dont know the logic behind this but it worked for me.

[@MrsOConnorsMusic]

THIS! Thanks so much for this info you are right and I don't understand why but, it finally worked!

[@WileyB915]

it finally worked for me too! thank you!

[@190harpreet]

OMG! This was awesome!

[@ArtemKozlov-j3p]

2024, still works! 😎

[@sivarajanv6617]

My brother came out with this problem of sending multiple mails to different members in his club with individual details. Though I had worked with Mail merge in MS Word, this was a challenge. I found the right solution here. I tried it out myself with test mails before communicating to my brother. Thanks a lot Kevin. Sivarajan, India.

[@kcoolnow]

This still works three years later. Really great for non-profits trying to do constituent updates. Thank you!

[@jawaadkhan5238]

Did you have any trouble with google blocking the script? I'm encountering that (it doesn't give me the option to allow, it just says Google blocked it for safety - i'm using a personal gmail account)

[@user-tr1zt1mq7h]

How do you have the "Mail Merge" option in Google Sheets? Mine does not have this.

[@kcoolnow]

@@user-tr1zt1mq7h Gabriel, just follow the video. Google sheets does not include the capability in its core. You'll need to download a _copy of that specific document,_ then allow the document to perform the incorporated script. The script actually puts the menu in the google sheet. After you authorize the script it becomes fully functional. (Security measure: 7:20) Good luck!

[@kcoolnow]

@@jawaadkhan5238 Huh! Maybe you need a business account?

[@kcoolnow]

@@jawaadkhan5238 I was able to make this work with a personal account. You have to go through a number of hoops. The directions show you how to allow the script to work. You may have to scroll down, or click the very tiny grey "Advanced" link and go through a few other hoops. It's okay because the script is shared directly from Google's support area. Just follow through all the hoops. When it's done, pull down on the Merge menu again and follow the prompts until you have sent an email. I think you're limited to 100 emails _sent_ per day as a regular non-business google account.

[@truthseeker318]

Kevin, your videos by far are some of the best and most valuable tutorials. We are testing a few markets and wanted a free solution, do to being a startup and pretty much just testing options. And once again you come through with straight forward legitimate solutions that work well. KUDOS!

[@newtruevinemiracletabernac2540]

I have believe I have changed everything to Plain text but my script still won't run. The RECIPIENT field in the email still has the red dots under it indicating something is not working. Any other suggestions, please?

[@bethlehemearlylearningcent6609]

SOLVED: Fix for missing fields in Body of Email: 1. Copy/Paste field from Sheet into Subject area of email - (adding curly bracket syntax - example: {{field_name}} ) 2. Copy/paste again (from curly bracket to curly bracket) from Subject area into Body. Voila! 3. Delete field from Subject area if not needed. 4. Repeat for each field that you need in the body. Basically, I believe we must strip the formatting from the field name when inserting it into our email body, and it seemed to work best when copy/pasting from Subject area to Body.

[@navoditthakral8221]

worked

[@JY-qb6hx]

It worked for me too? Any idea why?

[@gherasimiulian4134]

Thanks, that helped Any idea how many can i send

[@denisjohnco4549]

After nearly giving up I found this comment and it works!

[@kshitijkulshreshtha5017]

Before copying your heading, turn the plain text mode on. Then copy paste your heading {{heading}} then off your plain text mode. This worked for me

[@GTSTradingIndicators]

Hey Kevin You are awesome at explaining things. Watched several of your videos! Keep up the great work

[@indraneelmitra5632]

Hi Kevin, I was desperately searching for the Mail Merger procedure on KZbin. After encountering several long and talkative videos, I finally came across your short and precise video. It was really helpful and I was able to successfully complete my Mail Merge. Thanks a ton 😊

[@noahthegreat190]

How did it go? Do the recipients see each other in the "To:" field? Gonna try this but Im nervous about it showing to all the recipients and them seeing eachother

[@indraneelmitra5632]

​@@noahthegreat190 Hi Noah! The recipient can see only his name in the 'To' field. So there is no way the particular recipient will get to see/know about the other recipients.

[@tremsmom8274]

This is very helpful. However, I am struggling to get the cc fields to work. Can you do a demo on how to trigger a column that holds email addresses for ccs or bccs? Much appreciated.

[@kenn5269]

did you ever figure out how to invoke CC (as a mail merge, not to a static address)?

[@aditya_suresh]

Thanks a lot Kevin! This was the first video that I requested after viewing your channel! Your tips and solutions have been very useful indeed!

[@kevinlncconsulting]

Amazing Video Kev. I'm blown away. I've spent so many hours trying other methods that didn't work or had limitations. But this by far is the most cleanest and quickest method. Thanks a bunch!

[@zeno2712]

I don't know if it's changed since this video was made, but Gmail doesn't require {{Recipient}} in the email To: field - and it is removed if the draft is closed and then re-opened anyway, presumably as it's not a valid email address. Just leave the To: field blank and the mail merge will work - the script knows where to put the email addresses!

[@arjunm1137]

Thanks Kevin Is it possible to send different attachments for different person using mail merge.

[@kathijenmurphy9750]

Thanks Kevin, the video was very easy to follow. I tested it and I received the message that my email was sent but didn't get the email with all the information. The only fields I had were recipient, student email, student password, email sent and the description. Tried it several different ways but none of them worked.

[@6059nuy]

What Jesus Castellanos posted here worked.

[@mpumelelontozakhe3715]

same and I have said to call it a quit

[@ginashen8974]

To everyone have same problem don’t show {{ first name}} Change draft to “ Plan Text Mode” when you paste it.

[@theenglisheducator7689]

Oh, this is a great video. I just wish I had read the comment below that said to switch to plain text mode. 30 emails sent without a name in the body = marketing disaster!

[@tenaciousshaman]

This is a suggestion for a future video, and I'm putting this here because it's your latest video at the time. I have not found a good way to create a virtual water cooler in Teams. A meeting that anyone can join at any time when they've got some downtime, so we get some ad hoc social interaction, like we used to get when we would go get coffee in the office. They pop in, talk with a couple of other people for 5 minutes then move on. We would have to leave a meeting open all the time? Downsides I would like to avoid: having to schedule all day meetings on everyone's calendar. For whoever actually creates this constantly open, always available meeting, avoid having their calendar show all day meetings. Turn off notifications by default for the meeting/channel so that everyone doesn't get flooded with notifications. I don't know if it is possible, or if it is possible, if it is just too much work or annoying, but I think everyone misses that social interaction when we're all working from home. A constantly open meeting that you can just pop in and out of for ad hoc and social conversations would be great. Love the channel, love the content. Thanks for doing what you do.

[@No1TV4CATS]

Did you find a solution? I am trying to develop the same idea. Thanks.

[@marcelorox311]

You could just make a discord channel

[@danilag.badiola2988]

I love how your tutorials are easy to follow, and I'm sure I did follow your every step in this mail merge tutorial but whenever I receive the test email I created the other columns would not appear in the email. It's frustrating cause I don't know what I'm doing wrong. Nonetheless, Thank you very much Kevin!

[@jesuscastellanos9985]

I resolved this issue by copying my email draft and pasting it as plain text. I'm assuming my formating was causing the issue.

[@BenUlin]

@@jesuscastellanos9985 Thanks! This solved my problem as well.

[@michaelholden91]

I also had fields retun blank which was resolved by turning everything to plain text. I then added back in each element of formating to test the cause. I believe it was a table that I had created in docs and copied into the email. However, if I copied in a table from sheets, I was fine. Pictures, text size, bold, and highlights were non-issues.

[@anthonyokon8036]

Note that to copy the desired text and paste it as a text as "plain text"... Windows: Right-clicking and choosing 'Paste as plain text' or using CTRL + SHIFT + V. Mac: Right-clicking and choosing 'Paste and match style' or using CMD + SHIFT + V.

[@tracyhruska3146]

How do you change everything to plain text

[@esmebollenbeck1727]

It seems so simply, but when something doesn't work right, there's no help nor step-by-step guide for trouble shooting - at least I couldn't find anything. I did everything as described, but when I hit "Send Mail" for the test-run, nothing happened. My address was entered correctly and all other required fields were in the sheet, too. So I ended up using the Add-On "Mail Merge Docs - Email, document, letter" from the Google Workspace Marketplace, which worked real well.

[@charleyheironimus6910]

OMGosh!!!!! This is great. my husband said why don't u do a mail merge instead of spending hour sending out cusum emails with names. I said do what? Your video was great! saved me hours and hours.

[@TylerStanczak]

This is so helpful to know how to do in gmail. Thanks Kevin! :)

[@agentPLINY]

Thank you for the excellent video! Do you have video going into more depth regarding including attachments with the mail merge in Gmail?

[@erictsang789]

Kevin, your video provides a very good solution for Add-On, we worry about where the recipient's data goes. Now if this is a script within, it it awesome

[@charriekateobediente9370]

Thank you so much!!! I have to vid myself doing mail merge but my Microsoft Word and excel aren't working. Now I can pass my assignment!

[@JohanSchmidt]

Kevin - clear and concise as always! Can you show how to add a unique attachment to each email please?

[@shujaurrahman874]

One alternative is to add a new column name Attachment and add a Drive link. In the draft mention {{Attachment}}

[@brcleaningcompany2566]

Yes but what is the scrip? I’m sure you have to added it to the script also

[@gajabathiarjuntg2390]

Thanks Kevin sir for this useful tutorial. Excellent.

[@EricDongh2p]

I did something similar, I wrote a google app script that can convert a google doc template into HTML and embed the body into gmail. Benefits of this is that you add tables and images and they will be preserved when sending the email.

[@taddherron34]

Kevin, thanks for these videos. 1. There are now extensions that can be installed to handle mail merge ("Mergo..." & "Yet another..." & many more). I started to install these two extensions but found in the permissions for both, they wanted access to view & download every file I have stored in my Google Drive. I stopped looking at the extensions & went back to this script's permissions - no such requirement (no mention of Google Drive files). Thank the gods b/c I had already used this script embedded Sheets file. If someone wants to use a mail merge extension and is using Google Drive for anything you don't want shared with the company issuing the extension, then setup a new Google account only for email merging!!

[@jamesturner4683]

Good point but it's not just that. YAMM give a tiny free mail merge allowance of 50 emails which only seems to reset after you've used it all up rather than automatically resetting every 24 hours. YAMM used to allow you 50 extra emails for each person you referred to use it which got you up to a decent allowance but they took that away so you're more inclined to pay for an increased allowance.

[@WoodBernCarvings]

Thanks a lot for this video Kevin, really helpful! Anyone knows how can I make the script use MY NAME as the SENDER instead of my email? The recipient now receives an email from 'INFO' and not 'Wood Bern Carvings' Thanks in advance, Bernat

[@VickieBraga]

Hi Kevin! Loved the video. I'm using the spread sheet, left the colums you said to leave, but want to add a cc so that I have a copy of the sent email for my records. When I go into Tools, I don't see the Script Editor option. Do I need to do something to be able to access that? Are there any other options available? Thank you!!

[@jmdesiatco5729]

The script editor is under the name "Apps Script" which can be found on the Extensions menu.

[@jamesturner4683]

Thanks@@jmdesiatco5729, worked for me. Still don't understand why I can't see Scripts under Tools.

[@hannahmejilla3739]

Hi! Thank you very much for this. But I would like to know how can I make my name appear as the sender and not my email ? thank you to anyone who could answer!!

[@WoodBernCarvings]

Hi there Hannah, Did you find a solution to that problem? I'm having the same issue.

[@umarnajeebspage80]

the values seem to only work for the subject. None of the references including the first name shows up. Can you please help?

[@KevinScott-io5bc]

Great video but the first name doesn't show up. I use {{First name}} and I have tried for hours in all different scenarios of cutting and pasting and still no luck. Any help would be great.

[@KevinScott-io5bc]

@Sam Angrignon yes, after hours of messing around and it never working correctly, I started using YAMM and it works as I would expect something like this to work.

[@KevinScott-io5bc]

and YAMM is native to google so there was even less messing around.

[@whatiknow1969]

@Sam Angrignon hi, if your email font and font of the fields you copy are in different fonts it won't work. Rather copying the field, please type in the email exactly. It will work. Hope this helps.

[@whatiknow1969]

hi, if your email font and fields you copy are in different fonts it won't work. Rather copying the field, please type in the email exactly. It will work. Hope this helps.

[@qanbeetkaleem176]

@@whatiknow1969 I've tried it, by having the same font for spreadsheet and Draft mail, and only available was Verdana for both but it is also not working. So now will try using YAMM as more people are recommending it and using it. thanks.

[@mhfw]

Hi Kevin, thanks for a teaching this wonderful function. I tried it but the parameters within {{}} only worked for Recipient and Title, but did not work for the body of text. Did I do something wrong?

[@qanbeetkaleem176]

I'm having this same problem. I want to add the First name but it is not showing up in the mail. Anyone can help with that. Thanks

[@kellinwongkaixin1708]

Hi. I'm having the same problem as well. Can the author help? Thanks :)

[@rickfall5403]

I had the same issue. I re wrote the script in WORD with the {{cell heading name}} then copied and pasted it into my email draft. That fixed it.

[@brcleaningcompany2566]

Anyone has a link to templates with added features?

[@goezilla6130]

Thanks Kevin. My school teaches G sheets and so are you.

[@cryptotruth1185]

Cool bro, in India, they teach some lame government software's 😂😂😂

[@susanchilders4108]

This video is really helpful, however, the body of the email is not pulling the data? Could you help with that?

[@sharonsalvador4517]

Hi, I am wondering why it is not capturing the First name and other scripts in the bracket? thanks!

[@qanbeetkaleem176]

I'm having this same problem. I want to add the First name but it is not showing up in the mail. Anyone can help with that. Thanks

[@marctremblay4681]

Great video. I was wondering if it would be possible to include individualized attachments for each email sent. I need to send out over 500 emails with individual certificates for students. Would this be possible. Could I use the spreadsheet somehow that would link to the certificates I have saved in Google drive? Thanks

[@creativebvisions]

Did you find a solution?

[@shujaurrahman874]

One alternative is to add a new column name Attachment and add a Drive link. In the draft mention {{Attachment}}

[@brcleaningcompany2566]

Wouldn’t you have to write the new column into the script? Also

[@cristinac92]

Your tutorials are amazing. They are perfect!

[@jodihuettner2987]

Hi, unfortunately Google just flat out blocks this app for me. Is there a workaround?

[@suzetteharrell506]

Does Gmail Mail Merge allow individualized recipient attachments (like an invoice) to be sent along with each individual recipient email?

[@shawnabele8981]

I wonder if you create a link within the spreadsheet if it would transfer?!?

[@brcleaningcompany2566]

Anyone? I also would like to add attachments

[@kirankandel2967]

Sir can you teach me how to unlock my pc I am stuck at login page and there is no password bar to enter password 😢😢

[@kirankandel2967]

Please sir

[@kritikakandel3151]

Sir same problem

[@kirankandel4982]

Sir my also same problem

[@gloriasonlinediscoveries40]

Thank you very much for this, everyone else made it so confusing, but I followed along with you with no problem. You were clear and gave the best tutorial. Well done. Be safe.

[@Licrish]

I am getting an "exception" message that says "the starting column of the range is too small" Can you tell me what I may have missed?

[@elkh1945]

Hello, How to attaches personnel file for each récipient plz? Like school awards or diploma

[@MikmyRC]

I have the same doubt!

[@brcleaningcompany2566]

Looking for same

[@honglij2104]

I followed step by step. In email, the subject line was fine and pull the data from the googlesheets, but the email body was missing all those data (first name, description, due data, price). Not sure how to fix it. Any thought. Thanks.

[@teddyfabriciocordovasaenz3018]

It happened to me too, try to write word by word and take care of write without bold type

[@Bhoustonish]

Thank you Kevin. This was clear and logically arranged. You have good attention to detail. And it all worked for me first try.

[@knightbrothers533]

KEVIN YOU ARE DOING SO NICE FOR US

[@ArAdolphVincentVigorRIBA]

Sir it says "Exception: The starting column of the range is too small."

[@ankitanand6324]

Hi Kevin. Thanks for sharing this video, super helpful. 2 questions: a) What is the daily limit for the number of emails we can send through this method? b) Is there a way to include a static email ID in CC. I tried but it's not working. Pls let me know. Thanks again. -ankit

[@sagarsinghsolanki3546]

I'm also looking for the same

[@jmdesiatco5729]

a) the limit is in the video description. b) I also want answers regarding this question. So far, the "TO" should be "{{Recipient}}" on the sheet and the Draft so maybe the CC only need to have its proper wording for it to work.

[@ChrisKChandler]

The limit is discussed in the "limitations" chapter of the video, near the end! Watch the video!

[@jamesturner4683]

@@ChrisKChandler in reality at least for me the limits seem to be lower. Gmail seems to throttle how many emails you can send all at once so that limit might need to spaced out during the day.

[@lokeb48]

Thank you Kevin. Your instruction were "Spot ON" and I subscribed so I can learn more!! Awesome!!

[@jorgegeneral3757]

Thanks Kevin, I was stuggling with this. I was using an email marketing app but some of the emails went to the spam box. Keep on sharing the knowlegde.

[@rajukv8610]

Thanks for the turturioal I love it 🔰🔰

[@dr.vipulvyas6642]

Hi Kevin, thanks for the video. I tried and was successful in sending email, but could not merge first name, last name columns. Can you help please?

[@mmehan82]

You would have to do {{First}} {{Last}} as separate fields. Alternatively, you can add another column and the concatenate formula to merge the names into one cell.

[@mohammadalihussainbabla3102]

Hope you are fine. how to get the mail merge option on the google spreadsheet because it is not present with the sheet by default? Thank you very much.

[@macky2green]

*_Imagine if you are applying for a job. This would be a perfect use case scenario for mail merge._*

[@TonyEarlsTrinityLawns]

Nice and clear, we're going to use this to contact players in our bowls club.

[@saikatmitra8374]

Great Video Kavin! I am facing an issue. The custom fields are perfectly working in subject lines but not in the mail body. Can you put some light on this problem??? what can be the possible reasons???

[@trevorbruce258]

I'm getting the same thing.....

[@laurie-annbarbour2410]

I'm having the same issue. Did you get any help or were you able to make it work?

[@anthonymorton3164]

hi. i had this. try removing formatting in your draft email

[@laurie-annbarbour2410]

@@anthonymorton3164 Thanks. Yes, I was able to get it to work once all formatting was removed.

[@adamgaspar]

Bethlehem Early Learning Center 11 hónappal ezelőtt SOLVED: Fix for missing fields in Body of Email: 1. Copy/Paste field from Sheet into Subject area of email - (adding curly bracket syntax - example: {{field_name}} ) 2. Copy/paste again (from curly bracket to curly bracket) from Subject area into Body. Voila! 3. Delete field from Subject area if not needed. 4. Repeat for each field that you need in the body. Basically, I believe we must strip the formatting from the field name when inserting it into our email body, and it seemed to work best when copy/pasting from Subject area to Body.

[@joachimnordensson5044]

Thank you for the great video! Whenever I try to add in the curly brackets and copy/paste the First name cell, it pastes bold (which is different from when you do it in the video) and then in the test emails I receive, the first name of the person doesn't show up. Am I doing something wrong? Or is something not working properly in the script of the google sheet? Thank you

[@LorenzoCaimari]

@WTMinkema Same problem , it just works in the subject line , not in the body of the email

[@JoannaJadeToday]

I was able to get everything to work except the recipient name. The name never populates in the email.

[@JoannaJadeToday]

How can I export my entire contact list at once to google sheets?

[@adamgaspar]

Bethlehem Early Learning Center 11 hónappal ezelőtt SOLVED: Fix for missing fields in Body of Email: 1. Copy/Paste field from Sheet into Subject area of email - (adding curly bracket syntax - example: {{field_name}} ) 2. Copy/paste again (from curly bracket to curly bracket) from Subject area into Body. Voila! 3. Delete field from Subject area if not needed. 4. Repeat for each field that you need in the body. Basically, I believe we must strip the formatting from the field name when inserting it into our email body, and it seemed to work best when copy/pasting from Subject area to Body.

[@rajgopalaniyer8284]

Hi Kevin, tried running mail merge but its not showing the name in the body of mail. Please help

[@timakinola458]

Nice one Kev. A real thumbs up there. I've actually been following and enjoying your video tutorials..

[@patriciashawwatkins2901]

Thank you, very precise and the perfect solution to my issue. The snippet on the coding was very helpful.👏

[@del1111]

I had to try it 13 times while tweaking the tags before it finally worked. I can't tell what really was the problem but the tags were returning nothing in the sent mail. Thank you Kevin

[@brcleaningcompany2566]

Why not post a link to the template to help the community out

[@sumanthkv2453]

The name is not getting displayed in the body of the email. it is empty there. can you help

[@qanbeetkaleem176]

I'm having this same problem. I want to add the First name but it is not showing up in the mail. Anyone can help with that. Thanks

[@user-ys1yl3dd9m]

Kevin - Absolutely great tutorial. Saved me many, many hours of digging and trial-and-error. Thank you

[@minayachrisjhant.4206]

A success for me!! Maraming salamat (Thank you very much)!

[@knuckleball]

The best video regarding mail merge

[@imonkalyanbirol81]

Thanks you for this, please advise how can i send customize mail body with table format

[@MuhammadShoaib-rg5go]

For those facing issue with FIRST NAME field just keep one thing in mind, THE FORMAT OF THE NAME FIELD MUST BE SAME AS OF THE RECIEPIENT FIELD

[@CherylDFloyd]

Thank you so much for this great video! I just sent my first mail merge message to 6 recipients. Yay!

[@mohammadalihussainbabla3102]

Hope you are fine. how to get the mail merge option on the google spreadsheet because it is not present with the sheet by default? Thank you very much.

[@AlisonWalkow]

very informative and helpful!! Thank you!

[@RoeGabriel_i_EMPOWER]

thankyou Kevin - this is amazing - as usual. You & my other fave Leila G ROCK!!!

[@LeadershipLadyLive]

You made this SO EASY, Kevin!!! Thank you so much!!!

[@ginashen8974]

It’s best video so far, thanks kevin!

[@sohamsainju]

this is a great tutorial... solved my problems! thanks a ton!!

[@noorddinn]

Thanks Kevin for your highly informative videos, I am your biggest fan. whenever I am searching for information on KZbin I look to see if you have any video made on it first. I have a suggestion on a topic and while I know you have a video on Gmail but I was hoping if you could make one where how one can add yahoo accounts and others to Gmail with adding filters and such. Thanks again!

[@nancyberger4829]

Thank you Kevin, I'm new to mail merge. I was so afraid of it, Now I know with a little practice and your territorial I'll have it down in no time. Once again thank you. Nancy Berger

[@kimyaglasgow]

The BEST of all the explanations

[@uncimsd810]

This isn't adding the fields in the email I'm trying to send. Other than what's listed in Recipient and Description, nothing else gets inserted.

[@rohitbhargava1785]

Thanks Kelvin...your videos helps a lot.

[@jimekrut]

Great job, Kevin! I manage a group email list and am helping one of the group leaders personalize communication. The pre-formatted Sheet and your explanation will meet the need perfectly, thanks!

[@Pankaj-Verma-]

Thanks for sharing, Kevin. It was really helpful.

[@christopherstubbs2788]

Great video - followed instructions and worked perfectly! Thank you.

[@wasiqsuhail]

This video was very helpful, thanks alot i can confirm it works and is very simple yet efficient

[@user-rl6ge8vv4b]

Hey Kevin, Just found this Video. It was really simple and very helpful. Thanks for this.

[@carolynarce2193]

Thank you Kevin super helpful! Do you have a video where you show users how to attached different attachments specific to the recipient? Thanks!

[@HassanAnzit]

Kevin, thank you very much! After watching your channel, this was the first video I asked! Your suggestions and solutions were extremely helpful!

[@debraclark388]

Thank you. I have a question though. My emails never input the {{First Name}}. I have followed step by step and have done this multiple times and it has yet to input the name. Any suggestions?

[@qanbeetkaleem176]

I'm having this same problem. I want to add the First name but it is not showing up in the mail. Anyone can help with that. Thanks

[@leeappleton78]

@@qanbeetkaleem176 Same here

[@laurenmalizia8053]

I'm also having this issue. Any solves here?

[@adamgaspar]

Bethlehem Early Learning Center 11 hónappal ezelőtt SOLVED: Fix for missing fields in Body of Email: 1. Copy/Paste field from Sheet into Subject area of email - (adding curly bracket syntax - example: {{field_name}} ) 2. Copy/paste again (from curly bracket to curly bracket) from Subject area into Body. Voila! 3. Delete field from Subject area if not needed. 4. Repeat for each field that you need in the body. Basically, I believe we must strip the formatting from the field name when inserting it into our email body, and it seemed to work best when copy/pasting from Subject area to Body.

[@barket3206]

Very nice and helpful tutorial. Question: You showed how to change the script but not how to save it and use it, Can you please explain how?

[@miles_high]

Thank you, this is exactly what I was looking for.

[@pankajkhatnani2564]

Loved it mate, amazing, would try it soon now!

[@marilyncosby7103]

This video saved my life! lol thank you!

[@viviensfilms3604]

Thank you Kevin. Your tutoring is super simple and I followed every step to the T. I even received the confirmation that the emails were sent, but no email was in fact sent. I don't know what I did wrong.

[@in2dunknown320]

This has been very helpful, it works now! Thank you :)

[@SoundFilms]

Excellent, tutorial, thanks! Perfect for replying to casting calls we put out. Btw, are you related to the Charisma on Command Guy?

[@elisabethkrussand5956]

Hi PLS HElp, im not getting the value {{first name}} in the test mail. What could be wrong???

[@qanbeetkaleem176]

I'm having this same problem. I want to add the First name but it is not showing up in the mail. Anyone can help with that. Thanks

[@Piratessable]

Thank you so much for this clear video. Much appreciated!

[@marcoantoniocrisostomo7801]

Hi Kevin! This helps me alot. Keep up the Good Job. Thanks for this. Pressed Subscribed.

[@kelebilemokgapela9469]

Thank you so much bro, this definitely worked

[@mohammadalihussainbabla3102]

Hope you are fine. how to get the mail merge option on the google spreadsheet because it is not present with the sheet by default? Thank you very much.

[@lafamillecarrington]

I had a script (thanks to the excellent Learn Google Spreadsheets KZbin channel), but needed extra functions. This script looks perfect! Thanks.