Empty > 12:00:00 AM?

J

JethroUK©

Empty date field in XL when mailmerged reads:

12:00:00 AM

The merge field contains {MERGEFIELD "MDP"} no additional formatting

Any Ideas? I was wondering whether i can use an 'If' command with this, or
maybe some formatting option?
 
G

Graham Mayor

You can use a conditional field to trap it

{IF {Mergefield MDP} <> "12:00:00 AM" "{Mergefield MDP}" }

should do the trick.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excluding 12:00:00 AM from query results 4
12:00:00 AM 1
Null dates in Access as '12:00:00 AM' in Word mailmerge 2
Sat 20 Oct 11:00 AM > Sun 20 Oct 11:00 AM ?? 4
Conditional Pagebreaks in Mailmerge 2
Email Mail Merge via linked Excel sheet 0
Create a chart from a table in word thats dynamic 0
Empty merge fields come over as 12:00:00 1

Top