How to Use Mail Merge in Word to Create Letters, Labels, and Envelopes

By 3 weeks ago

Mail merge is a function in Microsoft Word that allows you to create customised letters, labels, envelopes, emails, and a directory quickly and easily. Some users may not know how to execute a mail merge in Word to create letters, labels, and envelopes because mail merge is not one of the most widely utilised MS Word functions.

Mail merge can help you save time by automating the process of personalising each letter, label, or other document. Even if you’ve never created a mail merge letter before, the procedure is rather simple, and we’ll walk you through each step below.

How to Create Mail Merge Letters

A wizard in Microsoft Word guides you through the process of making mail merge letters. Along the way, the wizard will ask for the letter you want to use as well as the recipients of the letter, so be sure you have a list of recipients ready to go. If you don’t, it’s not a big deal; you can always manually create a list of recipients.

Create a Word document in which to write your message. Leave out the personal touches (for instance, title, name, city, etc.). For the time being, you might simply leave a blank spot where you want to insert these pieces, as shown below:

  1. When your template is ready, select Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard from the top ribbon.
  1. A new pane will appear along the right border of your MS Word window. This is the wizard that will walk you through the process. As a first step, you’ll need to select the type of document you’re working on. Select Letters and choose Next: Starting document.

In the next step, you’ll need to select the document you wish to use for mail merging.
Select Use the existing document if you’ve already typed some content for your letter.
Select Start from a template if you wish to utilise a ready-to-use template. Select recipients after you’ve picked a starting document.

  1. The next step is to select recipients. Assuming you have an Excel sheet populated with the recipient data, you can import the data by selecting the Use an existing file option and selecting Browse from the subsequent section.

Navigate to the sheet containing the list of recipients using the explorer, select the sheet and select Open

When you select the sheet, you’ll see the Select Table window. Select the relevant table(s). Be sure to check the box beside the text First row of data contains column headers if that’s true for your data, and select OK.

Next, you’ll see the list of recipients that Word will use in your merge. If everything looks good, select OK

When you’ve added the Excel sheet, select Next: Write your letter.

  1. You’re now ready to add placeholders in your letter. Bring your cursor to where you want to add the placeholder and select More items from the mail merge pane.

The Insert Merge Field dialog box will open from where you can select the relevant placeholder and select Insert to add it to your letter.

  1. When you’ve inserted all merge fields, select Next: Preview your letters.

This will show you a preview of all letters generated with mail merge. You can use arrow buttons in the mail merge pane to switch the preview of letters.

  1. Select Next: Complete the merge. In the subsequent step, select either Print (if you want to print all letters) or Edit individual letters > All (if you’re going to merge the letters into a single document).

How to Create Mail Merge Labels

It’s a good idea to keep your mailing list organised on an Excel sheet so you don’t become dizzy when you need someone’s address. If you want to print the labels, however, your Excel sheet compilation will not suffice. Instead, you’ll need to use MS Word to construct mail merge labels.

  1. If you already have an Excel sheet with mailing details, you can skip over to the next step. If not, organize your mailing list on an Excel sheet. Add some headers (First Name, Last Name, Address, etc.) and get your list sorted.
  2. Switch over to MS Word. Use the wizard for creating labels. Open a blank document and select Mailings > Select Mail Merge > Step-by-Step Mail Merge Wizard.
  1. Select Labels and then Next: Starting document.
  1. On the next screen, select Change document layout. Next, select Label options to set your product number and label brand.

Once you select OK, you’ll see the labels outlined on your document. If you don’t, go to Table Design Borders and select View Gridlines.

  1. Go back to the Mailings tab in MS Word and select Select Recipients > Use an Existing List.

Navigate to the Excel file containing the mail list. Select the file and select Open.

  1. You’ll see the Select Table window. If you have multiple sheets in your workbook, you’ll see more than one item here. Select the one that contains your mailing list. Check the box besides the text First row of data contains column headers, and select OK.
  1. MS Word imports the mailing list. Select Address Block. Look at the preview on the right.

If it doesn’t look like how you want it, select Match Fields. Make sure that all details correspond to an appropriate header from your worksheet and select OK.

Look at the preview again. If it looks good, select OK.

  1. You’ll now see <<AddressBlock>> in the label. Go to Mailings > Update Labels to add <<AddressBlock>> to all labels.
  1. The labels are now ready to be merged. Go to Mailings > Finish & Merge > Edit Individual Documents.

You’ll see a small window pop up. Select All and then OK.

  1. You’ll now see all your labels merged.

How to Create Mail Merge Envelopes

Creating mail merge envelopes is mostly the same as that for labels, but with a few tweaks. 

Again, click on Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard, but this time, select Envelopes and then select Next: Starting document from the bottom.

  1. You’ll be asked to select a starting document. Select Envelope options to select envelope size and position of the delivery/return address (refer to next step), and select Next: Select recipients.
  1. When you select Envelope options, you’ll see a small window pop up. Select your preferred envelope size and select the font and the placement for delivery and return address.
  1. The next step in the wizard is to select recipients. Select Use an existing list (assuming you already have an Excel sheet containing the recipient data), and select Browse to look for the file. Select the relevant file and click on Next: Arrange your envelope.
  1. On your next screen, select Address block, look at the preview to ensure it looks like you want it to, and select OK.

You’ll now see <<AddressBlock>> appear on the envelope. 

  1. Select Next: Preview your envelopes. You’ll see the same preview you saw in the previous step but on your document. You can use the arrow buttons in the wizard pane to switch between envelopes.

Your envelopes are now ready to be merged. Select Next: Complete the merge.

  1. On the following screen, you’ll see an option to Edit individual envelopes. Select it, select All to merge all records, and select OK.

You’ll now see all envelopes merged into a single document.

Bulk Printing and Emails Made Easy

You can save a lot of time by using mail merge instead of designing your letters, labels, or envelopes. However, MS Word is capable of much more. You may also make index cards, greeting cards, and books.

Mail merge has been around for a while, but if you’re wanting to streamline your procedures, Microsoft Office 2019 has a few new options to consider.


Recent Posts