Are you definitely selecting the DDE option when you are prompted for the
different connection methods?
If so, you may need to use an IF field such as
{ IF "{ MERGEFIELD myfield }" = "12:00:00 AM" "" "{ MERGEFIELD myfield }" }
where all the {} are the special field code braces you can insert using
ctrl-F9.
The match will need to be exact, i.e. if your MERGEFIELD field returns
12:00:00AM with no spaces, that's what you will need to compare with.
Unfortunately if you have /real/ entries that actually need to say 12:00:00
AM this approach obviously won't work.
(I'm not sure whethert he following link is relevant in this case
http://tips.pjmsn.me.uk/t0003.htm
)
Peter Jamieson
"riri" wrote in message
ups.com...
Hello again,
I checked this option Confirm Conversion at open in word and then I
try to open my excel sheet
to get the date for the mergge but I still get the 12:00:00 AM in
some
of the records..If I have only that record in the excel sheet it is
working fine without giving me any 12:00:00AM. Therefore the fields
that appear with 12:00:00 AM are not empty. Is there any other
solution for this issue?
Thanks in advance