View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default How can I suppress duplicate field data in a Word mail merge?

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!