Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.access.formscoding,microsoft.public.word.mailmerge.fields
Paul Paul is offline
external usenet poster
 
Posts: 3
Default supressing warning when opening a Word Mail Merge document from Access

I'm using the following line of code in Access to open a word document
linked to my database with an ODBC connection that populates some Mail Merge
fields:

Application.FollowHyperlink "C:\PAM\PAM_Mail_Merge\mail_merge1.doc"

However, before the Word document will open, it displays the following
warning message:

"Opening this document will run the following SQL command:
Select * from 'tblMailMerge'
Data from the database will be placed in the document. Do you want
to continue?"

I would like to suppress this warning message, and I have tried using
"DoCmd.SetWarnings False" in the VBA code in Access, but it doesn't work
because the message is coming from Word rather than from Access.

Is there a way to suppress that warning message in Word when you open a mail
merge file?

Thanks in advance,

Paul


 
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
How to prevent sql command warning when opening merge document Daversey Mailmerge 2 April 22nd 12 04:54 AM
Word 2007 mail-merge SQL warning Simon Maystre Mailmerge 4 February 1st 07 04:02 PM
word opens access in mail merge. Access is already opened.=twice Sherri Mailmerge 1 February 11th 06 05:59 PM
How do I import access data into a word mail merge document that Rayomand Mailmerge 1 November 29th 05 09:46 PM
How do I mail merge a word document with an existing MA Access Qu Prince of Darkness Mailmerge 1 October 23rd 05 05:11 AM


All times are GMT +1. The time now is 08:27 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"