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

[@newlightning2306]

Hi, is it possible to rename the sheet once you've saved it?

[@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.

[@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)

[@GabrielMontenegro-k5n]

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

[@kcoolnow]

@@GabrielMontenegro-k5n 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.

[@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! 😎

[@paulmuzio7473]

It is case sensitive

[@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.

[@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

[@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

[@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!

[@arjunm1137]

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

[@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!

[@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!

[@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.

[@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

[@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)?

[@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

[@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.

[@TylerStanczak]

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

[@GTSTradingIndicators]

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

[@agentPLINY]

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

[@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!

[@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?

[@cristinac92]

Your tutorials are amazing. They are perfect!

[@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.

[@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.

[@gajabathiarjuntg2390]

Thanks Kevin sir for this useful tutorial. Excellent.

[@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

[@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.

[@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.

[@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

[@minayachrisjhant.4206]

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

[@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

[@knightbrothers533]

KEVIN YOU ARE DOING SO NICE FOR US

[@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

[@shrutikolambikar8577]

This is soo useful! Thanks for sharing, Kevin!

[@ArAdolphVincentVigorRIBA]

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

[@TonyEarlsTrinityLawns]

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

[@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

[@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

[@scsnstaff5815]

Thanks!

[@KevinStratvert]

Wow, thanks so much! Much appreciated 🙏

[@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

[@timakinola458]

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

[@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.

[@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.

[@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

[@goezilla6130]

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

[@cryptotruth1185]

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

[@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.

[@chintusharma1]

01:43 Learn how to modify a Google Sheets mail merge template 03:20 Modifying column headers in mail merge 04:47 Sending personalized emails using mail merge in Gmail 06:19 Sending customized emails using mail merge in Google Sheets 07:52 Successfully run a mail merge using a trustworthy Google app 09:35 Learn how to use mail merge in Google Sheets 11:04 Mail merge using Gmail and Google Sheets is a free and effective solution for personal use.

[@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.

[@ginashen8974]

It’s best video so far, thanks kevin!

[@rajukv8610]

Thanks for the turturioal I love it 🔰🔰

[@ChristaLeeLeffers]

Hi I ve been trying this but getting this error message and it does not work: Google Apps Script Error: "The starting column of the range is too small" ???? I have emojis in the subject line. Its that a problem? HOw can I fix that? Also, I can not find the script code under Tools in the doc. No option. I downloaded and tried a new sheet and it worked but as soon as i added my list to that doc I got the same message

[@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

[@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!

[@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

[@kimyaglasgow]

The BEST of all the explanations

[@RoeGabriel_i_EMPOWER]

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

[@knuckleball]

The best video regarding mail merge

[@ginashen8974]

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

[@gjergjikokushta]

Thank you for the tip - this has been a time saviour. Just to mention that with a GMaill free account the limit is 100 emails per day. Cannot say if it is a limit per email version, say different subjects.

[@lokeb48]

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

[@pankajkhatnani2564]

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

[@ge2893]

You are the best Kevin!

[@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.

[@LeadershipLadyLive]

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

[@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?

[@macky2green]

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

[@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!

[@ChuckFingerman]

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

[@sohamsainju]

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

[@miles_high]

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

[@mindscrambler1804]

Thanks a bunch! You did a great job dude. Enjoy the day!

[@SoundFilms]

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

[@Bhoustonish]

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

[@TopgunB]

For some reason the Script Editor is no longer under Tools--it has moved to the "Extensions" menu! Thanx Kevin simple and easy- worked for me!

[@in2dunknown320]

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

[@rohitbhargava1785]

Thanks Kelvin...your videos helps a lot.

[@marilyncosby7103]

This video saved my life! lol thank you!

[@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

[@ajayspatil]

Awesome Kevin!!! Thanks a lot for this video

[@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.

[@ImmaSarah]

all emails going to spam on my side

[@johnp2106]

Very useful video. Instead having to type or copy/paste the subject line of the Gmail draft message can this be built into the sheet.

[@Pankaj-Verma-]

Thanks for sharing, Kevin. It was really helpful.

[@patriciashawwatkins2901]

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

[@HashamAnsari-t1z]

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

[@felixnoonan]

Worked for me. Thank you so much. Saves me hours

[@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

[@marcoantoniocrisostomo7801]

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

[@jasonjavier4213]

Very helpful tutorial Kevin!

[@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!

[@Piratessable]

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

[@georgebijay]

Thanks. Works as described. However, I have a couple of queries: i) Can I save the Google sheet in my PC. What are the details to activate it later in this case?. ii) How to associate Google sheet with another email account afterwards. Once used with an email account, it keeps on using the same account. iii) what are the details for using individual attachment, besides removing the comment bars from the script?.

[@tejaswichaudharicrasto7099]

Amazing video.. simply useful..! especially for people like me who are not technically expert. Thank you once again.!

[@lafamillecarrington]

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

[@djosephc1]

Great video - 1 question... if you wanted to add new email addresses to the same google sheets mail merge a day later, will it only send the email to the new contacts?

[@meetthehopeinfluencer]

Thanks you for always creating coherent videos.

[@metachildhood]

i tried with 300 recipient at once but failed then try again with 100 recipient and succeed. limit for free gmail account still 100 like Kevin said in video. mail merge is awesome, thanks