Mail Merge saga

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill D - 23 Jun 2006 17:24 GMT

Working in Word 2002. I have an Access Table sorted by Vendor Number (key).
Each Vendor has 1 to many Divisions. I need to create a Mail Merge that will
print as follows.... NOTE <equals Access Fields>

<VendorName>
<Address1>
<Address2>
<City>, <State> <Zip>

A paragrah of misc Text..........

Here's where I need to bring in the Division(s)...

<Divison>, next <Division>, next <Division> and so on until all the related
Divisions for this Vendor are listed.

This a HOT issue I need help ASAP.

I know how to build a 'normal' mail merge letter... just adding the
Divisions is driving me nuts. I have tried the {If} clause and it's not
work.

Bill

Reply to this Message

Doug Robbins - Word MVP - 23 Jun 2006 18:37 GMT

As the data is in Access, if I were you, I would use a report in Access.

Word does not really have the ability to do that, but see:

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

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

> Working in Word 2002. I have an Access Table sorted by Vendor Number
> (key).
[quoted text clipped - 22 lines]
>
> Bill

Reply to this Message