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
Bookmarks