Reply
 
Thread Tools Display Modes
  #1   Report Post  
Jay
 
Posts: n/a
Default Mail merge via dde connection

I had to reinstall Office XP recently. I have a word document linked to an
access database via a dde connection. Now when I open the document a window
opens with the following:

Opening this document will run the following SQL command€¦€¦€¦€¦€¦.Data from your
database will be placed in the document. Do you want to continue?

I want this to happen automatically without having to confirm this every
time. Do you know how?

JB

  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

See the following Knowledge Base article:

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765 at:

http://support.microsoft.com?kbid=825765

--
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
"Jay" wrote in message
...
I had to reinstall Office XP recently. I have a word document linked to an
access database via a dde connection. Now when I open the document a
window
opens with the following:

Opening this document will run the following SQL command......Data from
your
database will be placed in the document. Do you want to continue?

I want this to happen automatically without having to confirm this every
time. Do you know how?

JB



  #3   Report Post  
Jay
 
Posts: n/a
Default

Thank you, worked perfectly.

JB

"Jay" wrote:

I had to reinstall Office XP recently. I have a word document linked to an
access database via a dde connection. Now when I open the document a window
opens with the following:

Opening this document will run the following SQL command€¦€¦€¦€¦€¦.Data from your
database will be placed in the document. Do you want to continue?

I want this to happen automatically without having to confirm this every
time. Do you know how?

JB

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
Mail Merge - Parameter prompts twice... TL Mailmerge 6 June 17th 05 02:58 PM
Mail merge : DDE connection Anne Microsoft Word Help 1 April 29th 05 05:14 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 04:11 AM
no DDE connection to open data for mail merge LH1844 Mailmerge 1 December 14th 04 10:23 AM


All times are GMT +1. The time now is 06:12 PM.

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"