HomeХобби и стильRelated VideosMore From: Chris Menard

Mail Merge for Gmail - Different attachments for each recipients by Chris Menard

78 ratings | 20113 views
You can use Gmail to perform a mail merge. The advantage of Gmail over Outlook is you can use an Add-on that is free to send different attachments to different recipients and you can also schedule delivery. Everything you need is free. A Gmail account, chrome, and google sheets which is part of Google Docs. Microsoft Outlook 2016 and previous versions of Outlook allow you to perform a mail merge also, but if you want to send an attachment it is all of nothing. Meaning every recipient gets the same attachments or they don't get any attachments. Another feature I noticed when doing the mail merge with Gmail is I can even customize the subject line. That is impossible with Outlook. Exact steps: 1. Sign into your Gmail account using Google Chrome. 2. Click on the icon for Google apps in the top right. Go to Drive. 3. When Drive opens up, click on New in the top left and select Google Sheets. 4. Click Add-ons then select Get Add-ons. Type in "mail merge with attachments" and press Enter. 5. It should be the first one. To the right click on Free and select Allow and it will be installed. 6. Click back on Add-ons and now
Html code for embedding videos on your blog
Text Comments (24)
Reginaldo Napolitano (6 days ago)
Great video! Thank you very much!
Chris Menard (6 days ago)
Thank you, Reginaldo.
Archana Shet (25 days ago)
How many emails can we send at once..? Thank you so much for this video. It helped me a lot.
Chris Menard (25 days ago)
+Archana Shet there is a limit of the free version and I think you are correct that it is 50.
Archana Shet (25 days ago)
Thanks for the response. I was actually able to send only 50 emails by using this method. Perhaps it displayed for the premium version for more than 50 emails. And yes we can send 500 emails directly through Gmail.
Chris Menard (25 days ago)
You can send 500 per day with Gmail.
Sumit Kambli (3 months ago)
how do i send diffrent attachement to different people
Chris Menard (3 months ago)
At the 02:17 mark is where you specify what attachment or attachments each person receives.
Moamar Ghazally (9 months ago)
i trying to send 10 email, but not all email receiving the attachment
Bob Warfield (9 months ago)
Many Thanks!!!
SaQuib Patel (9 months ago)
Thank You vry mch.......sir
Peeter Tiidemann (11 months ago)
Thank you very much! It was really very helpful!
Fran Mayes (1 year ago)
for some reason, my files are not attaching. I followed the instructions exactly. the files are in google drive and when I select, they do not get added to the google sheet! help, any suggestions.
Vaidehi Khavnekar (1 year ago)
Thank very much!!!It's very helpful.
Psic. Franck Ayon (1 year ago)
awesome sir!!! thanks a lot!!!
Chris Menard (1 year ago)
I'm glad it helped.
Samuel Hutchinson (2 years ago)
Hello, how are you? Just wondering if there is a way that we can send an attachment based on its file name? For example, if we have a column in our mail merge google sheet as 'Customer Numbers', and the PDF is named 'Customer number'2016, is there a way we can automatically search that and send the attachment without having to select the PDFS for say 200 customer emails? For example, customer number is 1234, and the PDF file would be 12342016. Can we get that to automatically populate the link based on the file name to send to that customer? Thanks heaps :)
Chris Menard (2 years ago)
The problem is Google Drive problem. If I have a file named 12342016.pdf and get the link for it, it give me that crazy code. Example: https://drive.google.com/open?id=0B84qterereeere333$$$$QOHlxT0k If it gave me https://drive/google/Customers/1234206.pdf with the file name and folder structure, I could get it to probably get it to work with a Concatentate function.
Samuel Hutchinson (2 years ago)
No, they are each getting a different PDF, with the filename being their customer number followed by the year. i.e. Customer 1234 will be sent the PDF named 12342016.pdf?
Chris Menard (2 years ago)
In your example, are the 200 customers getting the same PDF?
Thuong Nguyen (2 years ago)
Thanks very much, it really helps :)
Chris Menard (2 years ago)
Glad it helped.
Dennis Daniels (2 years ago)
Thanks for posting!
Chris Menard (2 years ago)
No problem. I hope it helped.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.