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.
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 automatically 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 preceeding this function within your macro.
Last edited by AussieExcelUser; 06-06-2006 at 10:03 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks