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.

Good question and one I am also interested in.

I use the following in macros to open Outlook but have not been able to
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 a
If/Then (or any other) formula precceding this function within your
macro.


--
AussieExcelUser
------------------------------------------------------------------------
AussieExcelUser's Profile: http://www.excelforum.com/member.php...o&userid=32326
View this thread: http://www.excelforum.com/showthread...hreadid=549210

Good question and one I am also interested in.

I use the following in macros to open Outlook but have not been able to
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 a
If/Then (or any other) formula precceding this function within your
macro.


--
AussieExcelUser
------------------------------------------------------------------------
AussieExcelUser's Profile: http://www.excelforum.com/member.php...o&userid=32326
View this thread: http://www.excelforum.com/showthread...hreadid=549210