Microsoft Office Forums IF statements in mail merge with results displayed based on date of letter

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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: 9
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
  #2  
Old 11-13-2019, 01:54 PM
macropod's Avatar
macropod macropod is offline IF statements in mail merge with results displayed based on date of letter Windows 7 64bit IF statements in mail merge with results displayed based on date of letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,670
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

To see how to do this and just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, a 'Sticky' thread at the top of the Word forum:
Microsoft Word Date Calculation Tutorial
In particular, look at the item titled Use Date (And/Or Time) Comparisons To Vary Text. Do read the document's introductory material.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
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


All times are GMT -7. The time now is 12:16 AM.


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