Double Merge Possible in a letter

[jeff rowland]

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

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

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