[deloisr]

When I try to merge my excel document (250 rows and 5 columns) into Word
1. The choices in the "insert merge fields" do not match the fields in the
spreadsheet.
2. The finished merge, which should run 22 pages and list 250 events in
order from January through December instead lists only six events in no
discernible order compared to the spreadsheet.
I set up phony word documents and tried to merge them with different data
bases and always get the same set of insert fields bearing no relationship to
the spreadsheet, and the merge always produces five or six entries instead of
the reflecting number of rows in the spreadsheet. I looked the spreadsheets
over, no blank cells, no obvious reason for the discrepancy. Please. Help.

[Peter Jamieson]

Which versions of Word and Excel are you using?

Can you step through exactly how you are connecting to the data source?

1. The choices in the "insert merge fields" do not match the fields
in the
spreadsheet.

Are the field names things like "First Name", "Last name", "City" etc.?
If so, try to find the Insert Field dialog box and make sure that
"Database Fields" is checked, not "Address fields"

Peter Jamieson

http://tips.pjmsn.me.uk

On 09/11/2009 21:05, deloisr wrote:
When I try to merge my excel document (250 rows and 5 columns) into Word
1. The choices in the "insert merge fields" do not match the fields in the
spreadsheet.
2. The finished merge, which should run 22 pages and list 250 events in
order from January through December instead lists only six events in no
discernible order compared to the spreadsheet.
I set up phony word documents and tried to merge them with different data
bases and always get the same set of insert fields bearing no relationship to
the spreadsheet, and the merge always produces five or six entries instead of
the reflecting number of rows in the spreadsheet. I looked the spreadsheets
over, no blank cells, no obvious reason for the discrepancy. Please. Help.