I want to list numbers & address on page using mail merge doc. keep ending up with all same entry. Help?

Question

I am using MS Word 2000 mail merge. In order to format the information on a page to look like a phone book or directory, not a list of lables, I keep getting a repeat of the same record.

Answer 1

I'm going to assume you are merging a Word document with a Word table as your secondary file.

1st, your table file must have column headings as the first row.
> select that row
> cl Table
> cl Heading

Open a Word document
cl Tools
cl Mailmerge

in the Mailmerge Helper -
cl create
cl catalog

cl Get Data
find and name the table data file

you will be told your document needs to be edited

now you have to enter the fields, cl Insert Field (one at a time)
You will use your headings here.
name "return"
address "return"
phone "return"
"return" for a blank line between

then, merge

Answer 2

The formats must be produced in Word to your reqiuirements. Only the raw data is send to Word from Excel, not the formatting information.