Hi,



I'm new to this forum :-) and have question wrt mail merge.

I have pulled data from excel and created mail merge document. The excel has a "end time" column which may be blank or contains ">" or time in 24hrs format.

The problem is that ">" is shown as 00:00 AM in the merged document but whenever column has correct time or blank, it shows appropriate contents. I can't take ">" out because it's needed.

Is there any that I can interpret ">" as it is?

Thanks,
Gaurav

Hi Gaurav,

You should be able to achieve that by making sure your data's first record contains the '>' symbol or some other text string in that field (eg by inserting a dummy record).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]