Empty merge fields come over as 12:00:00

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pepper - 03 May 2006 21:18 GMT

When merging from Excel into Word 2002 the fields that are empty (a date
field) comes over with 12:00:00 instead of blank. I am putting together a
roster that shows birthdates. When the birthdate is unknown the field in
Excel is empty. When it merges into word the field indicates the time instead
of being blank. How can I insert this field without the time.

Reply to this Message

Doug Robbins - Word MVP - 04 May 2006 04:51 GMT

Use an If...then...Else... construction

{ IF { MERGEFIELD Birthdate } = "12:00:00" "" { MERGEFIELD Birthdate } }

You must use Ctrl+F9 to insert each pair of field delimiters { } and Alt+F9
to toggle off their display

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> When merging from Excel into Word 2002 the fields that are empty (a date
> field) comes over with 12:00:00 instead of blank. I am putting together a
> roster that shows birthdates. When the birthdate is unknown the field in
> Excel is empty. When it merges into word the field indicates the time
> instead
> of being blank. How can I insert this field without the time.

Reply to this Message

Rate this thread: