Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-13-2019, 06:54 AM
ajh19742000 ajh19742000 is offline IF statements in mail merge with results displayed based on date of letter Windows 10 IF statements in mail merge with results displayed based on date of letter Office 2013
Novice
IF statements in mail merge with results displayed based on date of letter
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
IF statements in mail merge with results displayed based on date of letter IF Statements for a several ranges of values using Mail Merge Jennifert Mail Merge 2 05-01-2019 09:40 PM
I know nothing about mail merge, but need help with conditional statements briyosa Word 1 03-27-2017 10:17 PM
IF statements in mail merge with results displayed based on date of letter Using multiple IF statements on a mail merge ajh19742000 Mail Merge 1 11-01-2016 06:11 PM
IF statements in mail merge with results displayed based on date of letter showing results of If statements in a mail merge m&co Mail Merge 3 01-06-2012 07:27 PM
IF statements in mail merge with results displayed based on date of letter Deleting records/results from mail merge alexb123 Mail Merge 2 08-12-2011 02:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft