Data fields in mail merge

[Lighthouse]

I have a Word mail merge document, used to import Excel data - only dates.
When I have merged the data, all empty Excel date cells are populated in Word
by 12:00AM. I have edited the Word field codes to UK date format (they were
US), and now all empty Excel date cells are populated in Word with today's
date! Is there a way of telling Word to leave empty cells alone and leave
them blank?

Word cells are formatted with { MERGEFIELD contract_received\@"DD/MM/YYYY" }
- this is exact, including spaces. Would this formatting put a date into
every Word cell, even if the corresponding Excel cell is empty?

Any help will be gratefully received.

 

[Doug Robbins - Word MVP]

Use

{ IF { MERGEFIELD contract_received } <> "" { MERGEFIELD contract_received
\@"DD/MM/YYYY" } "" }

--
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