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?

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?

Peter: many thanks; exactly what I needed.

Alan

"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?

This KB is great for the current user but what if we need to make the change
for all users? Will it work if we add the Key into HKLM?

"Alan Wilson" wrote:

Peter: many thanks; exactly what I needed.

Alan

"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?

but what if we need to make the change
for all users?

I don't know - either you already have facilities for distributing global
changes to user registries (e.g. via a software management system, which I
can't help you with), or I think you will have to contact Microsoft Customer
Services for that one.

Will it work if we add the Key into HKLM?

It didn't work when I tried it here.

Peter Jamieson
"mrm_bc" wrote in message
...
This KB is great for the current user but what if we need to make the
change
for all users? Will it work if we add the Key into HKLM?

"Alan Wilson" wrote:

Peter: many thanks; exactly what I needed.

Alan

"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?

[lukecooley]

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?

[Peter Jamieson]

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?

[lukecooley]

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?

[Peter Jamieson]

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?

[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?

[Peter Jamieson]

I suggest you read the original question again.

Peter Jamieson

"Greg" wrote in message
...

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?