Mail merge to Excel

[Rina]

I have created a word document that merges to an excel
spreadsheet. The Spreadsheet is very simple - first row
contains straightforward headings and the rest of the
sheet is also plain - no formulas anywhere, just names,
numbers and percentages typed in.

Setting up the word doc goes beautifully - all the merge
fields say exactly what I want them to say.

But when I merge, it merges to the wrong column in the
excel sheet.
Example:
In spreadsheet: Column 1 is labelled "Names" ; Column
2: "Company"; Column 3 "Telephone".
In Word Doc: "Names" merge field comes out
blank, "Company" merge field prints the data in
the "Names" column and "Telephone" merge field
prints "Company" data.

IS THERE ANYONE OUT THERE WHO CAN TELL ME WHY THIS
HAPPENS???

Assistance will be much appreciated!

 

[Cindy Meister -WordMVP-]

Hi Rina,

Version of Word?
Do you happen to know which connection method Word is using
to link up to the data? (if you don't, I will when you tell
me the version of Word involved)

If you set up a new document and connect to the Excel
sheet, do you see the same behavior?

How about the same document, with a new Excel workbook
(that you set up explicitly for testing purposes)?

I have created a word document that merges to an excel
spreadsheet. The Spreadsheet is very simple - first row
contains straightforward headings and the rest of the
sheet is also plain - no formulas anywhere, just names,
numbers and percentages typed in.

Setting up the word doc goes beautifully - all the merge
fields say exactly what I want them to say.

But when I merge, it merges to the wrong column in the
excel sheet.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail