|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 28th, 2009, 07:16 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
SkipIf feature
How can I use the SkipIf feature to select only the first occurance of a
value when there are several records with the same value something like SKIPIF bar_code = bar_code records look like box barcode 082 1233 082 1233 082 1233 084 1234 084 1234 and I only need one line for each barcode. 
|
|
#2
July 29th, 2009, 05:34 AM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
SkipIf feature
See How to use mail merge to create a list sorted by category -
http://support.microsoft.com/?kbid=294686 Fellow MVP 'macropod' has posted a tutorial on this, with working field codes and a sample Excel data source which you can download from my website http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org catawaller wrote: How can I use the SkipIf feature to select only the first occurance of a value when there are several records with the same value something like SKIPIF bar_code = bar_code records look like box barcode 082 1233 082 1233 082 1233 084 1234 084 1234 and I only need one line for each barcode.
|
|
#3
July 30th, 2009, 06:21 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
SkipIf feature
Thank you so much. You are truly an MVP!
"Graham Mayor" wrote: See How to use mail merge to create a list sorted by category - http://support.microsoft.com/?kbid=294686 Fellow MVP 'macropod' has posted a tutorial on this, with working field codes and a sample Excel data source which you can download from my website http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org catawaller wrote: How can I use the SkipIf feature to select only the first occurance of a value when there are several records with the same value something like SKIPIF bar_code = bar_code records look like box barcode 082 1233 082 1233 082 1233 084 1234 084 1234 and I only need one line for each barcode.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
