[Mike]

Dear macropod,

Haven't try this yet, but tried the DDE method suggested by Doug Robbins. It
worked, but have some problems if the files are stored in the server.

Anyway, thanks for your suggestion.

Regards,
Mike

"macropod" wrote:

Hi Mike,

The fact that there are different kinds of data in the fields doesn't prevent formatting switches being used. At most you'll need an
IF test. For example:
{IF{MERGEFIELD Data \@ "dd-MM-yy"}= "??-??-??" {MERGEFIELD Data \@ "dd-MM-yy"} {MERGEFIELD Data \# ",0.00"}}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


"Mike" wrote in message ...
How do I keep the display result in Mail Merge to follow exactly the format
set in the Excel file?

I cannot use the format switches due to the same field in the excel file
contains multiple format, ie. the same field contains data like date and
numbers, i need the display result in Word to show both dates and numbers.