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 / July 2004

Tip: Looking for answers? Try searching our database.

Mail merged data links

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sandra - 29 Jul 2004 17:10 GMT
Issue:
I have a Word document that I would like to merge to new
data. It was previously mail merged with an Excel file.
Now that I need to use the original "unmerged" document
with other data it automatically links and opens the
original data file from Excel.

Question:
How can I break the link to the Excel file and reuse it
with other data?

Any ideas?
Thanks in advance for your suggestions.

Regards,
S
Peter Jamieson - 29 Jul 2004 20:23 GMT
You can just go through the process to set up a new data source. In most
cases the old one should be removed automatically.

However, to return the mail merge main document to being a "normal"
document, in Word 2000, click the Mail Merge Helper button on the Mail merge
toolbar, click the Create button and select "Restore to Normal Word
Document". In Word 2002/2003, it's probably easiest to enable the Mail Merge
toolbar (Word Tools|Customize, click the first button, and select the merge
type to be "Normal" (I think! - the correct setting should be obvious when
you are looking at the menu).

The document will retain any fields you have inserted (so any new data
source needs to have those field names to make any new merge work, or you
can remove any fields you don't need. You will lose the link to the data
source and any filter or sort specifications.

Signature

Peter Jamieson

> Issue:
> I have a Word document that I would like to merge to new
[quoted text clipped - 12 lines]
> Regards,
> S

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.