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 / May 2006

Tip: Looking for answers? Try searching our database.

Merging records with matching data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Barb Miles - 22 May 2006 15:03 GMT
I want to merge multiple records in to a letter based on matching city names.

When I use the NextRecordIf field, I get no data.

Any suggestions?
Signature

Barb

Graham Mayor - 22 May 2006 17:27 GMT
See How to use mail merge to create a list sorted by category in Word 2002 -
http://support.microsoft.com/?kbid=294686

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I want to merge multiple records in to a letter based on matching
> city names.
>
> When I use the NextRecordIf field, I get no data.
>
> Any suggestions?
Peter Jamieson - 22 May 2006 17:33 GMT
If you are trying to do a "Multiple records per item" merge,
a. Word isn't very good at it - if you can use an Access report or some
such, I'd try that
b. If you have not done so already, see the "Group Multiple items for a
single condition" item on
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/

Look for Mail Merge fAQ, Tips 'n' Tricks, Multiple Items per condition.

As far as NextRecordIF is concerned,
c. it may not work the way you expect
d. what comparison are you doing in your NextRecordIf field - i.e. what is
in the field code, and can you provide examples of the actual data being
compared ? (use Alt-F9 to see the underlying field code)

Peter Jamieson

>I want to merge multiple records in to a letter based on matching city
>names.
>
> When I use the NextRecordIf field, I get no data.
>
> Any suggestions?
 
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.