Learn Step by Step Guide -How to Setup mail merge in 2015:
Today i will Show you how to create a Mail Merge by Using Gmail and also Google Drive ,i was searching this one and finally i got on Labnol.org ,it’s amazing so share it here.Mail Merge is one of the Program and it’s allows you to send your personalized email’s to multiple contacts with just one Button Click.he individual mail messages have the exact same content however some portions of the message may be customized. For example, you’ll be able to welcome each recipient by their first name,last name. you can include their postal address within the message body even though the other parts stays exactly the same.
Mail Merge is good for all. If you’re arranging a special event at your home, you’ll be able to send personalized email cards to any or all your friends by using this mail merge Program for Free of cost. An entrepreneur can use mail merge to share with customers regarding upcoming deals and offers. Teachers also can be able to send individual tasks and reports to students through this mail merge Program.
Mail Merge is Free Program and Premium Editions also available ,You can Support via Email or skype or Hangouts.
Steps-How to Setup Mail Merge With GMAIL:
- Go to this link for create a Copy of Mail Merge Sheet and Save it on your Google Drive.This is some Google apps Script internally
- Second thing ,below the New ” Mail Merge ” menu in the Sheet,Kindly click on ” reset button” to clear the canvas and also be authorize the sheet to accessing the Gmail and Contacts
- Once it’s done.Please Open the Google Contacts and to create a new Group like whom you have to send Personalized email or You can even Enter the Names and Email id of the receipents by manually in the Google Spreadsheet.
- Under the Menu,Choose Import Google Contacts and to Select the Google Contacts Group that you have created in Step 3rd .Now Google Docs will be automatically import all of the contacts ito the Sheet.
- Fill out the Various Fields of the Email Templates (if You don’t know how “Watch this Video here” )
- Now you can Compose the New Email Template in rich text by using HTML Mail Tools and Copy-n-Paste that you have generated HMTL Code into the Body of the Message
- You can also able to attachment on this like PDF ,Word Document into the Attachment ID Field
- Finally go to the Mail Merge menu again and to “Start the Mail Merge”.it will Change the Status is OK means Successfully Delivered
- That’s it.Please note Gmail has a Daily Sending limit is 100 message Per day.
Youtube Video How to Setup the Gmail Mail Merge :