View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
funperro[_3_] funperro[_3_] is offline
external usenet poster
 
Posts: 1
Default Using Excel / VBA to automatically email forms - how?

Ok. I have figured out how to make it send an email via CDO. It work
great! Now I have another question - I'm a beginner when it comes t
programm VBA, so please bear with me. I don't understand how t
actually have my VB app or macro or whatever you want to call it t
run. Right now, my program will only go through and send out an emai
if I hit alt-F11 and then click run. How do I make this macro run b
itself? Is there a way to make the macro run when closing the file?
How about when opening the file?

Any help is appreciated -
Andre

--
Message posted from http://www.ExcelForum.com