Mail merge problem

  • Thread starter Thread starter GKW in GA
  • Start date Start date
G

GKW in GA

How can I do this mail merge:

I have a Excel spreadsheet that I use as input for a Word document that I
want to use to print letters to send to homeowners in our association,
notifying them of violations of our deed restrictions.

Each row in Excel has the name, address and violation. So if a homeowner
has, say 3 violations, there is going to be 3 rows with the same name and
address, one for each violation. What I want to do is, for each homeowner,
print the name and address on the letter only once (in the heading) but print
each violation in the body of the letter. So, essentially, what I want to do
is only print the name and address from the first row of a block that have
the same name and address, but print the violation from each row.

Is there a way to do this?
 
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 the following article give a good description of how it can be done, with
an explanation of the purpose of each step.

http://cornell.veplan.net/article.aspx?&a=3815

It may be the best one for your to try.
--
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
 
Back
Top