[js]

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!

[Doug Robbins - Word MVP]

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.

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

"JS" wrote in message
news
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!

[js]

Thank you Doug. That makes sense to me.

"Doug Robbins - Word MVP" wrote:

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.

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

"JS" wrote in message
news
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!