Re: mailmerge out of Access 2003

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: automating the SQL warning and the choice of text format
    ... automatically select 'yes' and 'utf-8' rather than changing the registry, ... In order to get the correct encoding, I believe that you have to do the ... You need one of those for each data source. ... For a comma-delimited file using UTF-8 encoding, ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Synchronization error with "Prohibit Make Available Offline.
    ... The first method is to create custom Group Policy templates. ... > registry changes to the target computer. ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Fixing Mail Merge header files
    ... Much as I dislike these warnings and the registry fix necessary to get rid ... opens a header source or data source, it may be using software that is not ... with an attached Header file but no attached data ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word 2003 Run SQL? pop-up
    ... No, there's no way around this, other than changing the Registry. ... (in an AutoOpen macro, for example) ... > do you know of any of any data source formats that don't trigger the ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MailMerge Datasource not appearing in VBA when using DDE
    ... registry fix is designed to prevent - when Word opens a data source, ... When Word opens a data source, ... security settings affect this behaviour. ... someone who has the same setup on his PC, same version of XP and Word etc ...
    (microsoft.public.word.mailmerge.fields)
Loading