problem with date

[Fred Prémel]

hello,
i'm fusionning excel into a word document
in excel, i have a field with dates
i've prgrammed Word to fill this field if there's somthing in the excel
case, or leave it empty if ther's nothing.
BUT : if the excel case is empty, Word puts the date of today !
What can I do
Thanks

 

[Graham Mayor]

Hmmm. I suspect that if the datefield is producing today's date rather than
nothing, then the field result is not equal to nothing and therefore
checking for a nul entry would not work - in such circumstances DDE
connection would be a plan?

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the data source to the mail merge main document, you will be
given the option of using the DDE method of connection which should read the
data as you have it formatted in the table.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>