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 / December 2003

Tip: Looking for answers? Try searching our database.

Open existing mail merge document without data source

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Angie - 09 Dec 2003 18:48 GMT
I have an often used document that is saved and linked to
an existing excel spreadsheet. My teammates adjust the
data in the spreadsheet in order to get new letters.

The problem I am having is that when the spreadsheet
contains a large amount of data it takes forever to open.
Is there a way to open the Word Document without the
linked spreadsheet? I want it to give me the choice of
removing the link, in case I need to temporarily use this
letter with other spreadsheets..thanks!
Peter Jamieson - 10 Dec 2003 00:20 GMT
I don't think you can do much to speed things up. So you may be better off
disconnecting the data source before saving the document, then reconnecting
the source when you need it. You shouldn't lose any of the merge fields in
your document, but you will lose any sort/filter options.

Alternatively, if you always know before you open the document whether or
not you want to use the usual spreadsheet, it might be simpler to keep two
versions of the dcocument, one for use with the "regular" sheet and the
other for when you want to choose another data source.

--
Peter Jamieson - Word MVP

> I have an often used document that is saved and linked to
> an existing excel spreadsheet. My teammates adjust the
[quoted text clipped - 6 lines]
> removing the link, in case I need to temporarily use this
> letter with other spreadsheets..thanks!
 
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.