Click the Update Labels button to update all fields.Once the address is being displayed properly, click OK to place the ">" field into the first label.If the address is not being displayed properly, click the Match Fields button and change how the fields are being matched.Click the Address Block option in the Ribbon and verify the address is properly formatted.If the CSV file inserts properly, ">" should appear on each of your labels. In the Select Data Source window, point Microsoft Word to the location of your CSV file and click OK.After the labels are created, click the Select Recipients button in Mailings and then click Use Existing List.
Search for xxxxx template, where xxxxx is the product number you are trying to find. Try to make sure that you don’t change the Recipient or Email Sent columns – otherwise you’ll have to go into the Script Editor and update them.If your label product number is not listed, you can often download the template for your labels from the manufacturer's website. Draft up the message you’d like to send in Gmail. Add the email addresses of your recipients into the column marked Recipient. You’ll need to head over here and make a copy of the Gmail/Google Sheets Mail Merge spreadsheet template.
Alternatively you can download the Right Inbox extension, that will allow you to do a mail merge within Gmail. This method using Google Sheets and Gmail is one of the most popular. Unfortunately mail merge isn’t a native feature to Gmail, so you’ll have to use this workaround.
Alongside all the other features we offer, this will help make your email workflows even more productive by enabling mail merges directly from the Right Inbox plugin.Īdditional Reading: How to Use Word & Excel for Mail Merge How to Create a Mail Merge Using Google Sheets (Step-by-Step Process) While you can create mail merges in Gmail using Google Sheets, as we’ll walk you through here, Right Inbox will soon be launching its very own mail merge feature. How Can Right Inbox Help with Mail Merges? You can even merge specific campaign details to journalists that work on different beats, which will help improve the success of your campaign. With mail merges, you can personalize each email to the journalist that you’re reaching out to. More effective PR campaigns – if you work in PR or outreach, then you likely send lots of emails every day. With a mail merge, you can make sure that each and every email is personalized to that particular recipient.Ģ. Customer updates – If you have a new product, feature, or service that you want to promote, you can use a mail merge instead of simply sending out a mass email with no personalization. Some of the most common uses of mail merges are:ġ. Mail merges can save you a ton of time, and there’s many situations in which you may find them useful. In more advanced mail merges, you can bring in other data fields to make the email even more personal.
Either through software or using a spreadsheet (like in the example below), you can use the main part of your message and easily customize it with different recipients’ names and email addresses.