116942 MS Word: Mail Merge

Unit standard 11694 ....................................................... Page 117-127

MS Word Mail Merge
Mail Merge in Microsoft Word is a feature that allows you to create personalized documents, such as letters, emails, labels, and envelopes, using a template and a data source like an Excel spreadsheet or an Outlook contact list.

To start a mail merge, you first need to choose the type of document you want to create, such as a letter or an email message. Then, select a starting document, which can be the current document or a template. Next, you need to select a recipient list as your data source. If you don't have a list, you can create one during the mail merge process.

Once you have your data source, you can insert merge fields into your document where you want the personalized information to appear. These fields are placeholders that will be replaced with information from your data source. For example, you can insert a merge field for the recipient's name or address.

After inserting the merge fields, you can preview the merged documents to ensure they look correct before completing the merge process. Finally, you can print or send the merged documents, depending on the type of document you are creating.

Mail Merge in Word: Combines a template document with a data source to create personalized documents.

Data Source: Can be an Excel spreadsheet, Outlook contact list, or a Word data file created on the fly.
Merge Fields: Placeholders in the document for unique information from the recipients list.
Preview: Allows you to see how the merged document will look before finalizing the merge.
Completion: Prints or sends the merged documents based on the type of document chosen.

Introduction

Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, or spreadsheet. When performing a Mail Merge, you will need a Word document (you can start with an existing one or create a new one) and a recipient list, which is typically an Excel workbook.

To use Mail Merge:

Open an existing Word document, or create a new one.
From the Mailings tab, click the Start Mail Merge command and select Step-by-Step Mail Merge Wizard from the drop-down menu.

The Mail Merge pane will appear and guide you through the six main steps to complete a merge. The following example demonstrates how to create a form letter and merge the letter with a recipient list.

Step 1:

From the Mail Merge task pane on the right side of the Word window, choose the type of document you want to create. In our example, we'll select Letters.
Then click Next: Starting document to move to Step 2.

Step 2:

Select Use the current document, then click Next: Select recipients to move to Step 3.

Step 3:

Now you'll need an address list so Word can automatically place each address into the document. The list can be in an existing file, such as an Excel workbook, or you can type a new address list from within the Mail Merge Wizard.

Select Use an existing list, then click Browse to select the file.

Locate your file, then click Open.
If the address list is in an Excel workbook, select the worksheet that contains the list, then click OK.

In the Mail Merge Recipients dialog box, you can check or uncheck each box to control which recipients are included in the merge. By default, all recipients should be selected. When you're done, click OK.

Click Next: Write your letter to move to Step 4.

If you don't have an existing address list, you can click the Type a new list button and click Create, then type your address list manually.

Step 4:

Now you're ready to write your letter. When it's printed, each copy of the letter will basically be the same; only the recipient data (such as the name and address) will be different. You'll need to add placeholders for the recipient data so Mail Merge knows exactly where to add the data.

To insert recipient data:
Place the insertion point in the document where you want the information to appear.
Choose one of the placeholder options. In our example, we'll select Address block.
Depending on your selection, a dialog box may appear with various customization options. Select the desired options, then click OK.

A placeholder will appear in your document (for example, «AddressBlock»).
Add any other placeholders you want. In our example, we'll add a Greeting line placeholder just above the body of the letter.

When you're done, click Next: Preview your letters to move to Step 5.

For some letters, you'll only need to add an Address block and Greeting line. But you can also add more placeholders (such as recipients' names or addresses) in the body of the letter to personalize it even further.

Step 5:

Preview the letters to make sure the information from the recipient list appears correctly in the letter. You can use the left and right scroll arrows to view each version of the document.

If everything looks correct, click Next: Complete the merge to move to Step 6.

Step 6:
Click Print to print the letters.
A dialog box will appear. Decide if you want to print All of the letters, the current document (record), or only a select group, then click OK. In our example, we'll print all of the letters.

The Print dialog box will appear. Adjust the print settings if needed, then click OK. The letters will be printed.

click the picture below to watch the more about mail mage

Click to Go Back

To use Mail Merge:

Step 1:

Step 2:

Step 3:

Step 4:

To insert recipient data:

Step 5:

Step 6: