open workbook - check date - send email

Hi guys,

this is very complicated (for me) and i can't get it right.

Column F is full of product types, column A is full of dates, Columns B and C have numerical values, Column D is full of percentages, column E has email addresses.

so, here's what i need to happen;

Upon opening the workbook, I need to check the dates in column A, if the date is in the past AND column D is NOT at 100%, I need excel to send an email for each row with an expired date to the corresponding email addresses in column E.

Now I think this is the super tricky part - i need the body of the email to state the result of the value of column B minus the value of column C, and the subject to state what is in column F.

Hope someone can help?

This is what i have so far, it works via a button which needs changing to work when the document is opened (i didn't write this code, merely have tried to adapt it to what i need).

Please Login or Register  to view this content.

is this impossible?