View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 79
Default mail merging date fields from excel

The problem is that the fields are not empty - they are reproducing
12:00AM - so you need to modify the condition to search for that

{ IF { MERGEFIELD contract_received } "12:00*" "{ MERGEFIELD
contract_received \@ "dd/MM/yyyy" }" }
should do the trick - or put *exactly* what the 'empty' fields produce in
place of 12:00* above.

--

Graham Mayor - Word MVP

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




pama wrote:
Hello everyone,
I have the same problem as the post on 12/8/05 "Data fields in mail
merge", so I will use their elequent words...
"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 then tried the fix for it.....
Use

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

But this did not work.
Any suggestions?