Re: 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?


.

Relevant Pages

  • Re: assistnace with mailmerge dates from excel
    ... Word MVP web site http://word.mvps.org ... > correctly but when the date field is empty the merge field is filled ... > I'm using word 2002 SP3 and the same version of excel. ... > with all the appropriate data fields and retains there format, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail merge .. . If Then Else
    ... Word MVP web sitehttp://word.mvps.org ... With regards word mail merge i dont have any ... there must be numerous other switches e.g. \*Lower etc. ... Hi - just tried the suggested fix and it still doesnt work - the code ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How to detect if autotext entry is showing?
    ... Enter in a bulleted list and the paragraph is empty, ... > hstijnen nous racontait que: ... >> the item is empty, the list is ended and the correct style is ... > Jean-Guy Marcil - Word MVP ...
    (microsoft.public.word.vba.general)
  • Re: Mail merge .. . If Then Else
    ... Word MVP web sitehttp://word.mvps.org ... With regards word mail merge i dont have any ... there must be numerous other switches e.g. \*Lower etc. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How to import labels from a text file
    ... Just create a table with the extra columns to accommodate the empty ... Graham Mayor - Word MVP ... Word MVP web site http://word.mvps.org ...
    (microsoft.public.word.mailmerge.fields)