Mail mergefield formula help in word

meetgsp · #1 03-19-2024, 11:12 AM

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

macropod · #2 03-20-2024, 05:05 AM

That all depends on what your mergefield outputs when blank. From there it's a simple matter to build an IF test that tests for that output.

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