Sending e-mail from Vis Basic
I know how to send an e-mail from VB based on results of an excel spreadsheet operation. Is there a way to delay sending the e-mail. I want to use it as a follow-up tool for sales leads.
If all you want it to suspend your code for a few seconds, you could dllimport the old sleep() function. (other ways to stop code excution, but this is easy)
Most of the time it's the programmer that chooses when to send the email.
Could you re-write to simply send later when the user clicks a button to do so?
Maybe even tie in a form_closing event trigger and have it send the email then.
I don't know if you can set a property that says "E-Mail on this Date/Time".
I wonder if this would work for you, create and store the mail in the Drafts, or some other, folder. Then, you can have a process of your own that finds these mails and determines whether to send them.