Macro to send excel spreadsheet
Thanks
--
Steve
"stumac" wrote:
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.
"Steve" wrote:
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?
--
Steve
|