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 2007

Tip: Looking for answers? Try searching our database.

Merge to extract data from word file to multiple letters at once?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kellymomof4 - 25 Apr 2007 16:38 GMT
I work for a nonprofit that uses Giftmaker. I export my donation data to a
word file. I then have a "thank you template letter" in word that I link to
my data file. Once I've made the link I complete the merge and the data is
somehow exported to my 12 thank you letters (new members & renewals at
different donor levels) so my new merged document is actually a combination
of many different letters and the correct data is in all of them. I'm in the
process of creating all new letters and can't figure out how to link them to
that original "template letter". (these letters were all created by a
previous employee)
Help!
Doug Robbins - Word MVP - 25 Apr 2007 18:20 GMT
It is not the "template letter" that you will be wanting to link them, but
to the data source.

What you might want to do is start by opening the original "template letter"
and then save it with a new name and modify it.  Do that as many times as
you want to (open the original "template letter", save with a new name and
then modify).  Each of the new files that you create in this way should be
linked to the data source.

You may also want to take a look at the following articles:

"How to create a Mail Merge" at:

http://www.word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm

"Creating a Mail Merge Data Source" at:

http://www.word.mvps.org/FAQs/MailMerge/CreateADataSource.htm

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

>I work for a nonprofit that uses Giftmaker. I export my donation data to a
> word file. I then have a "thank you template letter" in word that I link
[quoted text clipped - 10 lines]
> previous employee)
> Help!
 
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.