Using OLE to change mailmerge datasource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LuckyLady - 15 Sep 2005 01:39 GMT

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 to this Message

Doug Robbins - 15 Sep 2005 04:57 GMT

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

Signature

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

> When I use OLE in VB or Visual dbase to load a MS word .doc file that is
> a
[quoted text clipped - 8 lines]
>
> Thanks for any ideas on this.

Reply to this Message

LuckyLady - 16 Sep 2005 00:05 GMT

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.

> See the following Knowledge Base article:
>
[quoted text clipped - 15 lines]
> >
> > Thanks for any ideas on this.

Reply to this Message

Rate this thread: