|
#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
merge field, merge fields, mergefield address word |
|
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 |