Merge Fields Automatically Updating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JS - 22 Aug 2007 16:28 GMT

I have a Word merge letter in Word 2002. The data source is an excel
spreadsheet.

If the spreadsheet changes monthly, can the merge fields be updated
automatically when I open the merge letter to run it monthly with the new
information? I was thinking on selecting the linking but it's greyed out.

Thanks for any help!

Reply to this Message

Doug Robbins - Word MVP - 22 Aug 2007 20:37 GMT

If the name and location of the data source is unchanged, and it was
attached to the mail merge main document when it was last saved, when you
open the main document and execute the merge, the current information from
the data source should be what is incorporated into the result of the merge.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a Word merge letter in Word 2002. The data source is an excel
> spreadsheet.
[quoted text clipped - 4 lines]
>
> Thanks for any help!

Reply to this Message

JS - 23 Aug 2007 17:10 GMT

Thank you Doug. That makes sense to me.

> If the name and location of the data source is unchanged, and it was
> attached to the mail merge main document when it was last saved, when you
[quoted text clipped - 9 lines]
> >
> > Thanks for any help!

Reply to this Message