Separate string in email body

[navin]

Hello Everyone,

For one of my applications, I insert the details of the mail into a
database (Sender Name, Date received etc..) which is working fine.
Hoever, In the middle of body of the mail, i have a string separated
by commas and I need to split this string.

Please let me know if this possible.

Thanks,
Navin

 

[Ken Slovak - [MVP - Outlook]]

Sure it's possible.

How would depend on what language you're using, and how you propose to
recognize that string.

It also would help to know if you are using the Body or HTMLBody property.
Stating the Outlook version would earn you bonus points.

 

[navin]

Hello,

Thanks for replying to my questions.

Mail format is HTMLBody and I am using Outlook 2003. Below is the mail
which i receive.

Dear Navin,

This is to notify you that you have received a new work item from Work
Manager system.

Please follow the link below to review the work item.

WorkItem, Profiler Approval for Amendment 1, Corp.Services_408_Sun
Micro__StartDate__A1 <---- This is a link which takes me to the order
when clicked.

I need to split the above string which is separated by comma.

Thanks again for your help...

Navin

 

[Ken Slovak - [MVP - Outlook]]

Since you didn't bother to say what language you plan to use I'd have to
guess and say if you are using VBA/VB6 you'd use the Split() function which
returns an array of items split by a supplied delimiter. If you are using a
managed code language you'd use the .Split() function there on the string.

Use the Help on Split() for whatever language you're using to get the exact
syntax.

You'd find the string I guess by looking for "WorkItem" I guess, if that's
consistent. Then you would in the case of HTML look for a <br> or <p> or
whatever is used to end that text.




Hello,

Thanks for replying to my questions.

Mail format is HTMLBody and I am using Outlook 2003. Below is the mail
which i receive.

Dear Navin,

This is to notify you that you have received a new work item from Work
Manager system.

Please follow the link below to review the work item.

WorkItem, Profiler Approval for Amendment 1, Corp.Services_408_Sun
Micro__StartDate__A1 <---- This is a link which takes me to the order
when clicked.

I need to split the above string which is separated by comma.

Thanks again for your help...

Navin