How to remove Database link in Merged to New Document

[WordHazIt]

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?

 

[Doug Robbins - Word MVP]

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.

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

 

[JerryD]

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...

 

[Doug Robbins]

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


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