Mail merge from Excel to Word inserts time in a field supposed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dismayed microsoft user - 14 Nov 2005 20:12 GMT

...to be blank

Hello,

The problem I am seeing is with a letter that gets address from an Excel
spreadsheet and drops it into the form letter. However, Word is entering
"12:00:00A.M." into some merge fields which should otherwise be blank.

Reply to this Message

macropod - 15 Nov 2005 07:04 GMT

Hi dismayed,

If you copy and paste your existing mailmerge field, which probably looks
something like:
«ExcelDate»
so that you get:
«ExcelDate»«ExcelDate»
then select both fields and Press Ctrl-F9, you'll get:
{ «ExcelDate»«ExcelDate» }
If you then fill in between the braces so that you get:
{IF«ExcelDate»= 0 "" «ExcelDate»}
that should give the result you're after. Note that you need to be careful
to have a space either side of the pair of double quotes.

Cheers

> ...to be blank
>
[quoted text clipped - 3 lines]
> spreadsheet and drops it into the form letter. However, Word is entering
> "12:00:00A.M." into some merge fields which should otherwise be blank.

Reply to this Message