Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-19-2024, 11:12 AM
meetgsp meetgsp is offline Mail mergefield formula help in word Windows XP Mail mergefield formula help in word Office 2021
Novice
Mail mergefield formula help in word
 
Join Date: Mar 2024
Posts: 1
meetgsp is on a distinguished road
Smile Mail mergefield formula help in word

How do I construct this formula in word?
If an input field value = blank (for a date field) it should return the text 'n/a' otherwise the date value in the mail merge word output document.
Date = "" then 'n/a' or


Date = xx/yy/zzzz then xx/yy/zzzz
Reply With Quote
 

Tags
merge field, merge fields, mergefield address word



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail mergefield formula help in word Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
Mail mergefield formula help in word Word vs Excel (NEXTIF, SKIPIF mergefield) jerry00769 Mail Merge 3 04-30-2012 03:43 PM
Mail Merge to multiple .doc files named after a mergefield nicnad Mail Merge 1 02-22-2012 01:59 AM
Mail mergefield formula help in word Mail Merge to print specific record based on mergefield criterias nicnad Mail Merge 1 02-22-2012 01:53 AM
Word mail merge and formula mridley Mail Merge 0 04-30-2006 11:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:07 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