View Single Post
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
$hri...![_2_] $hri...![_2_] is offline
external usenet poster
 
Posts: 25
Default Conditional Mail Merge

1. In a new blank document, start the mail merge. To do this, use one of the
following procedures, as appropriate for the version of Word that you are
running:

Microsoft Word 2002

On the Tools menu, click Letters and Mailings, and then click Mail Merge
Wizard.

Microsoft Office Word 2003

On the Tools menu, click Letters and Mailings, and then click Mail Merge.

Microsoft Office Word 2007

On the Mailings tab, click Start Mail Merge, and then click Step by Step
Mail Merge Wizard.

2. In the Mail Merge task pane under Select document type, click to select
Directory.

3. Click Next: Starting document.

4. Under Select starting document, click to select Use the current document.

5. Click Next: Select recipients.

6. Under Use an existing list, click Browse.

7. In the Select Data Source dialog box, select the sample file you created
in the Set Up the Data File section.

8. If the Confirm Data Source dialog box appears, select a data type that is
appropriate for the type of file that you created in the Set up the data file
section. For example, if you created the file in Microsoft Excel, select
either MS Excel Worksheets via DDE (*.xls) or Excel Files via ODBC (*.xls).

9. In the Mail Merge Recipients dialog box, click OK.

10. Using the following example as a guide, insert fields to compare the key
field in each row with the key field in the previous row, and to insert one
string of text if they are different and another string of text if they are
the same.

http://support.microsoft.com/kb/294686/en-us?FR=1