Automate emailing items on the spreadsheet

Hi all,

I am looking at code that will help me automate the emailing activity.
The requirement is below
* a sheet contains few details of invoices that are on hold.(sheet attached for sample)
*invoices may be on hold for different reason and are identified by hold code
*Different invoices may be on same hold code.
*treatment of each item on the sheet is based on the hold code.
*I need a code that sends emails to listed recepients based on the hold code.
*subject line of the email is standard and is avilable on the spreadsheet
*format of email for each hold code is also avilable on the attached sheet.

Looking forward for your inputs, I use outlook 2007

Regards,
Kiran

AttachmentSize
Raw Data_Holds.xlsx14.39 KB