FYI: I dont know if the script has changed since this video was made. But you no longer need to add the {{Recipient}} template string into the "To" field as the script code already takes the {{Recipient}} column fields and saves to an Array Variable to handle this. So you can leave the "To" in the email blank and it will still work.
It is January 2024. I don't have a mail merge tag. I've built my own spreadsheet and am trying to use the 'two people' icon on the "To" line to use the built in gmail method of mail merge with a spreadsheet. But trying both {{ }} and @ for the variable names, it doesn't work.
Its not working. The body wont recognize the {{}} fields - Anyone knows what the instruction is to add field to the body of the email? or is there another command that has to be added to the MailMerge?
IF IT IS NOT WORKING READ THIS: 1. click on the 3 dots next to the bin icon in your composed mail 2. select 'Plain test mode' 3. Delete the contents of 'Email sent' in your spreadsheet. It'll work now. You're welcome ;-)😀
Can you set this up so there is a column for Attachments (referenced in Google Drive) so that each dynamic email has a file attachment as listed in the Attachments column?
For me, nothing pastes in the mail that is between the brackets. I copy, double brackets but still nothing pastes when I get the mail. How can I fix this? Thanks
Is there a way to get the script or the mail merge tab up to to save in the excel sheet permanently?? Every time I close out of the tab and come back later that day or the next day, I have to redo making the copy again and then copy and pasting the data into it again
Effortlessly send personalized bulk emails using Mail Merge in Google Sheets and Gmail. Learn the step-by-step setup and streamline your email campaigns. #MailMerge #EmailMarketing #GoogleSheets #Gmail
Copy the code paste on chatgpt type prompt add name from Google sheets whatever requirement is after that copy and paste new code replace the name with the name column in the sheet- Done
That was an excellent video very informative and helpful, kindly let me know if we can add tabs into the same spreadsheet and will that work if yes how would it work for each tab?
Thank you so much for this...do you know what can we do to add a "cc recipient" as well? Copy pasting the recipient column doesn't work, is there a fix for this?
Hello sir, Thank you so much for this tutorial, I really appreciate it. Can I send email with QR Code too with this code? (Not an Attachment) I have generate the QRCode automatically via Google Sheet.
Hi, thank you so much for your tutorial. I am using a domain email which already connected to gmail. May I ask that is this mail merge enable to send bulk emails which using the domain email as the "sender"? Because there seems no choice for the senders, but I need to send the emails by the domain email. thanks so much!
Hello, great video. I have lists of email addresses which are mainly domain emails but there are also gmail emails mixed through the lists. Can anyone tell me how i can remove the gmail emails please.
This video was very helpful. I have an issue however, once I sent the trial email, my Email sent column says” Invalid Argument”. Not sure how to proceed.
If you delete the "email sent" date stamp, it will send again, how about if you don't delete the date stamp, will it skip it or re-send the email? Just need to know a trigger to keep a log and not re-send all of them again, just the blank date stamps.
I have followed your video and I am unable to have a test email link to the first names. I am receiving Oops! can't find the Gmail draft. I would appreciate some help.
I've followed your instructions to the letter several times and I keep getting an error that says Google hasn't authorised this script. What have you done that you are not explaining in the video.
hi, can you help with an error message? "Invalid argument: inlineImages". I can successfully send the email script from my email, but I can't send it from a different email. Do you know what this might be?
I can achieve individual emails BUT am unable to add other recipient specific information in the Body of the email. I've checked I'm using {{ and }} before and after the field name. I am copying and pasting the name of each field within the curly brackets, but nothing is included in the email received. Any suggestions what else I should try? Thanks.
It seems: {{}} tags in the body of the email must be plain text "to be read by the script". I also found when I copied and pasted from Google Sheets, some headings had additional spaces, they also needed to be removed (at the start / end of the field heading), the space between eg {{First name}} worked OK, but if it had {{ First name }} that was not read.
when i do this I copies and pasted a google sheet i had already made into this format and whenever i did the merge it says failed to send "no recipient" any help??
How come I get this message "Invalid argument: inlineImages" on the email sent column when I add a pic to the email draft? Pictures are essential in the bulk emails I need to send out and I can't imagine the developers of MailMerge wouldn't create this with people like me in mind that need to attach Pictures on these emails, smh. This is frustrating please help, am I doing something wrong? There must be some way to send emails with pics right? Thanks for the video I got the test to work without tyhe pictures but anytime I add them I keep getting this message "Invalid argument: inlineImages"
Hi, I can only seem to run this **once, then the "Email Sent" is never refreshed - it goes from "Running Script" to "Finished Script" without sending anything. Do I need to reset anything to make it run again?
Spreadsheet is unmodified. Anyone knows why the placeholders in my draft email are not picking up the data in the spreadsheet. I'm copying and pasting and there is no errors in the name in the email draft. Please advise if you know what is going on. Thanks
Hello, I cannot rerun the Mail Merge - I have to download and rebuild the google sheet to get it to run. It there something that needs to be reset between runs?