Solved

Disconnect Mail Merge in Word

Posted on 2000-03-20
3
478 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 15

Expert Comment

by:cquinn
ID: 2639915
Try:

Activedocument.MailMerge.MainDocumentType = wdNotAMergeDocument

0
 

Accepted Solution

by:
joanneL2 earned 50 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

Office 365 Training for IT Pros

Learn how to provision Office 365 tenants, synchronize your on-premise Active Directory, and implement Single Sign-On.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

738 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