![]() |
#2
|
||||
|
||||
![]()
ISTR this field code was required because you had the Excel workbook open when the merge was done, and that was messing with the formats. The 'N/A' was for those cases when the lights would not be used.
Try: {IF{MERGEFIELD LIGHTS_ON_TIME}= "" "N/A" {MERGEFIELD LIGHTS_ON_TIME \@ "h:mm AM/PM"}}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
JennEx | Mail Merge | 9 | 04-29-2017 08:58 AM |
![]() |
CPSmith | Excel | 1 | 03-26-2016 02:48 AM |
![]() |
sfkHooper | Mail Merge | 6 | 01-19-2016 04:24 PM |
How do you get the DATE and TIME fields to be included in an export to Excel? | tpieples | Outlook | 0 | 02-18-2013 12:11 PM |
Word 2010 - DOCX File with fields -> PDF with fields | senglory | Word | 2 | 03-27-2012 10:10 AM |