[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Disconnect Mail Merge in Word

Posted on 2000-03-20
3
Medium Priority
?
482 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 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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. …

650 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