Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2004

Tip: Looking for answers? Try searching our database.

Clear mail merge datasource

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike - 26 Jan 2004 18:56 GMT
How do I clear a mail merge datasource without removing the mail merge functionality or the mail merge fields?  I only see the option to 'CHANGE' the datasource, but not 'REMOVE' it.  Help in doing this manually or programmatically would help.

I will be opening the letter and assigning the mail merge datasource programmatically from an Access database, but I do not want the letter inherently tied to any specific database.  It takes longer to open the letter right now because it's opening the datasource it's tied to, and then opening the datasource I set programmatically.

Your help is greatly appreciated.
Peter Jamieson - 27 Jan 2004 00:53 GMT
In VBA, set

ActiveDocument.MailMerge.MainDocumentType = wdNotAMergeDocument

This disconnects Word from the data source. It leaves all the fields in the
document, but discards any filters and sort sequences.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> How do I clear a mail merge datasource without removing the mail merge functionality or the mail merge fields?  I only see the option to 'CHANGE'
the datasource, but not 'REMOVE' it.  Help in doing this manually or
programmatically would help.

> I will be opening the letter and assigning the mail merge datasource programmatically from an Access database, but I do not want the letter
inherently tied to any specific database.  It takes longer to open the
letter right now because it's opening the datasource it's tied to, and then
opening the datasource I set programmatically.

> Your help is greatly appreciated.
Preet - 06 Sep 2004 08:51 GMT
Peter

Your VBA code was VERY useful. I have been trying to get rid of th
link to the data source in Mail Merge, for a while now and your cod
SOLVED IT!

Thank you, thank you....

Preet:

--
Message posted from http://www.ExcelForum.com
Preet - 07 Sep 2004 15:25 GMT
Thank you that worked Peter

--
Message posted from http://www.ExcelForum.com

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.