Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
 
Posts: n/a
Default Mail Merge doesn't execute until manually Opening the desired document

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?

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M -WordMVP-
 
Posts: n/a
Default Mail Merge doesn't execute until manually Opening the desired document

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

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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


All times are GMT +1. The time now is 01:41 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"