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 / April 2005

Tip: Looking for answers? Try searching our database.

Data Source Info in Saved Documents Changes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kim - 01 Apr 2005 18:29 GMT
My company uses Windows 2000 and we just upgraded to Office 2003 Professional
from Office 2000.  The problem is this:

When users create and save a mail merge, then create another mail merge
using the same Excel data source file (revised), the info in the mail merge
fields for the previously saved mail merge changes to whatever the revised
data source info is.  Therefore, it is useless to save the previous document.

This didn't seem to be an issue in Office 2000.  Any advice would be greatly
appreciated.
Peter Jamieson - 01 Apr 2005 20:15 GMT
Not sure really, but it sounds as if you are using preview to go to the
record you want, then saving a copy of the document, rather than actually
performing the merge. In the former case, you are saving all the
"mergefields" you had in your mail merge main document, along with some
information from the currently selected record. In the latter case, the
resulting document should not have any connection with the data source.

In the former case, it may be that Word 2000 does not try so hard to refresh
the preview data as Word 2003.

Probably the only really safe way to save the document in a way that avoids
this problem is to "unlink" the merge fields before saving, e.g. by
selecting everything and using crtl-shift-F9. Unfortunately that doesn't
usually unlink /everything/ and it does not detach the data source, but you
will find some macro code to help in messages posted recently by Charles
Kenyon.

Peter Jamieson
> My company uses Windows 2000 and we just upgraded to Office 2003
> Professional
[quoted text clipped - 10 lines]
> greatly
> appreciated.
Kim - 01 Apr 2005 20:31 GMT
Thanks Peter.  I will try what you suggested.

> Not sure really, but it sounds as if you are using preview to go to the
> record you want, then saving a copy of the document, rather than actually
[quoted text clipped - 28 lines]
> > greatly
> > appreciated.
 
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.