Problem in Access mail merge

[Guest]

I need help in access mail merge please

I would like to create a mail merge letter addressed to medical patients.
The data source is a list of medical patients, doctors, facilities, dates of
service & procedures for each patient of that doctor.
If the patient has more than 1 procedures and more than 1 date of service,
this should only be & should show only in 1 letter.
My problem is Word generates 1 letter for each instance.
I am limited in Word by a federally-mandated form letter & so the data
fields should be embedded in the letter.
I am using MS Access & Word 2000.
I appreciate your help as I am stumped !!
Thank you!

 

[Stephen Glynn]

I asked a very similar question in microsoft.public.word.newusers, and
got the following reply from Doug Robbins, one of the Word MVPs:

I would use an Access Report, not mail merge.

But, if you want to use mail merge, 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

The link provided in the first method discussed in Cindy Meister's
article seems to describe how to do pretty much what you want.

HTH

Steve