Mail Merge using IF THEN....

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BLansinger - 23 Mar 2005 15:53 GMT

I am trying to format a text box to come up in my mail merge letters only
when certain conditions are met. I want the box to come up only if the date
is greater than or equal to TODAY. However the date that comes form the data
source comes out only in M/YYYY format. I tried:

{{IF{MERGEFIELD INSTITUTION END MY}>= "{TIME\@ "m/yyyy"}""***If you have
received this letter prior to this individual’s stated graduation date,
please hold response until degree can be officially verified. We are unable
to accept post-dated letters. Thank you.***"" ""}

This is not working. Will I need to covert the dates to text & the evaluate
them to get the greater to equal? I am lost!

Thanks.

Reply to this Message

Graham Mayor - 23 Mar 2005 17:50 GMT

Your syntax is all over the place. Most important you cannot compare the
dates in the format you have. You need a full date to get any closer than
the 1st of the month in from your field. It is also unusual to have spaces
in field names. It should work with underscores in place of the spaces in
the fieldname

The following should work. Note the spaces and switches - a fuller
explanation can be found at http://www.gmayor.com/formatting_word_fields.htm

{ IF{ MERGEFIELD INSTITUTION_END_MY \@ "yyyyMMdd" } >= { DATE \@
"yyyyMMdd" } "***If you have received this letter prior to this individual's
stated graduation date, please hold response until degree can be officially
verified. We are unable to accept post-dated letters. Thank you.***" }

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am trying to format a text box to come up in my mail merge letters
> only when certain conditions are met. I want the box to come up only
[quoted text clipped - 11 lines]
>
> Thanks.

Reply to this Message