Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2006

Tip: Looking for answers? Try searching our database.

How can I suppress duplicate field data in a Word mail merge?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JamesV - 17 Nov 2006 17:16 GMT
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 - 17 Nov 2006 18:34 GMT
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/cindymeister/mergfaq1.htm#DBPic

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Peter Jamieson

>I preparing a directory mail merge (Word 2003) using an Access 2003
>database
[quoted text clipped - 21 lines]
> the
> previous record?  Any help would be appreciated!  Thanks!
JamesV - 20 Nov 2006 11:25 GMT
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

> Word isn't really geared for this kind of thing - since you are using
> Access,
[quoted text clipped - 10 lines]
>
> Peter Jamieson
JamesV - 20 Nov 2006 11:27 GMT
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

> Word isn't really geared for this kind of thing - since you are using
> Access,
[quoted text clipped - 10 lines]
>
> Peter Jamieson
JamesV - 20 Nov 2006 11:27 GMT
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

> Word isn't really geared for this kind of thing - since you are using
> Access,
[quoted text clipped - 10 lines]
>
> Peter Jamieson
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.