Using OLE to change mailmerge datasource

L

LuckyLady

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.
 
D

Doug Robbins

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
 
L

LuckyLady

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top