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 / March 2006

Tip: Looking for answers? Try searching our database.

Word Template files losing data file attachments

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AnneM - 22 Mar 2006 01:42 GMT
use Word 2003 and export my data files from Access 2003.  I save merge files
as templates (eg letters, labels, envelopes etc) and each time I select them
- file/new the data file has been removed from the doc.  

If I save the merge file as a .doc file and just open it, this doesn't
happen, but it defeats the purpose of the whole template idea.  

Any suggestions how to stop this happening.  My export files are text file
and are comma and para mark delimited.
Doug Robbins - Word MVP - 22 Mar 2006 06:04 GMT
I have not found the need to save mailmerge main document files as
templates.  If you want to do that, you will need to have an autonew macro
in the template that opens (attaches) the data source to the new document
that is being created from the template.

ActiveDocument.MailMerge.OpenDataSource Name:="[drive:\path\filename]"

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> use Word 2003 and export my data files from Access 2003.  I save merge
> files
[quoted text clipped - 7 lines]
> Any suggestions how to stop this happening.  My export files are text file
> and are comma and para mark delimited.
Charles Kenyon - 22 Mar 2006 18:51 GMT
My experience has been that the data file remains attached. Recently I moved
my data files and it was a real pain. I ended up detatching the data file
from the template but writing a macro that would attach it when a new
document was created. (My macro is more flexible than Windows and easily
finds the data file even if I move things around because the data file is
kept in a subfolder of my workgroup templates folder. The macro finds the
workgroup templates folder setting and goes from there.) Doesn't answer your
question but it might help you work around your problem.

I use templates for mailmerge main documents because I almost always using
the merge with one record to create a custom document. I simply display the
data, lock the fields, and save the new document with the individual data
frozen in place. (This is also done with a macro that changes the document
to an ordinary Word document from a mailmerge document. The AutoNew macro
also calls up the select a record dialog.)
Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> use Word 2003 and export my data files from Access 2003.  I save merge
> files
[quoted text clipped - 7 lines]
> Any suggestions how to stop this happening.  My export files are text file
> and are comma and para mark delimited.
 
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.