Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
dan
 
Posts: n/a
Default not merging duplicate records

Hello listers

I saw your code on the cindy meister website regarding suppressing
duplicates in a mail merge. I unfortaunately am not able to follow it very
well.

I have a data source with a bunch of fields. I only need 2 of the fields in
my mail merge document. When I merge them to my template I get lots of
multiples when I really need only one of each.

I am making labels for pricing items and have the following data source
model

itemnumber itemprice itemdescription itemmodel
1234 24.95 item1yellow 2
1234 24.95 item1gree 3
1234 24.95 item1blue 4
1234 24.95 item1red 5
4321 32.95 item1yellow 1
4321 32.95 item1orange 1

etc

but when i run a mail merge to make the labels i only need the item number
and the price since they are all the same. But running a normal mail merge
gives me 5 labels for item 1234 and two labels for 4321 when i really only
need two labels total as there are only two different item numbers.

If you could help me work through this or offer any code as to how to
accomplish this it would be greatly appreciated.

Altering the data source is not an option.

Thanks in advance!!!
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Next Record If, problems with merging multiple records [email protected] Mailmerge 0 January 13th 06 04:38 PM
Merging 2 or more records into 1 page tye Mailmerge 5 December 1st 05 09:47 PM
Duplicate Records Merging with Access markmidwest Mailmerge 3 June 13th 05 07:10 PM
Problems merging many records on a single page Carl Mercier Mailmerge 1 January 16th 05 12:27 AM
Merging data from two consecutive access records in Word 2002 Frank Spade Mailmerge 3 December 17th 04 09:51 AM


All times are GMT +1. The time now is 07:18 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"