![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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? |
Ads | |
#2
|
|||
|
|||
![]()
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 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? 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 :-) |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
collate pages in mail merge vs mail merge being single document | Dan Schwab | Mailmerge | 2 | September 14th 05 09:35 PM |
when opening my main mail merge document, it keeps asking me for . | abdel | Mailmerge | 1 | April 14th 05 11:19 PM |
Mail Merge not running properly from Access Function but runs properly when opened manually | Brian Alley | Mailmerge | 1 | February 22nd 05 01:58 AM |
how do I stop mail merge task pane from opening in a document | Cass | Microsoft Word Help | 12 | December 14th 04 11:23 AM |
How do I mail merge when only merge document is shown in tools? | DaveAS | Microsoft Word Help | 2 | December 1st 04 04:45 PM |