Interpret ">" as time or text?

gauravsays · #1 10-18-2011, 04:17 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error Outlook 2003 " Receive much mail the same at the same time"	nhat2nhat2	Outlook	1	09-26-2011 11:10 PM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
Sharing "main" calendar - time period issue	Oyvind	Outlook	0	05-20-2011 03:54 AM
Add a period of time to a referenced "Time" cell?	derelyth	Excel	4	03-27-2011 04:31 PM
Identify "Propose New Time" meeting responses in VBA, and how to response with them	frilian	Outlook	0	09-02-2010 07:48 AM