How to remove Database link in Merged to New Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WordHazIt - 05 Jan 2005 17:29 GMT

In Word 2003 I perform a MailMerge to a new document and save the new
document. An access database is the data source, which I perform a query to
filter one record for the MailMerge.

Here's the problem: when I reopen the new document it prompts if I want to
open the database. How can I avoid this?

Reply to this Message

Doug Robbins - Word MVP - 06 Jan 2005 03:49 GMT

Are you really executing the mailmerge to a new document, or just viewing
the result for that one record?

If you do execute the mailmerge to a new document, there will be no link to
the datasource and you will not get that prompt.

If you still maintain that you are executing the mailmerge to a new
document, press Alt+F9 and tell us what you see where the data from the
record appeared in the new document.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> In Word 2003 I perform a MailMerge to a new document and save the new
> document. An access database is the data source, which I perform a query
[quoted text clipped - 3 lines]
> Here's the problem: when I reopen the new document it prompts if I want to
> open the database. How can I avoid this?

Reply to this Message

JerryD - 07 Jan 2005 16:23 GMT

I am having a similar problem. There is a prompt that displays when I open a
merge document. I don't want this prompt to display but I don't know how to
stop it.
Message:
Opening this document will run the following SQL command...

> Are you really executing the mailmerge to a new document, or just viewing
> the result for that one record?
[quoted text clipped - 13 lines]
> > Here's the problem: when I reopen the new document it prompts if I want to
> > open the database. How can I avoid this?

Reply to this Message

Doug Robbins - 12 Jan 2005 03:44 GMT

See the following Knowledge Base article:

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765 at:

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

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am having a similar problem. There is a prompt that displays when I open
>a
[quoted text clipped - 24 lines]
>> > to
>> > open the database. How can I avoid this?

Reply to this Message