Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Next Record If, problems with merging multiple records | Mailmerge | |||
Merging 2 or more records into 1 page | Mailmerge | |||
Duplicate Records Merging with Access | Mailmerge | |||
Problems merging many records on a single page | Mailmerge | |||
Merging data from two consecutive access records in Word 2002 | Mailmerge |