When I tried to run it manually, I got the following error:

"Opening this will run the following SQL command:
SELECT * FROM (datasource)
Data from your document will be placed in the document. Do you want to
continue?"

I read the KB article that Peter referenced which states this same
error so I made the changes to the registry, and ran it again. This
time it worked successfully!!!

Thank you all for your help!!!! :-)

-HP


Peter Jamieson wrote:
Try what Doug says...

But has the registry value

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\W ord\Options\SQLSecurityCheck

been set up (to be 0) for one user but not the other?

(This value is documented in the following KB article:

http://support.microsoft.com/default...b;en-us;825765

)

Peter Jamieson


wrote in message
oups.com...
I have a VB Script that executes to create a mail merge. The only
problem is that it works fine under one Windows profile, but when I log
in as a different user (same rights), it fails with the above error
message. What am I missing? A template? A registration?

The script executes correctly until this is performed (which is when I
get the error message listed above):

With oWord.ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.Execute
End With

Again, this works when executed under one profile, but not the new
profile.

-Heather
heatherpanek(at)gmail.com