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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
send mail with closing/saving of excel/xlam
I think most of this was written for xl2003 but it should help you with what
you want to do. Ron pretty much covers the spectrum. http://www.rondebruin.nl/sendmail.htm "Steve" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
send mail with closing/saving of excel/xlam
Hi JLGWhiz
I think most of this was written for xl2003 All mail code examples will work in 97-2007 or 2000-2007 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JLGWhiz" wrote in message ... I think most of this was written for xl2003 but it should help you with what you want to do. Ron pretty much covers the spectrum. http://www.rondebruin.nl/sendmail.htm "Steve" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
send mail with closing/saving of excel/xlam
Thanks for the info, Ron. I wasn't sure how up to date it was, or even if it
needed to be updated, since I have yet to try xl2007. "Ron de Bruin" wrote: Hi JLGWhiz I think most of this was written for xl2003 All mail code examples will work in 97-2007 or 2000-2007 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JLGWhiz" wrote in message ... I think most of this was written for xl2003 but it should help you with what you want to do. Ron pretty much covers the spectrum. http://www.rondebruin.nl/sendmail.htm "Steve" wrote in message ... 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. |
Reply |
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 |