Re: mailmerge out of Access 2003

My problem is that up until now, I have been able to write the key needed to
turn the message off that makes you authorise the SQL source of a mailmerge
document. This key is:

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options]
"SQLSecurityCheck"=dword:00000000

My automation code runs out of a Microsoft Access mde file and without that
key written in the HKEY_CURRENT_USER registry for any user, the mailmerge
won't run as you can't see the authorisation message box.

My client is a large government department and they are not going to take
off their no changes to the registry policy for me. Is there a way around
writting the key where I can still get my mailmerge to work properly.

dixie

"Cindy M." <C.Meister-C@xxxxxxxxxx> wrote in message
news:VA.000000ec.01567261@xxxxxxxxx
Hi Dixie,

I have an application that does a lot of mailmerges from Access 2003
direct
to Word 2003. I have used the SQLFix registry patch up to now to address
the problem of the mailmerge not happening because it is waiting for an
authorisation to run the SQL. My main client has now gone to a standard
operating environment in which registry changes are not allowed.

My program transfers a text file with the data for merging in it and that
is
set up as the data source in each word template.

Does anyone know any other way of getting around this problem?

What, more exactly, is the problem? I understand the limitations of the
environment you're describing, but it's unclear exactly what problem
you're
trying to work around.

FWIW, the client's IT department should be able to change the Registry
(using a
Policy). If they don't want to, then they have to live with the prompt. Or
they
have to allow you to use automation code to link in the data source
"behind the
scenes" each time a mail merge is going to run. Or they have to be willing
to
pay for you to develop a new solution.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply
in the newsgroup and not by e-mail :-)



.

Relevant Pages

  • Re: mailmerge out of Access 2003
    ... I have been playing around with calling the mailmerge templates by using ... If I change the security of Access to 'low' via Tools ... off their no changes to the registry policy for me. ... prompt only exists because executing SQL can have side effects (e.g. ...
    (microsoft.public.word.mailmerge.fields)
  • Help! Problem Deploying COM DLL
    ... I've written a VB com class which allows me to perform various mailmerge ... ' registered in the COM registry and cannot be created ... MergeDocName As String, ByVal ConnectionString As String, ByVal SQLString As ...
    (microsoft.public.dotnet.framework.interop)