[JamesV]

I preparing a directory mail merge (Word 2003) using an Access 2003 database
as my record source. My directory lists various offices around the world, of
which more than one can be in a country. I want to create a mail merge that
lists all of the locations in a country, but without repeating the country
name each time. Each record in my database contains a country and location
name. For example, my mail merge looks like this:
AUSTRALIA
Brisbane
AUSTRALIA
Perth
AUSTRALIA
Sydney

I want my directory to instead look like this:
AUSTRALIA
Brisbane
Perth
Sydney

How can I suppress the reappearance of the country name if it duplicates the
previous record? Any help would be appreciated! Thanks!

[Peter Jamieson]

Word isn't really geared for this kind of thing - since you are using
Access,
for example, you may be able to do what you need using the Access report
designer.

However, to attempt it in Word, see the following articles:

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

http://support.microsoft.com/default...b;en-us;211303

http://www.knowhow.com/Guides/Compou...poundMerge.htm

Peter Jamieson

"JamesV" wrote in message
...
I preparing a directory mail merge (Word 2003) using an Access 2003
database
as my record source. My directory lists various offices around the world,
of
which more than one can be in a country. I want to create a mail merge
that
lists all of the locations in a country, but without repeating the country
name each time. Each record in my database contains a country and location
name. For example, my mail merge looks like this:
AUSTRALIA
Brisbane
AUSTRALIA
Perth
AUSTRALIA
Sydney

I want my directory to instead look like this:
AUSTRALIA
Brisbane
Perth
Sydney

How can I suppress the reappearance of the country name if it duplicates
the
previous record? Any help would be appreciated! Thanks!

[JamesV]

Dear Peter

Thank you so much for your reply - your second link to the MS HOW TO looks
to be perfect and I shall follow this route.

FYI, the third link you provided appears to be 404.

Thanks again!

James

"Peter Jamieson" wrote:

Word isn't really geared for this kind of thing - since you are using
Access,
for example, you may be able to do what you need using the Access report
designer.

However, to attempt it in Word, see the following articles:

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

http://support.microsoft.com/default...b;en-us;211303

http://www.knowhow.com/Guides/Compou...poundMerge.htm

Peter Jamieson

[JamesV]

Dear Peter

Thank you so much for your reply. Your second link to the MS HOW TO article
appears to solve my problem and I will try to follow that route.

(FYI, your third link appears to be 404.)

Thanks again.

James

"Peter Jamieson" wrote:

Word isn't really geared for this kind of thing - since you are using
Access,
for example, you may be able to do what you need using the Access report
designer.

However, to attempt it in Word, see the following articles:

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

http://support.microsoft.com/default...b;en-us;211303

http://www.knowhow.com/Guides/Compou...poundMerge.htm

Peter Jamieson

[JamesV]

Dear Peter

Thank you so much for your reply. Your second link to the MS HOW TO article
appears to solve my problem and I will try to follow that route.

(FYI, your third link appears to be 404.)

Thanks again.

James

"Peter Jamieson" wrote:

Word isn't really geared for this kind of thing - since you are using
Access,
for example, you may be able to do what you need using the Access report
designer.

However, to attempt it in Word, see the following articles:

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

http://support.microsoft.com/default...b;en-us;211303

http://www.knowhow.com/Guides/Compou...poundMerge.htm

Peter Jamieson