?
Solved

Disconnect Mail Merge in Word

Posted on 2000-03-20
3
Medium Priority
?
484 Views
Last Modified: 2012-05-04
Dear All,
I have a word template which is Mail-Merged with an Access File, everything works well. I usually use this template to create New Word Documents, and I usually convert all the fields to Text format by using the shortcut (CTL-SHIFT_F9). However, doing so is not enough to disconnect the Access file from my Word file, in other words the Access file is still launched whenever I open the Word file.  What is the best way to disconnect the 2 files?
0
Comment
Question by:khaledc
  • 2
3 Comments
 
LVL 15

Expert Comment

by:cquinn
ID: 2639915
Try:

Activedocument.MailMerge.MainDocumentType = wdNotAMergeDocument

0
 

Accepted Solution

by:
joanneL2 earned 200 total points
ID: 2643276
To unlink a database from a mail merge document, go into TOOLS, MAIL MERGE, CREATE, and click on RESTORE TO NORMAL DOCUMENT.  Answer yes when asked.  That's all there is to it.
0
 

Expert Comment

by:joanneL2
ID: 2645705
joanneL2 changed the proposed answer to a comment
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
I came across an unsolved Outlook issue and here is my solution.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question