Excel help...is this possible, if so how?

[DoubleCheese]

Morning all,

I need to create a Data File for creating a Mail Merge for sending regular mail shots. The customer and address detail comes from our website and sent to us as an email but its formatted in HTML.

Cutting and pasting it directly into Excel gets the data out of HTML format but the data is in all the wrong cells for a Data File ie its not arranged in the correct columns.

So any Excel guru's out there that can instruct me how to get the info off the HTML email and into an excel file or how to gab the info off one excel spreadsheet and automatically populate a Data File?

Thanks.

 

[whitecrook]

this is a job for a simple script using tools like cut, sed, awk, grep, paste, wget, and file redirection.