Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Excel ?? Excel ?? is offline
external usenet poster
 
Posts: 4
Default Please help with IF Field! going nuts

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
--
2
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Please help with IF Field! going nuts

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 ??" wrote in message ...
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
--
2


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Excel ?? Excel ?? is offline
external usenet poster
 
Posts: 4
Default Please help with IF Field! going nuts

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" wrote:

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 ??" wrote in message ...
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
--
2



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Please help with IF Field! going nuts

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 ??" wrote in message ...
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" wrote:

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 ??" wrote in message ...
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
--
2




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
I have a Norton/Word/XP conflict that is driving me nuts! Bob Hewson Microsoft Word Help 3 August 22nd 07 04:06 PM
Emails to client have no page numbers & line numbers are nuts {URG Lindsay Page Layout 1 June 26th 06 04:48 AM
"...merged field does not exist..." Driving me nuts! MichaelHunter Mailmerge 3 November 10th 05 06:49 PM
Word outline feature driving me nuts Relztrah Page Layout 2 July 6th 05 11:33 PM
Heading Are Driving Me Nuts Peyton Todd Page Layout 12 May 16th 05 04:39 PM


All times are GMT +1. The time now is 09:58 AM.

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

About Us

"It's about Microsoft Word"