[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

[Doug Robbins - Word MVP]

How have you programmed it?

The way to do it would be with an If...else...then field construction like

{ IF { MERGEFIELD DateField } "" "{ MERGEFIELD DateField \@ "MMMM d,
yyyy" }" "" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and you use
Alt+F9 to toggle off their display.

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

"Fred Prémel" wrote in message
...
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

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


Doug Robbins - Word MVP wrote:
How have you programmed it?

The way to do it would be with an If...else...then field construction
like
{ IF { MERGEFIELD DateField } "" "{ MERGEFIELD DateField \@ "MMMM
d, yyyy" }" "" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and
you use Alt+F9 to toggle off their display.


"Fred Prémel" wrote in message
...
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