Related topics
×
Mail merge
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Mail merge

Print letters

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

So now that you have the basics of mail merge, let’s try some different options, including printing letters. You can find everything you need on the Mailings tab.

Want more?

Mail merge using an Excel spreadsheet

Insert mail merge fields

Create and print mailing labels for an address list in Excel

Use Word mail merge for email

So now that you have the basics of mail merge, let’s try some different options.

First of all you don’t have to use the wizard, if you don’t want to.

Everything that you need to do with mail merge is right here on the MAILINGS tab. Click Start Mail Merge and let’s convert the email messages to letters.

In the document body, all we have to do is delete the hyperlinks.

Also, click Select Recipients and let’s type a new recipient list that has mailing addresses.

Click in any field and start typing.

Press Tab to move to the next column, or Shift+Tab to move back.

When you finish adding information for one recipient, click New Entry to add the next one.

Typing a list can be a lot of work, but keep in mind that you are creating a database that can be used again in other documents and programs, like Microsoft Excel.

We’ll be using this again when we create envelopes in the next movie.

When you have added all the recipients, click OK, and choose where to save the list file, type a name, and click Save.

Now you can click Edit Recipient List anytime, to view and sort the list.

Click the file name in Data Source, and Edit to add or delete entries, and edit the data.

Simply click a field and type.

To delete an entire recipient, click in the column to the left of the entry, and press Delete, and Yes.

When you are finished, click OK and save your updated list.

Finally, let’s add an address block to the top of the letter.

Click ahead of the Greeting Line, press Enter a couple of times, and click the line at the top. Then, click Address Block.

You decide what to include in the address block on the left side, and preview the addresses over here.

First, let’s choose a less-formal name format to match the greeting.

Next, you can decide whether to Insert the company name.

For this letter, Company Name doesn’t apply. Also, our customers are local, so we can choose to Never show the country or region.

This last option modifies the address format according to the country or region.

Again, this option doesn’t apply.

When you are finished setting up the address block, click OK, and the address block field is added to the letter.

Now if you want to see what the actual letters look like instead of the mail merge field code, click Preview Results.

The address itself works fine, but the text would look better without the extra space between the lines.

Select the address block, and go to the PAGE LAYOUT tab.

You can change the formatting of a mail merge field the same as any other text.

The address block tool adds paragraph breaks to each line.

In this document, spacing is added after each paragraph. So let’s enter zero.

Everything looks okay, so go back to the MAILINGS tab and click Finish & Merge.

Even though we chose to create a letter, Word gives us the option to send it as an email, or we could click here and Word would create an individual document file for each recipient.

This could be useful if we wanted to personalize each letter.

But for this letter, let’s go right to the printer.

To print all the letters, click OK, and OK.

Up next, we’ll use mail merge to print the envelopes for the letters.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×