Merge Fields not listed

[Dee]

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

 

[Cindy M -WordMVP-]

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
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.

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