Mail merge with Excel, field problems

[Guest]

I am using Word 2000 and Excel 2000. When I open the data source and point
to my Excel workbook, it appears to connect fine. When I go back to the Word
doc I only get things like AutoInsertMerge 1, etc. instead of the fields that
are in the first row of my Excel file. The Excel file does have many sheets
(tabs) and during the setup, I specify the sheet I want to use.
How do I get the field names out of Excel?
Thanks,
Fred

 

[Guest]

How very annoying! I've had a dabble and experienced the same problem as
you. 'Help' wasn't very helpful either ... it said that it could be done ...
but not HOW!!

A quick and easy solution, however, is to copy the cells and paste them into
Word and use that file as your data source.

I won't be beat though ... if I'm here all night I'll find out how to do it
from Excel!!

 

[Doug Robbins - Word MVP]

Are you sure that the field names conform to the mailmerge field naming
convention.

See the article "Creating a Mail Merge Data Source"
http://www.word.mvps.org/FAQs/MailMerge/CreateADataSource.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Guest]

Excellent, Doug! The info on the link solved the problem. Thanks.