HELP! Need help with macro that automatically sends email when...

Hi,

I am putting together a database that will track inventory. I am trying to make a set of macros that will allow my excel workbook to automatically send an email whenever any cell in a specific column (actualy inventory) is less than the respective cell in the column adjacent to it (minimum stock). I copied most of this from examples online. Now the email sending macro works fine, I need help with the trigger macro to automatically send the email when the correct conditions are met (a cell in column C has a value less than a column on the same row in D, eg. c3<d3) So far I am losing sleep and getting nowhere... Please help! Here is what I have so far:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

F

Are you sending an email for each line found with depleted stock? Or one email with all lines of depleted stock?

Okay, just a few details...

1. Are you sending emails via outlook? <------- Should have just looked at your code to realize you're using outlook
2. What column is your actual stock level in?
3. What column is your minimal stock level in?

Try placing this in your workbook module:

Please Login or Register  to view this content.

It should work on any sheet in the workbook as long as the inventory level is always in column C and the minimum quant is always in column D.

Try changing the first sub to this:

Please Login or Register  to view this content.

Good training materials (but probably not samples) can be found here: http://www.excelforum.com/excel-prog...materials.html

Most (but not all) vba programs are fairly specific to their application. But if you read through the training material and ask questions on this forum I bet you can get through it. What you're asking for sounds pretty straight forward.