URGENT HELP with multiple records in same letter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick Cumberbatch - 08 May 2006 01:01 GMT

I have one form letter wich I need to C.c. to the records from a database.
How to I perform this

Example:
Letter 1

Dear Mr. X (from database A)

C.c. Record 1 (from database B1)
Record 2
Record 3
Record 4
to end

Letter 2:
Dear Mr. Y (from database A)

C.c. Record 1 (from database B2)
Record 2
Record 3
Record 4
to end

Letter 3:
Dear Mr. Z (from database A)

C.c. Record 1 (from database B3)
Record 2
Record 3
Record 4
to end

Please help me I need to complete this tonight for mailing tomorrow

Reply to this Message

Doug Robbins - Word MVP - 08 May 2006 08:20 GMT

You are trying to perform a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or this website

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.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 have one form letter wich I need to C.c. to the records from a database.
>How to I perform this
[quoted text clipped - 29 lines]
>
> Please help me I need to complete this tonight for mailing tomorrow

Reply to this Message

Rate this thread: