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 / October 2007

Tip: Looking for answers? Try searching our database.

how do I save a selected mail merge list for multiple letters etc

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Craig07 - 24 Oct 2007 05:31 GMT
Hi

I am regularly processing memberships of an association and when memberships
are paid I need to prepare Word documents for the payment receipt and
thankyou, membership certificate, membership card - front and back, and
envelope.

The membership details / fields are in an Excel spreadsheet. Excel and Word
are both from Office 2007.

My question is how do I select the mail merge list once only then save it to
use for all of those documents.  

I would then do this process again for the next batch of payments.

Thanks
Graham Mayor - 24 Oct 2007 06:21 GMT
The list is your Excel worksheet? Attach the worksheet to your merge
document - essentially the procedure at
http://www.gmayor.com/merge_labels_with_word_2007.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi
>
[quoted text clipped - 12 lines]
>
> Thanks
Peter Jamieson - 24 Oct 2007 11:28 GMT
From what you are saying it sounds as if you may be creating a new Excel
workbook for each new member, or that at the very least, you may need to
select that specific member in each mail merge main document to print the
relevant material for that member.

IMO the best thing to do is connect all of your mail merge main documents,
once and for all, to an Excel workbook whose name and location never varies,
that always has the same columns, and which has exactly one record. e.g. you
connect them all to

c:\memberdata\onenewmember.xls

or whatever.

Then, with all the mail merge main documents closed, you either copy the
excel workbook containing the new member details to that file, or create a
new one with just theat member's details.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Hi
>
[quoted text clipped - 15 lines]
>
> 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.