Email macro depending on values in 2 Columns.

Hi, I'm new to using VB and have found this forum a great resource from which to learn so far but unfortunately I have been unable to find a code close enough to edit to suit my needs.

I am running an excel file to keep track of items in stock. When an item comes in it is booked onto the excel sheet. It must leave stock within 2 days. I want to set up a system to alert the person in charge of that item by email so the email will contain their name and the item number.

I have looked into running such a macro automatically but I doubt it would be possible on my system so the excel sheet would likely require a button to run through the items on the sheet and see which items are nearing the 2 day value and email those responsible. The emails for each person are contained on the "Emails" sheet.

I have attached a test document as I cannot upload the actual document but they are essentially the same. I'd appreciate any help on this and thanks in advance!

Dan

Hi pladan

I've used youre test.xls and came up with this:
Try the Send E-mail button and get back to me if it's ok this way or not.