Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert Merge Field problem with Word-Mail Merge from Excel documen
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. |
#2
|
|||
|
|||
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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Augusta E." Augusta wrote in message ... 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. |
#3
|
|||
|
|||
Hi ?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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros - Keyboard Commands | Microsoft Word Help | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Conditional inclusion of WordArt? | Mailmerge | |||
Word mail merge data loss | Mailmerge |