Send email when Condition met?

  • Thread starter Thread starter HotRod
  • Start date Start date
H

HotRod

Is it possible to send an email when a bunch of conditions are met? Can I do
this using some email hyperlink or is it best done in VBA?
 
Just trying to brain storm here. So any thoughts would be great.

The user has an excel workbook that needs the invoice # entered within 90
days. So he wants to test the relevant cells at 60 days and if the invoice #
has not been entered send an email to the relevant party. I'm trying to
determine if it would be best to just have the code run when the workbook is
opened or if it should be tied to the time of day and run at 8am each
morning? If it was tied to the time is there a way to prevent code from
having to run every couple seconds to do a time compare? Is there a better
way to do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro when a condition is met 7
How to Determine When Calculations are Complete 3
Inserting an image 6
skip to next from if 1
Sending An Email 4
Testing Blank Conditional Formatting 1
Returning 1 of 4 values if conditions are met 4
Send e-mail based on condition 1

Back
Top