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

Tip: Looking for answers? Try searching our database.

mail merge directory

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jack west - 14 Jan 2004 19:05 GMT
Im trying to set up a mail merge directory sheet so that
I can create a new daily delivery schedule for my trucks.
Problem is: that once Im done & merged to new document, i
cannot revise list by checking/unchecking recipient list,
instead i have to create a new mail merge operation every
day. How do I create one master sheet that can be changed
daily???
Thanks
Peter Jamieson - 15 Jan 2004 09:06 GMT
You are right that the output from a merge does not automatically reflect
changes in the data source, but that is simply how mail merge works (and in
fact most ways of generating reports from base data work in much the same
way). But you should not have to "create a new mail merge operation" every
day. You should be able to
a. mark the list you are using as your data source in some way (perhaps
have a field called Include which is set to Y or blank)
b. have a mailmerge main document that is set up with a filter so that only
the records where Include=Y are merged
c. open the mailmerge main document and do the merge each day.

Although that should work in theory, several problems in Word (especially
Word 2002) can thwart you because they result in the data source becoming
detached from the mail merge main document, so each day you would have to
re-attach the data source and re-create the Include=Y filter. If that is
what is happening, let us know what version of Word you are using, what your
data source is, andhow you are connecting to it.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Im trying to set up a mail merge directory sheet so that
> I can create a new daily delivery schedule for my trucks.
[quoted text clipped - 4 lines]
> daily???
> Thanks
Cindy M  -WordMVP- - 15 Jan 2004 09:08 GMT
Hi Jack,

> Im trying to set up a mail merge directory sheet so that
> I can create a new daily delivery schedule for my trucks.
[quoted text clipped - 3 lines]
> day. How do I create one master sheet that can be changed
> daily???

Mail merge wasn't conceived to do this kind of thing.
Perhaps this data would be better in an Excel spreadsheet?

Where (in what application and format) is the data you're
using for the merge currently stored?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
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.