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
@edwardpovey55682 жыл бұрын
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!
@jonfortier96142 жыл бұрын
Thanks for the info, I was struggling with this as well.
@shikhagoli2 жыл бұрын
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.
@MrEdpovey2 жыл бұрын
@@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.
@cybraxe2 жыл бұрын
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.
@ankithabhaskara34083 жыл бұрын
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.
@MrsOConnorsMusic2 жыл бұрын
THIS! Thanks so much for this info you are right and I don't understand why but, it finally worked!
@WileyB9152 жыл бұрын
it finally worked for me too! thank you!
@190harpreet6 ай бұрын
OMG! This was awesome!
@ArtemKozlov-j3p25 күн бұрын
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.
@kcoolnow7 ай бұрын
This still works three years later. Really great for non-profits trying to do constituent updates. Thank you!
@jawaadkhan52386 ай бұрын
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-tr1zt1mq7h6 ай бұрын
How do you have the "Mail Merge" option in Google Sheets? Mine does not have this.
@kcoolnow6 ай бұрын
@@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!
@kcoolnow6 ай бұрын
@@jawaadkhan5238 Huh! Maybe you need a business account?
@kcoolnow6 ай бұрын
@@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.
@truthseeker3182 жыл бұрын
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?
@bethlehemearlylearningcent66093 жыл бұрын
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.
@navoditthakral82212 жыл бұрын
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!
@kshitijkulshreshtha501712 күн бұрын
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
@GTSTradingIndicators8 күн бұрын
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.
@tremsmom82743 жыл бұрын
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.
@kenn526918 күн бұрын
did you ever figure out how to invoke CC (as a mail merge, not to a static address)?
@aditya_suresh3 жыл бұрын
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!
@zeno27123 жыл бұрын
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!
@arjunm11373 жыл бұрын
Thanks Kevin Is it possible to send different attachments for different person using mail merge.
@kathijenmurphy97503 жыл бұрын
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.
@6059nuy2 жыл бұрын
What Jesus Castellanos posted here worked.
@mpumelelontozakhe37152 жыл бұрын
same and I have said to call it a quit
@ginashen89742 жыл бұрын
To everyone have same problem don’t show {{ first name}} Change draft to “ Plan Text Mode” when you paste it.
@theenglisheducator76895 ай бұрын
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!
@tenaciousshaman3 жыл бұрын
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.
@No1TV4CATS3 жыл бұрын
Did you find a solution? I am trying to develop the same idea. Thanks.
@marcelorox3112 жыл бұрын
You could just make a discord channel
@danilag.badiola29882 жыл бұрын
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!
@jesuscastellanos99852 жыл бұрын
I resolved this issue by copying my email draft and pasting it as plain text. I'm assuming my formating was causing the issue.
@BenUlin2 жыл бұрын
@@jesuscastellanos9985 Thanks! This solved my problem as well.
@michaelholden912 жыл бұрын
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.
@anthonyokon80362 жыл бұрын
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.
@tracyhruska31462 жыл бұрын
How do you change everything to plain text
@esmebollenbeck17272 жыл бұрын
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.
@charleyheironimus69102 жыл бұрын
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.
@TylerStanczak3 жыл бұрын
This is so helpful to know how to do in gmail. Thanks Kevin! :)
@agentPLINY3 жыл бұрын
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!
@JohanSchmidt3 жыл бұрын
Kevin - clear and concise as always! Can you show how to add a unique attachment to each email please?
@shujaurrahman8742 жыл бұрын
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
@gajabathiarjuntg23903 жыл бұрын
Thanks Kevin sir for this useful tutorial. Excellent.
@EricDongh2p2 жыл бұрын
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.
@taddherron342 жыл бұрын
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!!
@jamesturner46835 ай бұрын
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.
@jamesturner46835 ай бұрын
Thanks@@jmdesiatco5729, worked for me. Still don't understand why I can't see Scripts under Tools.
@hannahmejilla37392 жыл бұрын
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.
@umarnajeebspage802 жыл бұрын
the values seem to only work for the subject. None of the references including the first name shows up. Can you please help?
@KevinScott-io5bc3 жыл бұрын
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-io5bc3 жыл бұрын
@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-io5bc3 жыл бұрын
and YAMM is native to google so there was even less messing around.
@whatiknow19693 жыл бұрын
@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.
@whatiknow19693 жыл бұрын
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.
@qanbeetkaleem1763 жыл бұрын
@@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.
@mhfw3 жыл бұрын
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?
@qanbeetkaleem1763 жыл бұрын
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
@kellinwongkaixin17083 жыл бұрын
Hi. I'm having the same problem as well. Can the author help? Thanks :)
@rickfall54032 жыл бұрын
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?
@goezilla61303 жыл бұрын
Thanks Kevin. My school teaches G sheets and so are you.
@cryptotruth11853 жыл бұрын
Cool bro, in India, they teach some lame government software's 😂😂😂
@susanchilders41083 жыл бұрын
This video is really helpful, however, the body of the email is not pulling the data? Could you help with that?
@sharonsalvador45173 жыл бұрын
Hi, I am wondering why it is not capturing the First name and other scripts in the bracket? thanks!
@qanbeetkaleem1763 жыл бұрын
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
@marctremblay46813 жыл бұрын
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
@creativebvisions2 жыл бұрын
Did you find a solution?
@shujaurrahman8742 жыл бұрын
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
@cristinac925 ай бұрын
Your tutorials are amazing. They are perfect!
@jodihuettner29872 жыл бұрын
Hi, unfortunately Google just flat out blocks this app for me. Is there a workaround?
@suzetteharrell5063 жыл бұрын
Does Gmail Mail Merge allow individualized recipient attachments (like an invoice) to be sent along with each individual recipient email?
@shawnabele89813 жыл бұрын
I wonder if you create a link within the spreadsheet if it would transfer?!?
@brcleaningcompany2566Ай бұрын
Anyone? I also would like to add attachments
@kirankandel29673 жыл бұрын
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 😢😢
@kirankandel29673 жыл бұрын
Please sir
@kritikakandel31513 жыл бұрын
Sir same problem
@kirankandel49823 жыл бұрын
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.
@Licrish2 жыл бұрын
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?
@elkh19453 жыл бұрын
Hello, How to attaches personnel file for each récipient plz? Like school awards or diploma
@MikmyRC3 жыл бұрын
I have the same doubt!
@brcleaningcompany2566Ай бұрын
Looking for same
@honglij21043 жыл бұрын
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.
@teddyfabriciocordovasaenz30183 жыл бұрын
It happened to me too, try to write word by word and take care of write without bold type
@Bhoustonish2 жыл бұрын
Thank you Kevin. This was clear and logically arranged. You have good attention to detail. And it all worked for me first try.
@knightbrothers5333 жыл бұрын
KEVIN YOU ARE DOING SO NICE FOR US
@ArAdolphVincentVigorRIBA3 жыл бұрын
Sir it says "Exception: The starting column of the range is too small."
@ankitanand63243 жыл бұрын
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.
@ChrisKChandler8 ай бұрын
The limit is discussed in the "limitations" chapter of the video, near the end! Watch the video!
@jamesturner46835 ай бұрын
@@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.
@lokeb482 жыл бұрын
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.
@rajukv86103 жыл бұрын
Thanks for the turturioal I love it 🔰🔰
@dr.vipulvyas66423 жыл бұрын
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?
@mmehan823 жыл бұрын
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.
@mohammadalihussainbabla31023 жыл бұрын
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.
@macky2green3 жыл бұрын
*_Imagine if you are applying for a job. This would be a perfect use case scenario for mail merge._*
@TonyEarlsTrinityLawns2 жыл бұрын
Nice and clear, we're going to use this to contact players in our bowls club.
@saikatmitra83743 жыл бұрын
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???
@trevorbruce2583 жыл бұрын
I'm getting the same thing.....
@laurie-annbarbour24103 жыл бұрын
I'm having the same issue. Did you get any help or were you able to make it work?
@anthonymorton31642 жыл бұрын
hi. i had this. try removing formatting in your draft email
@laurie-annbarbour24102 жыл бұрын
@@anthonymorton3164 Thanks. Yes, I was able to get it to work once all formatting was removed.
@adamgaspar2 жыл бұрын
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.
@joachimnordensson50443 жыл бұрын
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
@LorenzoCaimari3 жыл бұрын
@WTMinkema Same problem , it just works in the subject line , not in the body of the email
@JoannaJadeToday2 жыл бұрын
I was able to get everything to work except the recipient name. The name never populates in the email.
@JoannaJadeToday2 жыл бұрын
How can I export my entire contact list at once to google sheets?
@adamgaspar2 жыл бұрын
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.
@rajgopalaniyer82842 жыл бұрын
Hi Kevin, tried running mail merge but its not showing the name in the body of mail. Please help
@timakinola4582 жыл бұрын
Nice one Kev. A real thumbs up there. I've actually been following and enjoying your video tutorials..
@patriciashawwatkins29015 ай бұрын
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
@sumanthkv24533 жыл бұрын
The name is not getting displayed in the body of the email. it is empty there. can you help
@qanbeetkaleem1763 жыл бұрын
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.42063 жыл бұрын
A success for me!! Maraming salamat (Thank you very much)!
@knuckleball Жыл бұрын
The best video regarding mail merge
@imonkalyanbirol812 жыл бұрын
Thanks you for this, please advise how can i send customize mail body with table format
@MuhammadShoaib-rg5go16 күн бұрын
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
@CherylDFloyd3 жыл бұрын
Thank you so much for this great video! I just sent my first mail merge message to 6 recipients. Yay!
@mohammadalihussainbabla31023 жыл бұрын
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!!!
@ginashen89742 жыл бұрын
It’s best video so far, thanks kevin!
@sohamsainju2 жыл бұрын
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!
@nancyberger48292 жыл бұрын
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
@uncimsd8102 жыл бұрын
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.
@rohitbhargava17852 жыл бұрын
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-3 жыл бұрын
Thanks for sharing, Kevin. It was really helpful.
@christopherstubbs27882 жыл бұрын
Great video - followed instructions and worked perfectly! Thank you.
@wasiqsuhail3 ай бұрын
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!
@HassanAnzit3 жыл бұрын
Kevin, thank you very much! After watching your channel, this was the first video I asked! Your suggestions and solutions were extremely helpful!
@debraclark3883 жыл бұрын
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?
@qanbeetkaleem1763 жыл бұрын
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
@leeappleton783 жыл бұрын
@@qanbeetkaleem176 Same here
@laurenmalizia80533 жыл бұрын
I'm also having this issue. Any solves here?
@adamgaspar2 жыл бұрын
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.
@barket32062 жыл бұрын
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_high5 ай бұрын
Thank you, this is exactly what I was looking for.
@pankajkhatnani25642 ай бұрын
Loved it mate, amazing, would try it soon now!
@marilyncosby71032 жыл бұрын
This video saved my life! lol thank you!
@viviensfilms36042 жыл бұрын
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.
@in2dunknown3204 ай бұрын
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?
@elisabethkrussand59563 жыл бұрын
Hi PLS HElp, im not getting the value {{first name}} in the test mail. What could be wrong???
@qanbeetkaleem1763 жыл бұрын
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
@Piratessable2 жыл бұрын
Thank you so much for this clear video. Much appreciated!
@marcoantoniocrisostomo780110 ай бұрын
Hi Kevin! This helps me alot. Keep up the Good Job. Thanks for this. Pressed Subscribed.
@kelebilemokgapela94693 жыл бұрын
Thank you so much bro, this definitely worked
@mohammadalihussainbabla31023 жыл бұрын
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.
@lafamillecarrington2 жыл бұрын
I had a script (thanks to the excellent Learn Google Spreadsheets KZbin channel), but needed extra functions. This script looks perfect! Thanks.