Blank date field in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Meadmaker - 28 Sep 2004 14:59 GMT

I am trying to create a mail merge in Word. My merge source is Excel. I'm
having trouble with a date field. If the field is empty, null or blank, I'm
not sure which, the merge output is 12:00:00 AM. If the field is populated
the output is correct i.e. 9/25/2004. I would like the output from the empty
field to remain blank. I've tried many things with no luck. Any suggestions?
Thx

Reply to this Message

Graham Mayor - 28 Sep 2004 17:46 GMT

Insert the field in a test document. Note EXACTLY what is produced then in
your merge document test for that exact result eg

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am trying to create a mail merge in Word. My merge source is Excel.
> I'm having trouble with a date field. If the field is empty, null or
> blank, I'm not sure which, the merge output is 12:00:00 AM. If the
> field is populated the output is correct i.e. 9/25/2004. I would like
> the output from the empty field to remain blank. I've tried many
> things with no luck. Any suggestions? Thx

Reply to this Message

lnahant@yahoo.com - 30 Sep 2004 18:37 GMT

Mead,
I am having the same problem. Did you find a soluntion?
I am on Word and Excel 2002.

Thank you.

>-----Original Message-----
>I am trying to create a mail merge in Word. My merge source is Excel. I'm
[quoted text clipped - 4 lines]
>Thx
>.

Reply to this Message

Rate this thread: