By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,765 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

how to "disconnect" database connection in Word mail merge?

P: n/a
Lee
I have a Word template that is set to merge with our client database. After
I run the merge, I merge to a new document, and then save the new document.
When I reopen this saved document, it prompts Access to open and request
information from the underlying query. Since I've already merged and saved
the new document with the merged info, I don't want Word to prompt Access
anymore. How to I "sever" the connection between Word and Access?

Thanks,

Lee
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
By design Word will refresh the data source....be that a list, table, excel
file or Access database.

If you really don't want to do that.....
then select "Merge to a new file"....save that new file...which will contain
all the data, but no merge field codes.
And don't keep the merge document that made it.

Mal.

"Lee" <lr*************@cox.net> wrote in message
news:cE3dc.92$0h6.72@lakeread02...
I have a Word template that is set to merge with our client database. After I run the merge, I merge to a new document, and then save the new document. When I reopen this saved document, it prompts Access to open and request
information from the underlying query. Since I've already merged and saved
the new document with the merged info, I don't want Word to prompt Access
anymore. How to I "sever" the connection between Word and Access?

Thanks,

Lee

Nov 12 '05 #2

P: n/a
"Lee" <lr*************@cox.net> wrote in message news:<cE3dc.92$0h6.72@lakeread02>...
I have a Word template that is set to merge with our client database. After
I run the merge, I merge to a new document, and then save the new document.
When I reopen this saved document, it prompts Access to open and request
information from the underlying query. Since I've already merged and saved
the new document with the merged info, I don't want Word to prompt Access
anymore. How to I "sever" the connection between Word and Access?

Thanks,

Lee


You could use the code from Albert Kallal's website. He exports the
selected record(s) to a CSV file and runs the merge from there - so
there's no source document for Word to "remember".

http://www.attcanada.net/~kallal.msn.../msaccess.html

HTH,
Pieter
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.