Current date/time displayed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Huub - 27 Jun 2005 14:34 GMT

Merging Word 2003 with Excel 2003 sheet as input.

If the field "GebdatP" is empty in the Excel file the Word 2003 field
{MERGEFIELD GebdatP \@ "d MMMM yyyy"} results in "27 june 2005", but we
expect an empty field!

If the field "GebdatP" is empty in the Excel file the Word 2003 field
{MERGEFIELD GebdatP } results in "12:00 00 AM"

The field "GebdatP" is not really empty, but filled with a statement =IF(....)

This problem just occurs today without changing the original Word document,
normally these fields were as expected empty in my Word document.

Regards, Huub.

Reply to this Message

Huub - 27 Jun 2005 15:22 GMT

Also tried to create a field like:

"{IF {MERGEFIELD GebdatP}="12:00 00 AM" "" "{MERGEFIELD GebdatP \@ "d MMMM
yyyy"}}

but that doesn't also result in a correct way.

> Merging Word 2003 with Excel 2003 sheet as input.
>
[quoted text clipped - 11 lines]
>
> Regards, Huub.

Reply to this Message

Graham Mayor - 28 Jun 2005 06:02 GMT

What result do you get?
Are you inserting the conditional fields using CTRL+F9 for the field
boundaries?
Try the inverse
{IF {MERGEFIELD GebdatP} <> "12:00 00 AM" "{MERGEFIELD GebdatP \@ "d MMMM
yyyy"}"}
Note the spaces and quotes.
See also the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

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

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

> Also tried to create a field like:
>
[quoted text clipped - 20 lines]
>>
>> Regards, Huub.

Reply to this Message

Huub - 29 Jun 2005 08:56 GMT

Thanks Graham, this works!!!!

> What result do you get?
> Are you inserting the conditional fields using CTRL+F9 for the field
[quoted text clipped - 5 lines]
> See also the Excel data section of
> http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Reply to this Message

Graham Mayor - 29 Jun 2005 15:25 GMT

You are welcome :)

Signature

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

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

> Thanks Graham, this works!!!!
>
[quoted text clipped - 15 lines]
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Reply to this Message

Rate this thread: