The data file is an Excel spreadsheet containing your recipients’ details.The mail merge template is a form letter in Microsoft Word.
You can use the mail merge feature in Word and Excel to create auto-personalized individual letters quickly.
#How to do a mail merge in word for address labels how to#
How to Use Mail Merge to Send Bulk Letters Next, I’ll go over the steps involved in using mail merge to automatically personalize individual letters. If the name of the merge fields and column headers match, the mail merge function would then merge your data file and your letter template to generate a personalized letter for each person. These are placeholders for your recipient’s details, also known as mail merge fields.Ī mail merge field draws the personalization information from your data file (spreadsheet) to help you create your personalized letter.īut to make this work, the name of the mail merge field in your personalized letter template must match the name of the column header in your spreadsheet. No tice the «FirstName», «Address» and other tags in the letter ? Here, your letter is the template file - it has placeholders for your contacts’ names and addresses. įor example, let’s say you want to perform a mail merge to create mass letters. Each cell in the data file contains different information (first name, last name, email address, etc.) that will be placed in your template file in the corresponding space.Įssentially, a mail merge automatically adds the personalization data from your data file to your template file.