Mail Merge doesn't execute until manually Opening the desired document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bcalley@gmail.com - 28 Feb 2006 17:33 GMT

We're using Access 2002 (10.6501.6471) SP3 and Word 2002 (10.6612.6714)
SP3

Our Access database is supposed to populate a word document via
mailmerge. The problem lies in that all of a sudden when we click the
button to open the document and populate it with the desired data, the
document is populated with the data from the last time we used it.

If you go an manually open the document, it then asks you if you want
to execute the specific SQL command and notifies you that the results
of the query will be placed in the document. If you click yes, it will
then correctly populate the word document.

This used to work w/o having to manually open the document...any ideas?

Reply to this Message

Cindy M -WordMVP- - 28 Feb 2006 18:19 GMT

See this Knowledge Base article. Basically, you have two choices: use VBA
to link in the data source or disable the security measure (create the
Registry entry).

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765
http://support.microsoft.com?kbid=825765

> We're using Access 2002 (10.6501.6471) SP3 and Word 2002 (10.6612.6714)
> SP3
[quoted text clipped - 10 lines]
>
> This used to work w/o having to manually open the document...any ideas?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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