Chapter 27
In This Chapter
Understanding mail merge
Building the main document
Conjuring up a recipient list
Making a recipient list
Inserting fields into the main document
Previewing the results
Merging (the final act)
Here’s a little quiz: What do these things have in common? Rocket science. Quantum mechanics. Brain surgery. Levitation. The answer: They’re all a lot easier to accomplish than attempting mail merge in Word.
I’m not saying that mastering mail merge is impossible. True, it’s an ancient word-processing tradition — something that just about everyone toys with at one time or another. Yet the way Word handles mail merge has been consistently frustrating. That’s why I wrote this chapter.
The term mail merge is given to the process of opening a single document, stirring in a list of names and other information, and then combining (merging) everything. The result is a sheaf of personalized documents. Sounds useful, right? Peruse this section before attempting the process on your own.
Although you may have your own delightful, descriptive terms for the steps required and pieces necessary to complete a mail merge, Word's terms are different. Before taking the mail merge plunge, I recommend that you review the terms Word uses:
Main document: This document is just like any other document in Word, complete with formatting, layout, and all the fancy stuff that goes into a document. The document also contains various fill-in-the-blank items, which is what makes it the main document.
Recipient list: This list contains the information that creates the customized documents. It’s a type of database, with rows and columns of information used to fill in the form letters.
Field: Each of these fill-in-the-blanks items inside the main document is a placeholder that will be filled in by information from the recipient list. Fields are what make the mail merge possible.
Getting these three elements to work together is the essence of mail merge. All the commands necessary are located on the Mailings tab. In fact, the command groups are organized left-to-right in the order you use them. The remainder of this chapter describes the details.
The typical mail merge involves five steps. These steps are presented in more detail throughout this chapter:
Build the main document.
Choose the document type, usually a letter, although other document types are listed in the nearby sidebar, “Mail merge document types.” As you create the document, you decide which fields are needed. That way, you can build a recipient list.
Create the recipient list — the data for the mail merge.
The recipient list is a table, consisting of rows and columns. Each column is a field, a fill-in-the-blanks part of the document. Each row is like a record in a database, representing a person who receives his own, custom copy of the document.
Insert fields into the main document.
The fields are placeholders for information that is eventually supplied from the recipient list.
Preview the merge results.
You don’t just merge; first you must preview how the documents will look. That way, you can clean up any formatting, check for errors, and do other corrections.
The rest of this chapter covers the specifics.
If all this mail merge malarkey is just too intense for you, consider an alternative: Word offers the Mail Merge Wizard, which guides you through the entire ordeal one step at a time.
To run the wizard, click the Mailings tab, and choose Start Mail Merge ⇒ Step-by-Step Mail Merge Wizard. You see the Mail Merge pane on the right side of the document’s window. Answer the questions, choose options, and click the Next link to proceed.
The rest of this chapter assumes that you’re crazy enough to do mail merge the macho way.
Mail merge begins with a document, or what I call the main document. It’s the prototype for all the individualized documents you eventually create, so it contains only common elements.
The following sections discuss different types of main documents. Read the section that relates to the type of mail merge you’re attempting, and then proceed with the section, “II. The Recipient List.”
The most common thing to mail merge is the standard, annoying form letter. Here’s how you start that journey:
Start a new, blank document.
Press Ctrl+N.
Type the letter.
You’re typing only the common parts of the letter, the text that doesn’t change for each copy you print.
Type the fields you need in ALL CAPS.
This step is my idea, not Word’s. For text that changes for each letter, type in ALL CAPS. For example, FIRST NAME or HAT SIZE. Use short, descriptive terms. Figure 27-1 shows an example.
Save the main document.
If you already saved the document as you were writing it, give yourself a cookie.
After you create your letter, the next step is to create or use a recipient list. Continue with the section “II. The Recipient List,” a little later in this chapter.
Word lets you spew out custom email messages by using the E-Mail option for mail merge. This option works only when you configure the Microsoft Outlook program on your computer. After that’s done, you start the main document for your email merge by obeying these steps:
On the Mailings tab, choose Start Mail Merge ⇒ E-Mail Messages.
Word changes to Web Layout view, used for creating Internet documents in Word.
If you anticipate inserting fields in the message, type them in ALL CAPS.
Normally, an email mail merge doesn’t have fields in the document. Instead, email addresses are used to send out multiple copies of the message. Even so, you can insert fields just as you would for a form letter. See Step 5 in the preceding section for details.
The primary field you use when merging an email document is the recipient’s email address. You can’t email-merge without it. Continue your mail merge adventure in the later section, “II. The Recipient List.”
To create a stack of mail merge envelopes, which is far classier than using peel-and-stick mailing labels, abide by these steps:
On the Mailings tab, choose Start Mail Merge ⇒ Envelopes.
The Envelope Options dialog box appears. You can set the envelope size and font options, if necessary.
Click OK.
Word’s window changes to reflect a typical envelope, a size specified in the Envelope Options dialog box (Step 2).
Type the return address.
Normally, an envelope mail merge doesn’t use different return addresses for each envelope. So type the return address where the insertion pointer is blinking in the upper-left corner of the envelope.
Press Shift+Enter to place a soft return at the end of a line in the return address. The soft return keeps the lines in the return address tightly together.
That’s pretty much it for a mail merge envelope. Word has placed a text box at the center, lower portion of the envelope. That’s where fields for the recipient’s name are inserted. You could type text in that box, but it’s not really necessary.
Your next task is to use the recipient list to gather the information for your mailing. Keep reading in the next section.
To make mail merge work, you need a list of items to merge, rows and columns as in a database. This information, called the recipient list, contains the items used to create the individual documents, email messages, envelopes, and so on.
Your options including building a new, custom recipient list, as covered in the next section. Once created, you can use a recipient list again. You can also pull in information from the Outlook program.
Unless you already have recipient lists built and saved, you need to make one from scratch. This process involves setting up the list by adding fields you want and discarding fields you don’t need. Once that chore is over, you fill in the data.
Because creating the recipient list can be involved, I’ve divided the task into four subsections.
Before you can create a new recipient list, you must have created and saved the main document. Specific steps are provided in the earlier section, “I. The Main Document.” Creating the recipient list works the same no matter which mail merge document type you created.
In the Start Mail Merge group, choose Select Recipients ⇒ Type a New List.
You see the New Address List dialog box.
The New Address List dialog box comes pre-stocked with fields. If you can use some, great! Otherwise, you must add fields not already present.
Follow these steps in the New Address List dialog box:
Click the Add button.
The teeny Add Field dialog box pops into view.
Type the field name and click the OK button.
Follow these rules for naming fields:
Repeat Steps 1 and 2 for each new field you need in the main document.
The list of fields should match with the list of ALL CAPS text in the main document (if you chose to create them). Don’t worry if it doesn’t — you can add fields later, though it takes more time.
Click OK.
You now see customized fields as column headings in the New Address List dialog box.
Removing unnecessary fields is optional, but I include it out of spite: The New Address List dialog box comes with a basic assortment of fields. If you don’t need them, remove them. Or you can skip ahead to the next subsection, “Add recipient data.”
To remove extra fields from the New Address list dialog box, heed these steps:
Click the Customize Columns button.
The Customize Address List dialog box appears, displaying fields that Word assumes you need. Such foolishness cannot be tolerated.
Click to select a field that you do not need.
When you’re merging an email message, you need the Email_Address field, whether it appears in the message body or not Word uses this field so that it knows where to send the message. Don’t delete the field!
Click Yes in the confirmation dialog box.
The keyboard shortcut for the Yes button is the Y key.
Repeat Steps 2 through 4 for each field you don’t need.
Be careful not to remove any fields you added!
When you’re done, the New Address List dialog box should contain only those fields you need.
After customizing the fields, your final job is to fill in the recipient list. You need to input records, one for each document you plan to create:
Type the first record’s data.
Type the information that’s appropriate to each field shown in the New Address List dialog box: name, title, evil nickname, planet of origin, and so on.
Press Tab to enter the next field.
After filling in the last field, you’ll probably want to add another record:
To add a new record, press the Tab key after typing in the last field.
When you press the Tab key in the last field in a record, a new record is automatically created and added on the next line. Keep filling in data!
Review your work when you're done.
Figure 27-2 shows a completed recipient list.
You can edit any field in any record by selecting it
If you accidentally add a blank record at the end of the list, click to select it and then click the Delete Entry button. You do this because blank records are still processed in a mail merge, which can result in wasted paper.
Click OK.
The Save Address List dialog box pops up, allowing you to save the recipient list.
The recipient lists dwell in the folder named My Data Sources, found in the Documents or My Documents folder. Word automatically chooses (or creates) this folder.
Type a name for the address list.
Descriptive names are best. After all, you might use the same recipient list again.
Click the Save button.
You return to the document.
The next step in your mail merge agony is to stir the fields from the recipient list into the main document. Refer to the section “III. Fold in the Fields,” later in this chapter.
To use an existing recipient list for your mail merge, follow these steps after creating the main document:
From the Mailings tab, choose Select Recipients ⇒ Use an Existing List.
The Select Data Source dialog box appears. It works like the Open dialog box, though it’s designed to display recipient lists that Word can use or that you previously created and saved.
Look for recipient lists in the My Documents folder, My Data Sources subfolder.
Choose an existing recipient list from the displayed files.
I hope you used a descriptive name when you first saved the recipient list, which I recommend in the preceding section.
That’s it: The recipient list is now associated with the main document.
Refer to the later section, “III. Fold in the Fields,” for information on inserting fields into your document, which is the next step in the mail merge nightmare.
Assuming that you use Microsoft Outlook, and further that you have access to Exchange Server, you can follow these steps to create a recipient list:
In the Select Contacts dialog box, choose a contact folder.
Contact folders are created in Outlook, not in Word.
Use the Mail Merge Recipients dialog box to filter the recipient list.
If the list isn’t too long, remove the check marks by the names of the individuals you don’t want in the list. You can also click the Filter link in the dialog box to do more advanced filtering, which I’m loathe to describe right now.
The next step in the painful experience known as Word mail merge is to insert fields into the master document. Keep reading in the later section, “III. Fold in the Fields.”
Although you can’t add or remove fields from a recipient list, you can add or remove records. To do so, follow these steps:
On the Mailing tab, in the Start Mail Merge group, click the Edit Recipient List button.
The button isn’t available unless you’re working on a main document and it has been associated with a recipient list.
Select the data source.
In the lower-left corner of the Mail Merge Recipients dialog box, click the data source filename.
Click the Edit button.
You can now use the Data Form dialog box to edit each record in the recipient list or to add or remove fields and perform other chaos:
To make a mail merge work, the main document must be peppered with fields. The fields are placeholders, into which data from the recipient list is pulled and placed. Before this process takes place, ensure that you’ve created the main document and assigned a recipient list, as described earlier in this chapter.
If you’ve followed my advice in the section, “I. The Main Document,” you can easily add fields by replacing the ALL CAPS text with the proper fields. Here’s how it works:
Position the mouse pointer where you want the field to appear in the main document.
If you followed my advice from the earlier section, “Creating a mail merge form letter,” select a placeholder, such as FIRST NAME.
Choose the field to add to the main document.
For example, choose the First Name field to stick it into the document.
After the field is inserted, you see its name hugged by angle brackets, such as <<First Name>>.
Repeat Steps 1 through 3 to add fields to the document.
When adding fields to an address, press Shift+Enter to end each line.
Save the main document.
Always save! Save! Save! Save!
The next step in your journey is to preview the results and fix any mistakes. Keep reading and continue with the next section.
Rather than just plow ahead with the merge, take advantage of the buttons in the Mailing tab’s Preview Results group. That way, you can peruse the merged documents without wasting a lot of paper.
To preview, click the Mailings tab, and in the Preview Results group, click the Preview Results command button. The fields in the main document vanish! They’re replaced by information from the first record in the recipient list. What you see on the screen is how the first customized mail-merge document appears. I hope everything looks spiffy.
Use the left and right triangles in the Preview Results group to page through each document. As you page, look for these problems:
To fix any boo-boos, leave Preview mode: Click the Preview Results button again. Edit the main document to correct any mistakes. Then repeat the preview process.
Once everything looks up to part, you’re ready to perform the merge, covered in the next section.
The final step in the mail merge nightmare is to create personalized documents. The gizmo that handles this task is the Finish & Merge command button, the sole item in the Finish group on the Mailings tab. This section describes how to use that button to complete the mail merge.
When you want to save merged documents and print them, follow these steps:
Choose Finish & Merge ⇒ Edit Individual Documents.
The Merge to New Document dialog box appears.
Click OK.
Word creates a new document — a huge one that contains all merged documents, one after the other. Each document copy is separated by a Next Page section break. (See Chapter 14 for more information on section breaks.)
At this point, you can print the document, close it and edit it later, or do anything else you like.
The most common destination for merged documents is the printer. Here’s how it works:
Choose Finish & Merge ⇒ Print Documents.
A dialog box appears, from which you can choose records to print.
Choose All from the Merge to Printer dialog box to print the entire document.
Or specify which records to print.
Click OK.
The traditional Print dialog box appears.
See Chapter 9 for more information on printing documents in Word.
To send out multiple email messages, abide by these steps:
Choose Finish & Merge ⇒ Send Email Messages.
The Merge to E-mail dialog box appears.
Choose the e-mail address field from the To drop-down list.
Your document’s recipient list must include an email address field, whether the field is used in the document or not. If not, go back and edit the recipient list to include the address.
Click OK.
It looks like nothing has happened, but the messages have been placed in the Outlook outbox.
After you open Outlook, the queued messages are sent, or they sit ready to be sent when you give the command. (Whether the messages are sent right away depends on how you configured Outlook.)
Yes, this trick works only with Outlook, not with any other email programs.
18.217.145.223