Merge Fields not listed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dee - 14 Apr 2004 15:54 GMT

I have tried to do a mail merge using a form letter and
also envelopes as my main document. I pick my data source
which is an excel spreadsheet that has named column
headings. When I go to add the merge fields to my main
document, the drop down for Insert Merge Fields the fields
are all name AutoMerge Field 1, AutoMerge 2 etc. Could
anyone tell me why this would happen since I do have
column headings in my data source.

Thanks very much for your help.

Best regards,
Dee

Reply to this Message

Cindy M -WordMVP- - 15 Apr 2004 16:19 GMT

Hi Dee,

I've seen this happen when the data source is not on the
first sheet, or doesn't start in cell A1 PLUS the merge
hasn't been set up to a named range (just to a sheet).

If you can tell us which version of Word you're using, and
exactly how the worksheet is set up, we might be able to make
a couple of suggestions (besides changing things around as
described above)

> I have tried to do a mail merge using a form letter and
> also envelopes as my main document. I pick my data source
[quoted text clipped - 4 lines]
> anyone tell me why this would happen since I do have
> column headings in my data source.

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

Rate this thread: