Mail Merge in Google Sheets & Gmail (for free)

  Рет қаралды 749,360

Kevin Stratvert

Kevin Stratvert

Күн бұрын

In this step-by-step tutorial, learn how to Mail Merge using Gmail together with Google Sheets. This solution to mail merge is free.
👋 Additional resources:
- Get Mail Merge spreadsheet: developers.google.com/gsuite/...
- Gmail Daily Recipient Limits: developers.google.com/apps-sc...
⌚ Timestamps
0:00 Introduction
1:06 Get Mail Merge spreadsheet
1:54 Choose location for spreadsheet
2:19 Prepare spreadsheet for Mail Merge
4:50 Prepare draft email for Mail Merge
7:13 Authorize script
8:18 Run Mail Merge
8:50 Review Mail Merge
9:59 Advanced capabilities, like cc and bcc
11:37 Email send limits
12:15 Wrap up
📃 Watch related playlists and videos
- Playlist with all my Google product videos: • How to use Google Prod...
- Playlist with all my Mail Merge videos: • Mail Merge
🚩 Connect with me on social:
- LinkedIn: / kevinstratvert
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
🔔 Subscribe to my KZfaq channel
kzfaq.info?...
🎬 Want to watch again? Navigate back to my KZfaq channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#gmail #sheets #MailMerge

Пікірлер: 1 000
@KevinStratvert
@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
@edwardpovey5568 2 жыл бұрын
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
@jonfortier9614 2 жыл бұрын
Thanks for the info, I was struggling with this as well.
@shikhagoli
@shikhagoli 2 жыл бұрын
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
@MrEdpovey 2 жыл бұрын
@@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
@cybraxe Жыл бұрын
Hey can anyone indicate why after row 8 it stops printing the time just the date any way to fix this? Please
@chrisrobinson9994
@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.
@truthseeker318
@truthseeker318 2 жыл бұрын
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
@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?
@sivarajanv6617
@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.
@kevinlncconsulting
@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!
@aditya_suresh
@aditya_suresh 3 жыл бұрын
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!
@bethlehemearlylearningcent6609
@bethlehemearlylearningcent6609 3 жыл бұрын
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
@navoditthakral8221 2 жыл бұрын
worked
@JY-qb6hx
@JY-qb6hx Жыл бұрын
It worked for me too? Any idea why?
@gherasimiulian4134
@gherasimiulian4134 Жыл бұрын
Thanks, that helped Any idea how many can i send
@denisjohnco4549
@denisjohnco4549 16 күн бұрын
After nearly giving up I found this comment and it works!
@indraneelmitra5632
@indraneelmitra5632 Жыл бұрын
Hi Kevin, I was desperately searching for the Mail Merger procedure on KZfaq. 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
@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
@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.
@gloriasonlinediscoveries40
@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.
@gajabathiarjuntg2390
@gajabathiarjuntg2390 3 жыл бұрын
Thanks Kevin sir for this useful tutorial. Excellent.
@ankithabhaskara3408
@ankithabhaskara3408 2 жыл бұрын
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
@MrsOConnorsMusic 2 жыл бұрын
THIS! Thanks so much for this info you are right and I don't understand why but, it finally worked!
@WileyB915
@WileyB915 2 жыл бұрын
it finally worked for me too! thank you!
@190harpreet
@190harpreet 5 ай бұрын
OMG! This was awesome!
@jimekrut
@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!
@HassanAnzit
@HassanAnzit 3 жыл бұрын
Kevin, thank you very much! After watching your channel, this was the first video I asked! Your suggestions and solutions were extremely helpful!
@kcoolnow
@kcoolnow 5 ай бұрын
This still works three years later. Really great for non-profits trying to do constituent updates. Thank you!
@jawaadkhan5238
@jawaadkhan5238 5 ай бұрын
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
@user-tr1zt1mq7h 5 ай бұрын
How do you have the "Mail Merge" option in Google Sheets? Mine does not have this.
@kcoolnow
@kcoolnow 5 ай бұрын
@@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
@kcoolnow 5 ай бұрын
@@jawaadkhan5238 Huh! Maybe you need a business account?
@kcoolnow
@kcoolnow 5 ай бұрын
@@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.
@tremsmom8274
@tremsmom8274 2 жыл бұрын
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.
@Bhoustonish
@Bhoustonish 2 жыл бұрын
Thank you Kevin. This was clear and logically arranged. You have good attention to detail. And it all worked for me first try.
@CherylDFloyd
@CherylDFloyd 3 жыл бұрын
Thank you so much for this great video! I just sent my first mail merge message to 6 recipients. Yay!
@mohammadalihussainbabla3102
@mohammadalihussainbabla3102 3 жыл бұрын
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.
@arjunm1137
@arjunm1137 3 жыл бұрын
Thanks Kevin Is it possible to send different attachments for different person using mail merge.
@agentPLINY
@agentPLINY 3 жыл бұрын
Thank you for the excellent video! Do you have video going into more depth regarding including attachments with the mail merge in Gmail?
@charleyheironimus6910
@charleyheironimus6910 2 жыл бұрын
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.
@user-ys1yl3dd9m
@user-ys1yl3dd9m 11 ай бұрын
Kevin - Absolutely great tutorial. Saved me many, many hours of digging and trial-and-error. Thank you
@rajukv8610
@rajukv8610 3 жыл бұрын
Thanks for the turturioal I love it 🔰🔰
@kathijenmurphy9750
@kathijenmurphy9750 2 жыл бұрын
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
@6059nuy 2 жыл бұрын
What Jesus Castellanos posted here worked.
@mpumelelontozakhe3715
@mpumelelontozakhe3715 Жыл бұрын
same and I have said to call it a quit
@erictsang789
@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
@nancyberger4829
@nancyberger4829 2 жыл бұрын
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
@danilag.badiola2988
@danilag.badiola2988 2 жыл бұрын
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
@jesuscastellanos9985 2 жыл бұрын
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
@BenUlin 2 жыл бұрын
@@jesuscastellanos9985 Thanks! This solved my problem as well.
@michaelholden91
@michaelholden91 2 жыл бұрын
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
@anthonyokon8036 2 жыл бұрын
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
@tracyhruska3146 Жыл бұрын
How do you change everything to plain text
@tenaciousshaman
@tenaciousshaman 3 жыл бұрын
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
@No1TV4CATS 3 жыл бұрын
Did you find a solution? I am trying to develop the same idea. Thanks.
@marcelorox311
@marcelorox311 2 жыл бұрын
You could just make a discord channel
@viviensfilms3604
@viviensfilms3604 2 жыл бұрын
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.
@lokeb48
@lokeb48 2 жыл бұрын
Thank you Kevin. Your instruction were "Spot ON" and I subscribed so I can learn more!! Awesome!!
@JohanSchmidt
@JohanSchmidt 3 жыл бұрын
Kevin - clear and concise as always! Can you show how to add a unique attachment to each email please?
@shujaurrahman874
@shujaurrahman874 2 жыл бұрын
One alternative is to add a new column name Attachment and add a Drive link. In the draft mention {{Attachment}}
@brcleaningcompany2566
@brcleaningcompany2566 5 күн бұрын
Yes but what is the scrip? I’m sure you have to added it to the script also
@ArAdolphVincentVigorRIBA
@ArAdolphVincentVigorRIBA 3 жыл бұрын
Sir it says "Exception: The starting column of the range is too small."
@lafamillecarrington
@lafamillecarrington 2 жыл бұрын
I had a script (thanks to the excellent Learn Google Spreadsheets KZfaq channel), but needed extra functions. This script looks perfect! Thanks.
@knightbrothers533
@knightbrothers533 3 жыл бұрын
KEVIN YOU ARE DOING SO NICE FOR US
@ankitanand6324
@ankitanand6324 3 жыл бұрын
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
@sagarsinghsolanki3546 Жыл бұрын
I'm also looking for the same
@jmdesiatco5729
@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
@ChrisKChandler 7 ай бұрын
The limit is discussed in the "limitations" chapter of the video, near the end! Watch the video!
@jamesturner4683
@jamesturner4683 3 ай бұрын
@@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.
@VickieBraga
@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
@jmdesiatco5729 Жыл бұрын
The script editor is under the name "Apps Script" which can be found on the Extensions menu.
@jamesturner4683
@jamesturner4683 3 ай бұрын
Thanks@@jmdesiatco5729, worked for me. Still don't understand why I can't see Scripts under Tools.
@NishanSaliya
@NishanSaliya 2 жыл бұрын
Thank you so much @Kevin. This was really helpful and a superb video. It is good that you covered small editing for the script as well as touched the limitations of the script (daily emails count). Very useful video indeed!
@glenicemariano6939
@glenicemariano6939 2 жыл бұрын
where did you find the script for daily emails count?
@NishanSaliya
@NishanSaliya 2 жыл бұрын
@@glenicemariano6939 I meant the "limitation to the daily email count". Google has a restriction and he points that out too.
@timakinola458
@timakinola458 2 жыл бұрын
Nice one Kev. A real thumbs up there. I've actually been following and enjoying your video tutorials..
@WoodBernCarvings
@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
@TylerStanczak
@TylerStanczak 3 жыл бұрын
This is so helpful to know how to do in gmail. Thanks Kevin! :)
@technologyinternetmadeeasy2560
@technologyinternetmadeeasy2560 3 жыл бұрын
What an excellent video. Really well organized!
@minayachrisjhant.4206
@minayachrisjhant.4206 3 жыл бұрын
A success for me!! Maraming salamat (Thank you very much)!
@marctremblay4681
@marctremblay4681 3 жыл бұрын
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
@creativebvisions 2 жыл бұрын
Did you find a solution?
@shujaurrahman874
@shujaurrahman874 2 жыл бұрын
One alternative is to add a new column name Attachment and add a Drive link. In the draft mention {{Attachment}}
@brcleaningcompany2566
@brcleaningcompany2566 5 күн бұрын
Wouldn’t you have to write the new column into the script? Also
@suzetteharrell506
@suzetteharrell506 3 жыл бұрын
Does Gmail Mail Merge allow individualized recipient attachments (like an invoice) to be sent along with each individual recipient email?
@shawnabele8981
@shawnabele8981 3 жыл бұрын
I wonder if you create a link within the spreadsheet if it would transfer?!?
@brcleaningcompany2566
@brcleaningcompany2566 5 күн бұрын
Anyone? I also would like to add attachments
@Pankaj-Verma-
@Pankaj-Verma- 3 жыл бұрын
Thanks for sharing, Kevin. It was really helpful.
@LeadershipLadyLive
@LeadershipLadyLive Жыл бұрын
You made this SO EASY, Kevin!!! Thank you so much!!!
@sharonsalvador4517
@sharonsalvador4517 3 жыл бұрын
Hi, I am wondering why it is not capturing the First name and other scripts in the bracket? thanks!
@qanbeetkaleem176
@qanbeetkaleem176 3 жыл бұрын
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
@christopherstubbs2788
@christopherstubbs2788 2 жыл бұрын
Great video - followed instructions and worked perfectly! Thank you.
@cristinac92
@cristinac92 4 ай бұрын
Your tutorials are amazing. They are perfect!
@mhfw
@mhfw 3 жыл бұрын
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
@qanbeetkaleem176 3 жыл бұрын
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
@kellinwongkaixin1708 2 жыл бұрын
Hi. I'm having the same problem as well. Can the author help? Thanks :)
@rickfall5403
@rickfall5403 2 жыл бұрын
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
@brcleaningcompany2566 5 күн бұрын
Anyone has a link to templates with added features?
@honglij2104
@honglij2104 3 жыл бұрын
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
@teddyfabriciocordovasaenz3018 3 жыл бұрын
It happened to me too, try to write word by word and take care of write without bold type
@taddherron34
@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
@jamesturner4683 3 ай бұрын
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.
@jorgegeneral3757
@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.
@joachimnordensson5044
@joachimnordensson5044 3 жыл бұрын
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
@LorenzoCaimari 3 жыл бұрын
@WTMinkema Same problem , it just works in the subject line , not in the body of the email
@JoannaJadeToday
@JoannaJadeToday 2 жыл бұрын
I was able to get everything to work except the recipient name. The name never populates in the email.
@JoannaJadeToday
@JoannaJadeToday 2 жыл бұрын
How can I export my entire contact list at once to google sheets?
@adamgaspar
@adamgaspar 2 жыл бұрын
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.
@dr.vipulvyas6642
@dr.vipulvyas6642 3 жыл бұрын
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
@mmehan82 3 жыл бұрын
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
@mohammadalihussainbabla3102 3 жыл бұрын
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.
@SyedMuzammilMahasanShahi
@SyedMuzammilMahasanShahi 3 жыл бұрын
Thanks Kevin for this helpful video.
@SweetJohnnyCage
@SweetJohnnyCage 2 жыл бұрын
Thank you so much for this great tutorial!!!
@elkh1945
@elkh1945 3 жыл бұрын
Hello, How to attaches personnel file for each récipient plz? Like school awards or diploma
@MikmyRC
@MikmyRC 3 жыл бұрын
I have the same doubt!
@brcleaningcompany2566
@brcleaningcompany2566 5 күн бұрын
Looking for same
@saikatmitra8374
@saikatmitra8374 3 жыл бұрын
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
@trevorbruce258 3 жыл бұрын
I'm getting the same thing.....
@laurie-annbarbour2410
@laurie-annbarbour2410 3 жыл бұрын
I'm having the same issue. Did you get any help or were you able to make it work?
@anthonymorton3164
@anthonymorton3164 2 жыл бұрын
hi. i had this. try removing formatting in your draft email
@laurie-annbarbour2410
@laurie-annbarbour2410 2 жыл бұрын
@@anthonymorton3164 Thanks. Yes, I was able to get it to work once all formatting was removed.
@adamgaspar
@adamgaspar 2 жыл бұрын
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.
@rohitbhargava1785
@rohitbhargava1785 2 жыл бұрын
Thanks Kelvin...your videos helps a lot.
@TonyEarlsTrinityLawns
@TonyEarlsTrinityLawns 2 жыл бұрын
Nice and clear, we're going to use this to contact players in our bowls club.
@KevinScott-io5bc
@KevinScott-io5bc 3 жыл бұрын
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.
@cansam2905
@cansam2905 3 жыл бұрын
did you find solution
@KevinScott-io5bc
@KevinScott-io5bc 3 жыл бұрын
@@cansam2905 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
@KevinScott-io5bc 3 жыл бұрын
and YAMM is native to google so there was even less messing around.
@cansam2905
@cansam2905 3 жыл бұрын
Thank you so much
@whatiknow1969
@whatiknow1969 3 жыл бұрын
@@cansam2905 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.
@kirankandel2967
@kirankandel2967 3 жыл бұрын
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
@kirankandel2967 3 жыл бұрын
Please sir
@kritikakandel3151
@kritikakandel3151 3 жыл бұрын
Sir same problem
@kirankandel4982
@kirankandel4982 3 жыл бұрын
Sir my also same problem
@ginashen8974
@ginashen8974 2 жыл бұрын
It’s best video so far, thanks kevin!
@parsaslearningworld2723
@parsaslearningworld2723 3 жыл бұрын
Happy Holiday beautiful you’re very hardworking Keep going... And stay tuned 😉 big like
@mindscrambler1804
@mindscrambler1804 2 жыл бұрын
Thanks a bunch! You did a great job dude. Enjoy the day!
@kevinpouch7720
@kevinpouch7720 2 жыл бұрын
This worked great!! Thanks for the instruction and the links. Perfect!!
@sujathik
@sujathik 3 жыл бұрын
Thank you for this video !! Awesome !!
@chuckarmstrong7064
@chuckarmstrong7064 3 жыл бұрын
Very helpful on using a mail merge process, thanks
@meetthehopeinfluencer
@meetthehopeinfluencer 2 жыл бұрын
Thanks you for always creating coherent videos.
@Piratessable
@Piratessable 2 жыл бұрын
Thank you so much for this clear video. Much appreciated!
@ayandapeter1681
@ayandapeter1681 3 жыл бұрын
Just want to say thank you so much Sir, highly appreciated. South Africa
@tharunaadhithya4352
@tharunaadhithya4352 3 жыл бұрын
Thank you Kevin, It would be helpful for my father's company
@toxidrop
@toxidrop 3 жыл бұрын
Now I know how to mail merge! Thumbs up
@theresasherwood7937
@theresasherwood7937 2 жыл бұрын
Thank you Kevin- very helpful!
@muffizainu
@muffizainu 2 жыл бұрын
This was super helpful. Thank you!
@kimyaglasgow
@kimyaglasgow 11 ай бұрын
The BEST of all the explanations
@kelebilemokgapela9469
@kelebilemokgapela9469 3 жыл бұрын
Thank you so much bro, this definitely worked
@mohammadalihussainbabla3102
@mohammadalihussainbabla3102 3 жыл бұрын
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.
@pankajkhatnani2564
@pankajkhatnani2564 Ай бұрын
Loved it mate, amazing, would try it soon now!
@marilyncosby7103
@marilyncosby7103 2 жыл бұрын
This video saved my life! lol thank you!
@abbamthsinvest2480
@abbamthsinvest2480 3 жыл бұрын
Thank you very much straight forward an easy to follow.
@ZAYNEXX
@ZAYNEXX 3 жыл бұрын
This is really helpful. Thank you !
@knuckleball
@knuckleball Жыл бұрын
The best video regarding mail merge
@RoeGabriel_i_EMPOWER
@RoeGabriel_i_EMPOWER Жыл бұрын
thankyou Kevin - this is amazing - as usual. You & my other fave Leila G ROCK!!!
@sohamsainju
@sohamsainju Жыл бұрын
this is a great tutorial... solved my problems! thanks a ton!!
@saisridarsivaprakasam1683
@saisridarsivaprakasam1683 2 жыл бұрын
Thank you so much @Kevin. Wonderful, it all worked for me first try. Many thanks..
@ajayspatil
@ajayspatil Жыл бұрын
Awesome Kevin!!! Thanks a lot for this video
@monicachavira1525
@monicachavira1525 2 жыл бұрын
Thank you so much for this helpful video!
@mdzmohamaddanial33
@mdzmohamaddanial33 2 жыл бұрын
Thanks A lot Bro!, really easy to follow and yeah pin point explanation and direct, well you just earn a subscriber here
@akankshaarora2428
@akankshaarora2428 2 жыл бұрын
Hey, this was really helpful. Thank you!!
@Mfitwellness
@Mfitwellness 2 жыл бұрын
Thank u for sharing Kevin, it do helped.
@Tech-wp5zj
@Tech-wp5zj 3 жыл бұрын
As always this one is one of your greatest works Kevin and if you make the tutorials of web designing it would be so much great and your subscribers will be double. I'm searching for tutorials of the web designing on youtube but none of them can teach in the way that you do. I'm looking for your reply with a suggestion about the web designing tutorials.Thank you!
@miles_high
@miles_high 4 ай бұрын
Thank you, this is exactly what I was looking for.
@patriciashawwatkins2901
@patriciashawwatkins2901 3 ай бұрын
Thank you, very precise and the perfect solution to my issue. The snippet on the coding was very helpful.👏
@user-rl6ge8vv4b
@user-rl6ge8vv4b 11 ай бұрын
Hey Kevin, Just found this Video. It was really simple and very helpful. Thanks for this.
@Wizardofoz1981
@Wizardofoz1981 3 жыл бұрын
Thank you, Kevin. 🙏😁
@in2dunknown320
@in2dunknown320 2 ай бұрын
This has been very helpful, it works now! Thank you :)
@mickdavies1692
@mickdavies1692 3 жыл бұрын
Great tutorial, many thanks
@wasiqsuhail
@wasiqsuhail 2 ай бұрын
This video was very helpful, thanks alot i can confirm it works and is very simple yet efficient
@brilliantpy
@brilliantpy Жыл бұрын
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
@aceleonline1358
@aceleonline1358 2 жыл бұрын
Thanks so much! Very helpful. I didn't see any of the advanced features under "tools" at the end, but maybe that will populate after I use it in the future. Any suggestions for how to make sure that populates, though, would be appreciated!
Send Personalized BULK Emails in Gmail (for FREE)!
6:50
Jeff Su
Рет қаралды 531 М.
THE POLICE TAKES ME! feat @PANDAGIRLOFFICIAL #shorts
00:31
PANDA BOI
Рет қаралды 25 МЛН
Русалка
01:00
История одного вокалиста
Рет қаралды 6 МЛН
KINDNESS ALWAYS COME BACK
00:59
dednahype
Рет қаралды 151 МЛН
Google Sheets Tutorial for Beginners
49:11
Kevin Stratvert
Рет қаралды 665 М.
Why Is Everyone Ditching Gmail?
12:21
Logically Answered
Рет қаралды 997 М.
5 Google Sheets Tips Every User Should Know!
12:02
Simpletivity
Рет қаралды 669 М.
🧙‍♂️ Top 15 Gmail Tips & Tricks
19:36
Kevin Stratvert
Рет қаралды 1,1 МЛН
Mail Merge Google Sheets to Google Docs - No Addons - Apps Script Tutorial
32:03
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 162 М.
Beginners Google Sheets Tutorial - Lesson 1
43:16
Teacher's Tech
Рет қаралды 189 М.
Мой инст: denkiselef. Как забрать телефон через экран.
0:54
Зачем ЭТО электрику? #секрет #прибор #энерголикбез
0:56
Александр Мальков
Рет қаралды 407 М.
OZON РАЗБИЛИ 3 КОМПЬЮТЕРА
0:57
Кинг Комп Shorts
Рет қаралды 1,8 МЛН
Как удвоить напряжение? #электроника #умножитель
1:00
Hi Dev! – Электроника
Рет қаралды 642 М.
Красиво, но телефон жаль
0:32
Бесполезные Новости
Рет қаралды 963 М.