excel macro for sending emails

I have attached an excel sheet which i wanted to write macro as an attachment. .

when I run a macro an email has to be sent to each persons listed in column A
with Voucher # in the subject line and URL in the body of the message
after the URL, the body of the message will remain same for all the emails:
so I have typed the body of the message in 2nd sheet:

can some one please help me i checked some codes in http://www.rondebruin.nl/sendmail.htm
but im not able to make it which code n how to use..

can some help....