Generating an automatic email?

E

EMAIL QUESTION

Can I create an If/Then function such that if the formula is true an email
with a copy of the spreadsheet will automatically be sent to a specified
email address?

Any other suggestions on how to accomplish this sort of task would be
appreciated.
 
A

AussieExcelUser

Good question and one I am also interested in.

I use the following in macros to open Outlook but have not been able t
figure out how to automaticcaly send to a specified address:

Application.Dialogs(xlDialogSendMail).Show

You should be able to make this work depending upon a set result from
If/Then (or any other) formula precceding this function within you
macro
 
A

AussieExcelUser

Good question and one I am also interested in.

I use the following in macros to open Outlook but have not been able t
figure out how to automaticcaly send to a specified address:

Application.Dialogs(xlDialogSendMail).Show

You should be able to make this work depending upon a set result from
If/Then (or any other) formula precceding this function within you
macro
 
Top