Mail Merge for Catalog document

From the tools menu I choose Mail Merge, and up comes the Mail Merge Helper. #1 I choose Main Document-Create-Catalog, then Active Window. From there I go to #2 and choose Get Data –Open Data Source and I choose my Excel data base. Message Word found no merge fields so I will the Main Document and chose Merge Fields, Adress1,
Tab five spaces, Them tab 10 spaces, Last name and tab five spaces, the Phone and no tabs as that ends the the fields.

Back to the Mail merge helper and #3 choose the query options and enter Address1, Them, LastName, and Phone. The comparison \boxes have Equal to selected. In the Sort Records \I choose Address1. Then OK!

Next I enter Merge and in the Merge Box I have new document, Records to be merged is Don’t Print blank lines… and then press merge.
The suggestion to set tabs to place Merge Fields did not produce the desired results. I have searched my sources and I cannot find one reference to what my problem is so it must be something I am doing. The upshot of all of this is that I can get columns of data to print in rows as it should. The data is all over the page.

This is what I am doing so if helps to trouble shoot this problem.
Now I have a error message that states Word could not merge the mail document with the data source because the data records were empty or no data records match your query.

Changed query Comparsion columns to “is not blank�. Product was all garbled, did not fall into column and rows as it should.



--
Terry

Okay, so you're inserting tab characters, but you haven't set the tab stops.
You have to create custom tab stops, not use the built-in ones. See
http://word.mvps.org/FAQs/Formatting/SettingTabs.htm.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Terry" wrote in message
...
From the tools menu I choose Mail Merge, and up comes the Mail Merge
Helper. #1 I choose Main Document-Create-Catalog, then Active Window. From
there I go to #2 and choose Get Data –Open Data Source and I choose my Excel
data base. Message Word found no merge fields so I will the Main Document
and chose Merge Fields, Adress1,
Tab five spaces, Them tab 10 spaces, Last name and tab five spaces, the
Phone and no tabs as that ends the the fields.

Back to the Mail merge helper and #3 choose the query options and enter
Address1, Them, LastName, and Phone. The comparison \boxes have Equal to
selected. In the Sort Records \I choose Address1. Then OK!

Next I enter Merge and in the Merge Box I have new document, Records to
be merged is Don’t Print blank lines… and then press merge.
The suggestion to set tabs to place Merge Fields did not produce the
desired results. I have searched my sources and I cannot find one reference
to what my problem is so it must be something I am doing. The upshot of all
of this is that I can get columns of data to print in rows as it should.
The data is all over the page.

This is what I am doing so if helps to trouble shoot this problem.
Now I have a error message that states Word could not merge the mail
document with the data source because the data records were empty or no data
records match your query.

Changed query Comparsion columns to “is not blank�. Product was all
garbled, did not fall into column and rows as it should.



--
Terry