Hi,

I have the following data that comes in from a web form from various users, the data always looks the same:

====

From: Buddha-liscous <[email protected]>

2011 Ranking:
42

====

I would ideally like a macro that will work through each email in the particular folder and extract the data into the following formats:

A1 = EMAIL, B1 = NAME, C1 = RANKING
A2 = [email protected], B2 = Buddha-liscous, C2 = 42

There will be people that have all sorts of characters in their name so that will have to be dealt with. I'm happy for the 'space' on the end to be added.

I've looked pretty hard on the internet and keep finding things that will do half of what I want, but I don't really have enough experience with VBA in order to modify them again.

I would appreciate any help that any gurus out there might have for me.

Cheers,
Warren