Reply
 
Thread Tools Display Modes
  #1   Report Post  
LuckyLady
 
Posts: n/a
Default Using OLE to change mailmerge datasource

When I use OLE in VB or Visual dbase to load a MS word .doc file that is a
mailmerge .doc file with an existing datasource, MS Word serivice pack 3 now
jumps in to ask if I wish to use the following SQL command for that
datasource. I know this is a new security feature in this version, but it
confuses people when they run this program.

Is there a switch I can use when using OLE to load these .doc files that
will prevent MS Word from jumping in and asking this question?

Thanks for any ideas on this.
  #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 test

--
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
"LuckyLady" wrote in message
...
When I use OLE in VB or Visual dbase to load a MS word .doc file that is
a
mailmerge .doc file with an existing datasource, MS Word serivice pack 3
now
jumps in to ask if I wish to use the following SQL command for that
datasource. I know this is a new security feature in this version, but it
confuses people when they run this program.

Is there a switch I can use when using OLE to load these .doc files that
will prevent MS Word from jumping in and asking this question?

Thanks for any ideas on this.



  #3   Report Post  
LuckyLady
 
Posts: n/a
Default

Thanks Doug,

Have seen that article but it indicates changing the registry, which is a
more permanent change than I was hoping for. Was hoping that there was a way
when you use the OLE function OpenDataSource to turn off that message
temporarily so users would not get confused when I am programmatically
setting up a mailmerge file with VB or Vdb. Kind of like the other
parameters for that function (e.g., LinkToSource, AddToRecentFiles, etc.)

Any chance you know of such a parameter so I can temporarily stop the
message rather than premanently changing the registry?

Thanks for any ideas.


"Doug Robbins" wrote:

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 test

--
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
"LuckyLady" wrote in message
...
When I use OLE in VB or Visual dbase to load a MS word .doc file that is
a
mailmerge .doc file with an existing datasource, MS Word serivice pack 3
now
jumps in to ask if I wish to use the following SQL command for that
datasource. I know this is a new security feature in this version, but it
confuses people when they run this program.

Is there a switch I can use when using OLE to load these .doc files that
will prevent MS Word from jumping in and asking this question?

Thanks for any ideas on this.




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
Mailmerge datasource LuckyLady Mailmerge 1 September 2nd 05 06:26 PM
automated mailmerge using Brio/Excel 2.1 datasource files Heidi Mailmerge 1 February 15th 05 12:41 PM
mailmerge - excel datasource - other file extension? Ralf Pickel Mailmerge 1 February 14th 05 08:05 PM
cant open mailmerge datasource saj via OfficeKB.com Mailmerge 0 January 5th 05 03:19 PM
word 97 mailmerge with paradox files as datasource saj via OfficeKB.com Mailmerge 0 December 24th 04 12:14 PM


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