Insert Merge Field problem with Word-Mail Merge from Excel documen

[Guest]

Using Word 2000 - attempting to create mail labels from one particular Excel
document. At the point where I must "Insert Merge Field" into the Sample
Label, Word will not read/recognize my column labels (Name, Address,
CityState, Zip) from the Excel doc., and instead only offers me a choice of
"AutoField", "AutoField1", etc. I have created labels in Word from _other_
Excel documents, but it continues to give me problems with this ONE Excel
document. Do I have some kind of embedded codes that are causing the
problem? I have put a cell border around the column labels in Excel, and
bolded them to differentiate them from the data cells.

Thanks for all your help.

 

[Suzanne S. Barnhill]

The formatting may be part of the problem, but it's more likely that you've
got a blank row between your heading row and the record rows.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?QXVndXN0YSBFLg==?=,

Does the table of data begin in cell A1? If not, try putting it there and see if
that makes a difference.

Using Word 2000 - attempting to create mail labels from one particular Excel
document. At the point where I must "Insert Merge Field" into the Sample
Label, Word will not read/recognize my column labels (Name, Address,
CityState, Zip) from the Excel doc., and instead only offers me a choice of
"AutoField", "AutoField1", etc. I have created labels in Word from _other_
Excel documents, but it continues to give me problems with this ONE Excel
document. Do I have some kind of embedded codes that are causing the
problem? I have put a cell border around the column labels in Excel, and
bolded them to differentiate them from the data cells.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

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