Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail Merge using IF THEN....
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 individuals 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. |
#2
|
|||
|
|||
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.***" } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org BLansinger wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge | |||
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements | Mailmerge |