Double Merge Possible in a letter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jeff rowland - 18 Dec 2003 13:01 GMT

Ex. Have a access database with a table that has 3 fields;
class name,start date, end date. What I would like to do
is produce a letter that will say something like.

The following classes will be available during the next
4 months:

Class Start Date End Date
xxxxxxx xxxxxx xxxxxxx

The program would perform a merge that will print a letter
with the above info in the body of the letter for each
record in the database

IE. If the database has 3 records:
CITP-401 12/01/03 12/31/03
BITP-401 01/01/04 01/31/04
FITP-401 02/25/04 02/28/04

The letter would print as follows:

Dear XXXXX,
The following classes will be available during the
next 4 months:

CLASS START END
CITP-401 12/01/03 12/31/03
BITP-401 01/01/04 01/31/04
FITP-401 02/25/04 02/28/04
.
.
TIETP-401 12/25/03 12/31/03

I've seem to have figured out how to print the list of
classes in the letter using the directory function in a
merge routine but neet to figure out how then to send this
list of classes to every name/address I have stored in a
MS Access table.

Thanks

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 18 Dec 2003 13:41 GMT

Hi Jeff,

That can be done quite simply with a report in Access. Not so simple to do
it in Word.

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Ex. Have a access database with a table that has 3 fields;
> class name,start date, end date. What I would like to do
[quoted text clipped - 36 lines]
>
> Thanks

Reply to this Message