Macro to send excel spreadsheet

S

Steve

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?
 
S

stumac

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

Steve

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

Steve

Thanks
Never used codes before but copy and paste works - even if I don't
understand it. must try sometime. Ta
 
Top