No column Headers in Insert Merge Field Drop down

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BillTant - 22 Jan 2004 21:03 GMT

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

Reply to this Message

Cindy M -WordMVP- - 23 Jan 2004 18:49 GMT

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 :-)

Reply to this Message