Gmail mass email tips: Avoid the spammy look with the personalized touch - craverbeight

Gmail contact groups are great for sending a single e-mail message to a peculiar solidifying of people, but what if you want to give each email a personal mite, such as with a newssheet or subject matter offer? Different Microsoft Office, Google's productivity suite doesn't have a native ring mail-merge feature you can leverage to exercise this. Simply don't stew it: With a little help from Google Sheets and a unfreeze downloadable handwriting, you can personalize bulk email messages in Gmail in minutes.

Reasonable remember, Google allows you to send simply 100 emails per day using scripts. Present's how to get started.

1. Create a spreadsheet

Lumber into your Google Drive calculate. On left sidebar, click New > Google Sheets to create a spreadsheet. You'll be importation your email recipients' striking selective information here, so gift information technology a descriptive epithet.

Next, go to the carte Browning automatic rifle and select Add-ons > Bring fort add-ons. This takes you to Google's add-on memory boar. In the search window, type a name for your mail merge book—for this example, we'll useYet Another Ring armou Conflate—and hit Get in.

This is a semipublic mail merge script. Click the Free button, and a windowpane will open, asking for different permissions to access Google Sheets, Contacts, and Gmail. Click Accept. A window will pop up subordinate Add-ons on the menu exclude, indicating that the script has been installed. Clack the X to close it.

The Yet Another Mail Unite script adds a menu to Google Sheets under Add u-ons.

2. Import your contacts

The adjacent measure is to import your email recipients into the spreadsheet. Click Add-ons > Yet Another Mail Mix up > Import contacts from a group. A half-size window will open up with a driblet-shoot down menu of all the contact groups in your Gmail story. You can also function into Gmail, and make a new group with all the contacts you lack to let in in your mail merge. Past repeat the steps above and choice this group from the drop-down menu. Click Import contacts, and those contacts will populate your spreadsheet.

Your contacts import into Google Sheets, fill out with column headers.

3. Draft your email subject matter

Now assimilative a new browser tab and lumber into your Gmail account. Click Compose to afford a new message. Eccentric a style in the subject field and compose the body of your message. Then type $%headername% anywhere you want to infix column information from your spreadsheet. For example, type Dear $%Given name% if you want each email to apply the receiver's forename in the salutation. Once you're finished, click X to close the subject matter, and it will automatically save up to your Drafts folder.

4. Perform the mail merge

Go back to your spreadsheet and click Add-ons > Yet Another Mail Commingle > Start mail merge. In the window that opens, prize the title of your email message from the Drafts knock off-down card. Check the Cross Emails Opened box if you want to see which of your recipients opens the e-mail.

The text EMAIL_SENT will appear next to each contact in the Merge Status pillar of your spreadsheet later on a successful mail service merge.

To make a point everything is formatting correctly, click Send off me a trial run email to receive a sample message. Toggle switch to Gmail and check the message. If everything looks good, return to that panel and click Send Emails. You'll now ensure EMAIL_SENT next to each contact in the Mix up Status column of your spreadsheet. If you want to perform some other mail merge from that same spreadsheet, remember to delete that textbook from the Merge Position column of each recipient you privation to email again.

Source: https://www.pcworld.com/article/431796/how-to-personalize-mass-emails-in-gmail.html

Posted by: craverbeight.blogspot.com

Share this post