View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default 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.