Message every time Word 2003 Merge Doc is Opened

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stuart - 07 Jan 2004 19:50 GMT

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

Reply to this Message

Stuart - 07 Jan 2004 20:38 GMT

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

>-----Original Message-----
>Every time I open a mail merge document in Word 2003
[quoted text clipped - 10 lines]
>Stuart
>.

Reply to this Message

Jeff Bean - 07 Jan 2004 20:52 GMT

>Every time I open a mail merge document in Word 2003
>(either manually or through VBA), I get a message that
[quoted text clipped - 4 lines]
>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

Reply to this Message

Stuart - 08 Jan 2004 13:52 GMT

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.

>-----Original Message-----
>
[quoted text clipped - 20 lines]
>CWC Software
>.

Reply to this Message