[Candace]

When I attempt to perform a particular merge, I get a dialog "Microsoft
Office Word" dialog that says

"Opening this document will run the following SQL command ... Data from your
database will be placed in the document. Do you want to continue?"

And it gives the options "Yes" or "No"

Since I will be performing this merge several times a day every day, I do
not want to have to respond to this dialog box each time. Is there a setting
that can be adjusted so that these documents open without performing this
check? Or maybe a way to set "Yes" as an automatic default, so that it does
not prompt me to respond?

[Peter Jamieson]

You probably have to implement the registry change described in the
following article:

http://support.microsoft.com/kb/825765

Peter Jamieson
"Candace" wrote in message
...
When I attempt to perform a particular merge, I get a dialog "Microsoft
Office Word" dialog that says

"Opening this document will run the following SQL command ... Data from
your
database will be placed in the document. Do you want to continue?"

And it gives the options "Yes" or "No"

Since I will be performing this merge several times a day every day, I do
not want to have to respond to this dialog box each time. Is there a
setting
that can be adjusted so that these documents open without performing this
check? Or maybe a way to set "Yes" as an automatic default, so that it
does
not prompt me to respond?

[Janfry]

Look at "Application.DisplayAlerts", setting the value to wdAlertsNone.

Returns or sets the way certain alerts and messages are handled
while a macro is running.

WdAlertLevel can be one of these WdAlertLevel constants.
wdAlertsAll All message boxes and alerts are displayed; errors
are returned to the macro.
wdAlertsMessageBox Only message boxes are displayed; errors are
trapped and returned to the macro.
wdAlertsNone No alerts or message boxes are displayed. If a
macro encounters a message box, the default value is chosen and the macro
continues

Janfry

"Candace" wrote:

When I attempt to perform a particular merge, I get a dialog "Microsoft
Office Word" dialog that says

"Opening this document will run the following SQL command ... Data from your
database will be placed in the document. Do you want to continue?"

And it gives the options "Yes" or "No"

Since I will be performing this merge several times a day every day, I do
not want to have to respond to this dialog box each time. Is there a setting
that can be adjusted so that these documents open without performing this
check? Or maybe a way to set "Yes" as an automatic default, so that it does
not prompt me to respond?