Send e-mail from Excel

[mot98]

Hi All,

I am pretty sure this is doable....I am looking to setup an automatic e-mail that will get sent out everytime an excel document is saved.

Can someone give me some examples on how to set this up?

Thanks,
mot98


"Victory goes to the player who makes the next-to-last mistake."
- Chessmaster Savielly Grigorievitch Tartakower (1887-1956)

 

[dougcranston]

mot98

The following sites may provide you with solutions or approaches to solving your problem.

VB6 Sample App

http://www.thescarms.com/vbasic/FolderSpy.asp

WSH/VBScript solution

http://home.att.net/~wshvbs/wshFileSystemWatcherPage.htm

WSH/VBScript

http://www.rgagnon.com/wshdetails/wsh-0012.html

Ran across these in some of my recent research.

Hope it helps.

DougCranston

 

[jonscott8]

Personally, rather than use a 2nd process to monitor this, I would just bind to the BeforeSave event within the workbook.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

'Send mail with whatever client you wish
If Not lMailSent Then
Cancel = True
MsgBox "You can't save because the email wasn't sent"
End If
End Sub Jon Hawkins