Idea Transcript
Search here..
(/)
How to Send Personalized Emails with Mail Merge in Gmail Written by Amit Agarwal (https://www.labnol.org/about/) on Sep 27, 2017
M
ail Merge for Gmail lets you easily send personalized messages to one or more email recipients. You can write a single draft email in Gmail, specify the list of email
recipients in a Google Spreadsheet and the Mail Merge program will send customized emails to all these addresses in one go.
Industry leader in IT Effectively monitor, manage, and secure your endpoint infrastructure Ad
Visit Site
LogMeIn Central
Mail Merge is a popular feature of Microsoft Outlook and, with the help of Google Scripts (https://www.labnol.org/internet/googlescripts/28281/), we can easily perform mail merge in Gmail, Google Inbox, Google Apps and G Suite accounts as well. Gmail Mail Merge (https://digitalinspiration.com/product/gmail-mailmerge) is powerful and packed with useful features. You can insert different (unique) file attachments from Google Drive (https://www.labnol.org/internet/send-file-attachments-with-mailmerge/29245/) for each recipient, the emails can be written in plain text or formatted in rich-text HTML (https://htmlmail.pro) and the email opens (https://digitalinspiration.com/gmail-email-opens-7080) can be tracked so you’ll know if an email has been read. You can also schedule merges and send your emails later at your preferred date and hour. Watch this Mail Merge video tutorial (https://www.youtube.com/watch? v=F07Py7sraDg&list=PLIO7o3VwD0X8jhC1XEIUjcbeJKnA0Yu25) to learn more.
How to do Mail Merge in Gmail To get started, install the Mail Merge add-on. You can either add it in your own Google Account or, if you are a Google Apps admin, you can install Mail Merge to all users in your G Suite domain.
Start Download - View PDF Convert From Doc to PDF, PDF to Doc Simply With The Free Online App! Ad
Visit Site
FromDocToPDF
Install Mail Merge in your Google Account (https://chrome.google.com/webstore/detail/mail-merge-withscheduler/nifmcbjailaccmombpjjpijjbfoicppp) Install Mail Merge in your Google Apps Domain (https://apps.google.com/marketplace/app/nifmcbjailaccmombpjjpijjbfoicppp) After the add-on is installed, follow these steps to get started: Go to the Google Spreadsheet, click the Add-ons menu and you’ll see a new menu called Mail merge with Attachments Click the Create Merge Template menu to clone the blank mail merge template in your Google Spreadsheet. It contains the mandatory columns – like First Name, Email Address, etc. – but you can add more columns. Go to the Import Google Contacts menu to fetch any existing contact groups from Google Contacts into Mail Merge. This saves time but you can also write the first name, email addresses and other details of the recipients manually in the Mail Merge sheet. If you wish to add unique attachments for your recipients, you can add them in the File Attachments column. Go to Google Drive, right-click a file and choose Get Link to copy the URL of that file that can paste into the sheet. You can include multiples files too but remember to separate the file URLs by comma. When you run mail merge, it will send all the mails immediately. However, you also have an option to schedule emails and the program will automatically send them later. To schedule an email, go to the Scheduled Date column and insert the date and time when you wish to schedule that particular email. Use the dd/mm/yyyy hh:mm format.
Create the Mail Merge Template Go to your Gmail or Google Inbox account and create a new draft message. You can include one or more variable fields in the email message using the {{field name}} notation and these will be replaced with the actual values from the sheet when the emails are sent. Let me explain. Say you want to send an email to a group where the content of the message body is mostly similar except a few fields like salutation, first name and city that will be unique for each message. What you need to do is add columns in the sheet for each of these variable fields. And in your Gmail Draft, your can refer to these variable fields as {{First Name}}, {{City}} and so on.
You can include file attachments in the draft message and they’ll be sent with every email. You can also include inline images, animated GIFs, and make your message stand out with rich-text formatting. Now that our template is ready, switch to the Mail Merge sheet and choose Run Mail Merge to start sending emails. Choose the Gmail draft that you created in the previous step and hit the Run button. The add-on will instantly send emails to addresses where the Scheduled Date column is blank while others would be put in the queue and will be sent automatically at your preferred date and hour.
While mail merge with Gmail is easy, you should always test your merge before sending the email blast to a large group. Just have a single data row in the spreadsheet and put your own email addresses in the Email Address column. Run Merge as before and see your Gmail Sent Items folder to make sure that your outgoing emails are as expected. Please refer to the Mail Merge Documentation (https://digitalinspiration.com/docs/gmail-mail-merge) for answers to common questions.
You'll also like: How to Create Mail Merge with Gmail and Google Sheets (https://www.labnol.org/software/mail-merge-with-gmail/13289/) How to Email Unique File Attachments using Mail Merge for Gmail (https://www.labnol.org/internet/send-file-attachments-with-mailmerge/29245/) Send HTML Emails with Gmail and Google Docs (https://www.labnol.org/internet/send-html-email/19672/) The Most Popular and Useful Google Scripts (https://www.labnol.org/internet/google-scripts/28281/)
(https://www.labnol.org/internet/google-scripts/28281/) (https://www.labnol.org/internet/google-scripts/28281/)
(/)
TUTORIALS
GMAIL
(https://www.labnol.org/tag/gmail/)
Automate your work with Google Addons
Mail Merge
T R EN D I N G
Save Emails
Email Extractor
(https://www.labnol.org/internet/personalized-mail-
(https://www.labnol.org/internet/send-gmail-to-google-
(https://www.labnol.org/internet/extract-gmail-
merge-in-gmail/20981/)
drive/21236/)
addresses/28037/)
File Upload Forms
N EW
Amazon Price Tracker
U PD A T ED
(https://www.labnol.org/internet/file-upload-google-
(https://www.labnol.org/internet/amazon-price-
forms/29170/)
tracker/28156/)
Twitter Bots
(https://www.labnol.org/internet/write-twitter-bot/27902/)
How can we help?
Get in touch
Location
Expertise
Subscribe to our Email Newsletter Email Address
SUBSCRIBE
CONTACT US (HTTPS://DOCS.GOOGLE.COM/FORMS/D/E/1FAIPQLSDXTPLMAOPVRUZKGE_XV7LZXK6XUFBEE98XNMRRKH0JUXHOYQ/VIEWFORM?ENTRY.1823440910&ENTRY.910693880&ENTRY.1551994540=I+HAVE+A+QUESTION+OR+COMMENT&ENTRY.1031080712=HTTPS://WWW.LABNOL.ORG/INTERNET/PERSONALIZED-MAIL-MERGE-IN-GMAIL/20981/%23FOOTER&ENTRY.857400982&ENTRY.467659801&ENTRY.1471550472&ENTRY.2073450133&ENTRY.1252392100&ENTRY.2066640595&ENTRY.893931147)