No column Headers in Insert Merge Field Drop down

[BillTant]

After Step 2 (Open Data Source) I edit the main doc and
when I drop down the "Insert Merge Field" menu, it only
lists Automergefield, Automergefield1,Automergefield2,
etc. There are the same number of these as columns in the
Excel doc that is the Data Source. I've tested a merge
with the Automergefields and nothing shows.

TIA for any assistance.
Bill

 

[Cindy M -WordMVP-]

Hi BillTant,

After Step 2 (Open Data Source) I edit the main doc and
when I drop down the "Insert Merge Field" menu, it only
lists Automergefield, Automergefield1,Automergefield2,
etc. There are the same number of these as columns in the
Excel doc that is the Data Source. I've tested a merge
with the Automergefields and nothing shows.

Yeah, I've seen this. Can't remember exactly what the
circumstances were, but I think we can track it down.

1. Which version of Word are we dealing with?

2. Is the data on the first sheet of the Excel workbook? If
not, move the sheet to the front and see if things are any
better.

3. If you're on the first sheet, is the data in cell A1? If
not, is it a named range?

4. Did you specifically select a method to connect to the
Excel data? If yes, which was it? (If no, I'll be able to
figure it out when I know the version of Word.)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
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