Thread: [Solved] IF statements in mail merge with results displayed based on date of letter
View Single Post
 
Old 11-13-2019, 06:54 AM
ajh19742000 ajh19742000 is offline Windows 10 Office 2013
Novice
  
Join Date: Dec 2015
Posts: 10
ajh19742000 is on a distinguished road
Default IF statements in mail merge with results displayed based on date of letter
Hi,
I would like to develop some IF statements within a mail merge that display results based on if a date is greater or less than the date the letter is produced?
For example
{if date letter is produced <=13/11/19 then "example text 1"}
{if date letter is produced >13/11/19 but <=29/2/2020 then "example text 2"}
{if date letter is produced >29/2/2020 but <=6/6/2020 then "example text 3"}

Is this possible at all and what would be the code? The date letter is produced field would be the Insert>date and Time field within the Insert menu.
Hope that makes sense.
Andy
Reply With Quote