send mail with closing/saving of excel/xlam

S

Steve

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.
 
J

JLGWhiz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top