Using the Filter in Excel seems to be the best approach. I'm kinda doing
that right now by having 4 different Excel sheets (LOL) I'll ask in the
Excel group, thanks very much.
While I agree with Peter about filtering in the data file, a possible
alternative method would be to have four different merge documents each
accessing the same data file.
In this case the label would have
Case 1
{IF {Mergefield Country} = "Canada" "{Mergefield LastName} {Mergefield
Initial}
{Mergefield Address1} {Mergefield Address2}
{Mergefield City}, {Mergefield Prov}
{Mergefield PostalCode}
{Mergefield Country}"}
Case 2
{IF {Mergefield Country} = "Canada" "{Mergefield LastName} {Mergefield
Initial}
{Mergefield Address1} {Mergefield Address2}
{Mergefield City}, {Mergefield Prov}
{Mergefield PostalCode}
{Mergefield Country}"}
Case 3
{ IF { Mergefield Country } = "Canada" "{ IF { Mergefield Email } = "" "{
Mergefield LastName } { Mergefield Initial }
{ Mergefield Address1 } { Mergefield Address2 }
{ Mergefield City }, { Mergefield Prov }
{ Mergefield PostalCode }
{ Mergefield Country }" ""}" "" }
Case 4
{ IF { Mergefield Country } <> "Canada" "{ IF { Mergefield Email } = "" "{
Mergefield LastName } { Mergefield Initial }
{ Mergefield Address1 } { Mergefield Address2 }
{ Mergefield City }, { Mergefield Prov }
{ Mergefield PostalCode }
{ Mergefield Country }" ""}" "" }
This would test each record to see that it fits the criteria
You could even save each of the four blocks of fields as autotext entries
and add them to the first label of a blank merge label document and
propagate then merge. Note that the fields are entered from the keyboard
using CTRL+F9 for each pair of brackets.
For other examples see http://www.gmayor.com/formatting_word_fields.htm

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Using the Filter in Excel seems to be the best approach. I'm kinda
> doing that right now by having 4 different Excel sheets (LOL) I'll
[quoted text clipped - 50 lines]
>>> Regards
>>> Michael Koerner
Graham Mayor - 22 Feb 2007 14:08 GMT
On reflection - perhaps not. This would leave blank labels where the data
does not match. Stick to the filtering ;)

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> While I agree with Peter about filtering in the data file, a possible
> alternative method would be to have four different merge documents
[quoted text clipped - 106 lines]
>>>> Regards
>>>> Michael Koerner
Michael Koerner - 22 Feb 2007 20:43 GMT
LOL, I asked in the Excel ng, and they said I should filter through Word.
Guess I'll stick with what I have got, a different Excel worksheet for each
merge.

Signature
Regards
Michael Koerner
> On reflection - perhaps not. This would leave blank labels where the data
> does not match. Stick to the filtering ;)
[quoted text clipped - 109 lines]
>>>>> Regards
>>>>> Michael Koerner