I am using excel and outlook 2010
one workbook is called "Comp" and the data is on "Sheet1"
another workbook called "email" has the email addresses on "Sheet1"

In "Comp" there is an ID# in column O. For example, if one ID# shows up in 4 rows I would like to have the associated values from column A emailed to a particular contact. And that email address can be pulled from the "email" workbook based on that ID#, where ID# is in column A and the email address in column C.

So I need a macro to blast through "Comp" and send off the emails to the contacts.

I am very new to VBA. I tried to do a lot of this myself and got stuck. Can anyone help? If you could be so kind to assist and hopefully I can ge ta working macro while also learning some much needed material.

thanks!