| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
send mail with closing/saving of excel/xlam
Hi all.
I'm to a point with my macros that I want to send out an email to my colleagues so that they can pull my xlam file from a network source. I've found the sendmail function. ActiveWorkbook.sendmail What I'm interested in doing is setting up a macro that will send an email, upon my closing, or saving the xlam file, for <each time an update of the file occurs. How would I set that up? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 giving annoying "Send/Don't Send" error when closing | Excel Discussion (Misc queries) | |||
| Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
| Problem with .send from microsoft example for vba send mail from excel code | Excel Programming | |||
| Saving Workbook 2007 Format in Send Mail Q | Excel Programming | |||
| Send web mail from Excel (VBA)?? | Excel Programming | |||
Threaded Mode
