Send emails through Outlook from Excel

Quick question if anyone can help. I have a small ebay shop and at the end of the
day when I dispatch I would like to email each of the customers with the consignment
number of their delivery. I have the detail in an excel spreadsheet is there any way
to automate the sending by individual line ?

Perhaps this is what you're looking for...
Mail a row or rows to each person in a range (HTML)

Other email options...
Example Code for sending mail from Excel