Please help with IF Field! going nuts

E

Excel ??

Hello everyone,
I appreciate your continued help - I'm yet processing another mass mailings,
this has different addresses obviously - the trick is some are within the US
and some another country, i'm using a spreadsheet as my data source, how do i
do the "if" is another country not to include on etc..thank you so much all
 
M

macropod

Hi,

Assuming you don't want the mailout to go to non-US countries, you could use a SKIPIF field to compare the country field against the
US. If country is not the US, the field skips the current record and moves to the next record.

Cheers
 
E

Excel ??

Thank you so much for the reply how do i insert this field or how do i set it
up, i've never done" If's before thank you
--
2


macropod said:
Hi,

Assuming you don't want the mailout to go to non-US countries, you could use a SKIPIF field to compare the country field against the
US. If country is not the US, the field skips the current record and moves to the next record.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

Excel ?? said:
Hello everyone,
I appreciate your continued help - I'm yet processing another mass mailings,
this has different addresses obviously - the trick is some are within the US
and some another country, i'm using a spreadsheet as my data source, how do i
do the "if" is another country not to include on etc..thank you so much all
 
M

macropod

Hi,

The SKIP field's usage is described in Word's Help file.

For your purposes, it could be coded along the lines of:
{SKIPIF{MERGEFIELD Country}<> "USA"}
where the field braces (ie '{ }') are created in pairs via Ctrl-F9.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

Excel ?? said:
Thank you so much for the reply how do i insert this field or how do i set it
up, i've never done" If's before thank you
--
2


macropod said:
Hi,

Assuming you don't want the mailout to go to non-US countries, you could use a SKIPIF field to compare the country field against
the
US. If country is not the US, the field skips the current record and moves to the next record.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

Excel ?? said:
Hello everyone,
I appreciate your continued help - I'm yet processing another mass mailings,
this has different addresses obviously - the trick is some are within the US
and some another country, i'm using a spreadsheet as my data source, how do i
do the "if" is another country not to include on etc..thank you so much all
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top