[Greg]

Depending on the Version of word you can add the following key to the
registry
HKEY_CURRENT_USER
Software\Microsoft\Office\12.0\Word\Options
SQLSecurityCheck = 0

That will disable the prompt

12.0 = Word 2003
11.0 = Word 2002
10.0 = Word 2000

--
Gregory M. La Due
Twin Tiers Technologies, Inc.
Senior Programmer

(800) 480-6467





"Peter Jamieson" wrote in message
...
How does one go about detaching the document from it's data source? I
can
change the data source, but can't seem to find any info on just detaching
it
totally after the data is in the doc.

One way...

1. Open the document
2. Enable the mail merge toolbar (e.g. using Tools|Customize)
3. Click the leftmost button and select the "Normal Word Document" button.

You lose the data source, and any sort or filter options specified, but
all the Mailmerge fields and so on remain.

The situation in my problem/opportunity doesn't require connecting to a
data
source once the orginal user has entered the necessary data, save the
doc,
and put it out for another user to view.

Broadly speaking your best bet is to get them to merge to a new document
(perhaps selecting the /one/ record they need to merge) then save the new
document and distribute that. The new document should not be attached to a
mail merge source unless it has been created from a document that is
attached to a template that is itself attached to a data source (if that's
lost you, have a look at the mail merge main document, the Word template
it is attached to, and maybe we can step through what is happening and
where you might go from here).

Peter Jamieson
"lukecooley" wrote in message
...
Window message handling... Somewhat of a thought, but I think I'll pass.

Well by default I think I've inherited my authorship of this merge main
document. Not my cup of tea, but I'll learn quickly I hope. But that
raises
my next question (which I can't seem to find an answer to anywhere)...
How does one go about detaching the document from it's data source? I
can
change the data source, but can't seem to find any info on just detaching
it
totally after the data is in the doc.
The situation in my problem/opportunity doesn't require connecting to a
data
source once the orginal user has entered the necessary data, save the
doc,
and put it out for another user to view.
--
Luke Cooley


"Peter Jamieson" wrote:

Then unfortunately, I guess you're stuffed, unless you know how to
construct
the kind of Windows message handling routine that can detect that
specific
dialog box being displayed and answer "no" for you, (I don't, but I
occasionally wish I did).

If you are the author of the merge main document then you always have
the
option of detaching the document from its data source before you
distribute
it and writing VBA to prompt the user to connect to a suitable data
source.
Not quite logically equivalent but it's the best I can suggest right
now.

Peter Jamieson
"lukecooley" wrote in message
...
That works if you want to click 'Yes' to the message. What if you
want it
to
automatically always say 'No'?
--
Luke Cooley


"Peter Jamieson" wrote:

See

http://support.microsoft.com/default...b;en-us;825765

Peter Jamieson

"Alan Wilson" Alan wrote in
message
...
There is now a prompt when a mail merge document is loaded, to
allow
the
SQL
insert: I want to bypass the prompt. Security is set to low, but
that
doesn't
help. How can that prompt be removed?