Message every time Word 2003 Merge Doc is Opened

S

Stuart

Every time I open a mail merge document in Word 2003
(either manually or through VBA), I get a message that
says "Opening this document will run the following SQL
command..." and I have to choose yes to continue.

How do I shut that off? I tried turning DisplayAlerts off
in my VBA code, but then the document opens without its
data source.

Thanks.

Stuart
 
J

Jeff Bean

Every time I open a mail merge document in Word 2003
(either manually or through VBA), I get a message that
says "Opening this document will run the following SQL
command..." and I have to choose yes to continue.

How do I shut that off? I tried turning DisplayAlerts off
in my VBA code, but then the document opens without its
data source.

Annoying, isn't it? This warning was apparently added in the final
release of Office 2003. It wasn't in the beta version of Office 2003
that I obtained to test our application with. If you are using VBA to
run the merge then the warning gets suppressed and Word acts as if the
user had responded "No". So to run a merge using VBA you either have to
turn DisplayAlerts off or make the following registry tweak to turn off
the warning.

http://support.microsoft.com/?kbid=825765

Jeff Bean
CWC Software
 
S

Stuart

It is very annoying. I could have sworn that I still had
problems when I shut display alerts off. I did the
registry setting and am OK now.
 

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