Importing HTML data into excel
 

I have 3,000 emails with the same format data. These are in HTML format. I
want to copy and paste the info into excel but i am trying to find a way to
easily do this without having to format each entry.

I am familiar with macros to make it easier. I copy and paste the info into
excel and each entry is 6 line items using 6 rows and 2 columns. I have to
transpose the info and do text to columns to make it easy.

The info is imported like this

Name
address
city
ss#
Anual Pay


What I would like to do is copy and paste 100 at a time but i need an easy
solution to match headings and create a simple looking excel form.

Any Ideas?

Thanks
Mike