Reply
 
Thread Tools Display Modes
  #1   Report Post  
Augusta E.
 
Posts: n/a
Default 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   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

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   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros - Keyboard Commands Janet Microsoft Word Help 6 April 11th 05 05:28 AM
In Word, how can I see all files (*.*) in "save as"? citizen53 New Users 8 April 4th 05 04:56 PM
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 05:10 AM
Conditional inclusion of WordArt? Bill Watkins Mailmerge 13 February 1st 05 03:51 PM
Word mail merge data loss Gibson Mailmerge 1 December 8th 04 01:30 PM


All times are GMT +1. The time now is 07:58 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"