Add fields to data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marion - 19 Sep 2004 16:55 GMT

I created a mail merge document in Word 2002 using an excel spreadsheet as
the data source. I subsequently added some columns to the spreadsheet (new
fields). The field list in Word mail merge does not show the new fields. I
tried saving the excel file with a different name and linking the Word
document to a new data source, but Word only gives me the option to link to
the old excel file. How do I get Word mail merge to recognize the new fields
(columns) in the excel data source?

Reply to this Message

Graham Mayor - 19 Sep 2004 17:29 GMT

You can attach any data file to a merge document from the merge toolbar -
see http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I created a mail merge document in Word 2002 using an excel
> spreadsheet as the data source. I subsequently added some columns to
[quoted text clipped - 4 lines]
> do I get Word mail merge to recognize the new fields (columns) in the
> excel data source?

Reply to this Message