#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
catawaller catawaller is offline
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
catawaller catawaller is offline
external usenet poster
 
Posts: 2
Default 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.




Reply
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
Comparison problem w/SkipIf RobWN Mailmerge 2 November 27th 08 11:37 PM
Mail merge question about SKIPIF and NEXTIF blingting Mailmerge 2 August 21st 07 04:45 PM
SKIPIF Error? Word 2000 Chris Stammers Mailmerge 2 May 16th 07 08:28 PM
Merge error when SkipIf added vanessa Mailmerge 2 July 1st 05 06:30 PM
Skipif able to stop printing altogether? Graham Mailmerge 0 February 11th 05 03:47 PM


All times are GMT +1. The time now is 04:01 AM.

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

About Us

"It's about Microsoft Word"