![]() |
DepartmentsHomeBlogBooksHelp!DictionaryVideoArchivesFun |
You've Got Mail Merge 2002/XP! Mail Merge is a basic word processor function: you create a generic document and then use a list of various information tidbits to create multiple documents that look like each was typed personally. That all makes sense and if you haven't yet mail merged you will some day. Alas, Word has perhaps the screwiest, most step-laden, nonsensical method for accomplishing mail merge that I've ever seen. Not only that, Microsoft changes the way Word does mail merge with each new release. So even if you think you've mastered mail merge from a previous version of word watch out! It's totally and utterly changed. Fortunately, this chapter explains mail merge and how to do it in a friendly, no-nonsense way. So I'll get to the point as soon as possible. This document covers basic mail merging only. All About Mail Merge Mail merge is the process of taking a single letter, stirring in a list of names and other information, and combining (merging) everything into a final set of documents, each of which is customized and almost personal. In Word you can also "mail merge" e-mail messages, envelopes, labels and lists of information all of which is a little eccentric, but still capitalizes upon the mail merge formula. In Word 2002, mail merge involves the following things: The Main Document. The file that contains the form letter the fill-in-the-blanks letter is called the main document. Yeah, I call it the "form letter." In Word this document can be created before or during the mail merge process. The Address List. This is a special file on disk that contains names and other merge information. Word uses the information in the address list to fill in the blanks in the main document. Fields. These are the fill-in-the-blank items inside the main document. Each field is filled in by an item in the address list. It's these fields that provide the link between the main document and address list, making each document appear to be customized. Fields are what makes the mail merge possible. To make this all happen you use the Mail Merge wizard, which lives in the Task Pane. That's your headquarters for all mail merging mania, which the following sections go into detail describing.
Doing a Sample Mail Merge The following sections walk through creating a simple mail merge document step-by-step. (Actually, 34 steps.) They take you from nothing to creating both the main document and address list, and then merging them together. (The Step numbers listed in the headings match the step numbers given in the Task Pane when the Mail Merge wizard is running.) Getting started (Step 1 of 6) Sending out a form letter, cover letter, faxes or any batch of similar-yet-customized documents is the domain of mail merge. My advice is to start with a blank document and mail merge as you go. 1. Start a new document.
2. Choose Tools This displays the Mail Merge Task Pane, as shown here:
The Task Pane lets you select the type of merge document you want to create, offers a description of each item, and lets you know this is only the first of six painful steps. Ho-boy. 3. Choose Letters from the list. The basic mail merge document is known as "Letters" to the Task Pane. This includes form letters and faxes, since the difference between them is how they are printed (faxes are "printed" on the fax modem). 4. Click Next: Starting document. Don't let the simplicity of this first step lead you down the merry path; this is the easiest step there is. Preparing the main document (Step 2 of 6) Time to build the fill-in-the-blanks, main document. The Task Pane offers you three choices: Use the current document. That's the blank document sitting there on the screen. Start from a template. This allows you to use a template on disk for creating the new document. For more information on templates, see Chapter 17 of Word 2002 for Dummies. Start from existing document. You can open any Word document on disk and use it as the mail merge document. Basically Word is just covering all the bases here. It lets you use any document as the main document, whether the document has already been created or not. Actually, that's kind of nice. 5. Choose Use the current document. You're going to use the blank document on the screen. The other choices let you start a new document by using a template or open a previously created document on disk. (If you choose either of those options, the Task Pane shows some additional buttons and clicky things so that you can select a template or open a file on disk.) 6. Create the main document. Write it as you would any Word document, using formatting, pictures all that fancy stuff. At this point, I put place holders in the main document for the items that change, as shown above. I make them ALL CAPS so they're easy to find, but otherwise I type and format the form letter just like anything else in Word. 7. When you're done, save the main document to disk. 8. Click Next: Select recipients from the Task Pane. Time to move on to step 3.
Creating the fields (Step 3 of 6) The Mail Merge wizard refers to this step as "select recipients," but that assumes you already have an Address List handy. If not, then you have to build an Address List and additionally add any fields to that list that you need for your document. (The Address List that Word maintains has only common fields in it, not anything customizable, such as birth date, favorite color, hat size, or body piercings, which you'll have to add yourself.) Your options are to use an existing list, which you might have created using Word during a previous mail merge, or you can steal information from the Outlook e-mail/contact program providing you use Outlook and have information in there you want. If so, select one of those options. That Task Pane changes to display additional clicky things to help you locate the Address List you want to use. For example a Browse option appears that lets you search the computer for an existing Address List should you choose that option. For this example, I'll assume you're creating a new list from scratch. To type a new list, follow these steps: 9. Write down the names of the fields you need in your document. Peruse the main document and look for the ALL CAPS entries, which are your fill-in-the-blanks field names. Write them down so that you have them handy. 10. Choose Type a new list. This is the bottom of the three options shown in the Mail Merge Task Pane. 11. Choose Create. The New Address List dialog box appears, full of mirth and merriment: This place is where you create the fields the fill-in-the-blank items for the Address List. To be helpful, Word has already dreamt up a whole parade of field names. Normally I'd recommend that you delete them all, but that really takes too much time. Instead, you merely need to add those that you need and then ignore the rest. (And you can always come back and fill in the rest of the fields later, like when you take the laptop with you on vacation and you need something to fill the time between margaritas on the beach.) 12. Click the Customize button.
The Customize Address List dialog box appears:
All Word's preset fields are listed in the box. If you're lucky and all the fields you need are there, then great! Skip up to Step 16. Otherwise, you need to add the custom fields your document needs. 13. Click the Add button.
A tiny Add Field dialog box appears. 14. Type in a field name and click the OK button. Use the list you created in Step 9. For example, to add the TATTOO field, type Tattoo into the box and click the OK button.
15. Repeat Steps 13 and 14 until you've entered all your custom field names. 16. Click OK to close the Customize Address List dialog box. Your fields now appear in the New Address List dialog box, ready for you to fill everything in nice and tidy.
Adding the data
(Still on Step 3)
The next step is to fill in all the blanks. This is done in the New Address List dialog box, and is actually a continuation of step 3 in the mail merge process. 17. Fill in the blanks. For this example, you need to fill in only the items used in your document. For example, if your document uses only the First Name, Last Name and Hair Style fields, then you need only fill in that information; the rest of the fields you can leave blank. There's nothing wrong with filling in all the fields at this time, only that it takes time to do that. Besides, if your document doesn't require an e-mail field, there's no need filling that one in at this time. 18. When you've filled in all the blanks, click the New Entry button. You don't have to click the New Entry button after typing the last record. Instead, go right on to Step 20. 19. Repeat Steps 17 and 18 for every person to whom you want to mail your form letter. You're building a database. Say it properly: DAY-tuh-bays. Each collection of fields in the New Address List dialog box is a record. That's yet another nerdy, database-like term you'll have to put up with when you mail merge in Word. 20. After you're done, click the Close button. If you haven't yet saved this list to disk, a Save Address List dialog box appears to let you do so. Give the list a name and save it to disk. 21. Gloat over your work. Finally, the Mail Merge Recipients list appears: 22. Click OK. Word is now locked into the list you've created (or selected) and ready to use that information for the mail merge. Meanwhile, back in the Mail Merge Task Pane . . . 23. Click Next: Write your letter. Moving right along . . . Inserting fields into the main document (Step 4 of 6) The final step before actual merging is to place the fields the blanks into your main document. This is where I depart from the Mail Merge Task Pane and take another approach I feel works better for inserting fields into the main document. 24. Choose View This displays the handy Mail Merge toolbar, which contains all the buttons for commands you need to complete the merge. You can kiss the mooching Task Pane good-bye: 25. Close the Task Pane. 26. In the form letter, position the toothpick cursor where you want to place the field. For example, you want a name field after the Dear in your letter's greeting, so position the cursor between the Dear and the colon. If you used ALL CAPS words to mark your fill-in-the-blanks stuff (as I did above), select those place holders with your mouse; drag the mouse over the ALL CAPS text to highlight it. 27. Click the Insert Merge Fields button on the Mail Merge toolbar.
The Insert Merge Field dialog box appears:
This dialog box lists the fields you created when you built the database (the section "Creating the fields" earlier in this dispatch). 28. Select the field you want to place in the document. 29. Click the Insert button.
A special cryptic code is inserted into your document, representing that field. For example, the FIRSTNAME field may look like { MERGEFIELD "First_Name" } in the main document. This special code is what Word thinks of as a "blank" for fill-in-the-blanks stuff. 30. Click Close. The Insert Merge Field dialog box goes away, which is dumb because you're not done yet. (And using the Mail Merge Task Pane for this activity is no better; there are two extra steps you must perform to merge in each field.) 31. Continue adding fields until the document is complete. Repeat Steps 26 through 30 as necessary to stick all the fields in your document.
Merge mania! (Last step) After creating the main and data files, you're ready to merge away! This is actually the simplest part of all this mail merging nonsense: 32. Save the main document. Clicking the Save button on the toolbar does this best. 33. Click the Merge to New Document button on the Mail Merge toolbar.
A dialog appears where you can select which records to print. Whatever . . . 34. Click OK. As if by magic, Word creates several new documents merging your main document with the information that you put into your Address List. All the new documents appear, one after the other, on the screen in front of you in Word. Congratulations; you've just merged. Word merges the names and other information from the data file into the main document and creates lots of little, customized documents in one great big document file. That's what you see on-screen right now. Your options at this point are to review all the documents, save them, print them, fax them. You made it! The main file appears several times on-screen, with information from the data file plugged into each copy. All files are separated by section breaks or hard page breaks.
Other Mail Merging Things The main document can be of several types. To see (or switch) the main document type, click the Main document setup button on the Mail Merge toolbar:
This displays the Main Document Type dialog box:
To change (or switch if you're starting with a new document) the type of mail merge, choose the proper item from the dialog box. You might also notice the last item in the dialog box: Normal Word document. That's what changes a mail merge document back to a non-mail merge document. To connect the main document to an Address List (again, without using the Mail Merge Task Pane wizard thing), click the Open data source button on the toolbar:
Then choose the Address List you want to use by using the Select Data Source dialog box. Now Don't Plague Yourself With Guilt! If you've come here just to learn Mail Merge, wonderful! But keep in mind that there are many more glorious jewels to be found in my book, Word 2002 for Dummies. Even if you don't consider yourself a "dummy," I believe you'll find plenty of valuable information and advice in this handy book.
|
![]() | If you find this page useful |