Macro to send excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make a macro that will send xls as attachment to an e-mail. I can
make one to open Outlook message, with the attachment but can not find to
populkate "to" box. Any ideas please?
 
Hi Steve, if you do not want to alter the message first then the following
would work:

ActiveWorkbook.SendMail "emailladdress", "Subject text"

You will be presented with a message box which is a bit of a nuisance,
however I dont know of a way round this.
 
Thanks
--
Steve


stumac said:
Hi Steve, if you do not want to alter the message first then the following
would work:

ActiveWorkbook.SendMail "emailladdress", "Subject text"

You will be presented with a message box which is a bit of a nuisance,
however I dont know of a way round this.
Click to expand...
 
Thanks
Never used codes before but copy and paste works - even if I don't
understand it. must try sometime. Ta
 
Back
Top