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