Solved

Disconnect Mail Merge in Word

Posted on 2000-03-20
3
475 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 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
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…
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…

773 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