Macro that will send a separate email to each recipient in range

Hello there,

I'm looking to put data into a spreadsheet and have it pasted into an email as a table, which will then be sent as a separate email to all the addresses in a range. Can anyone help on this?

Thanks a lot

I used some code from Ron de Bruin to accomplish this for one of my work projects. His url is:
http://www.rondebruin.nl/win/section1.htm