Macro to send excel spreadsheet

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

 

[Guest]

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.

 

[Paul B]

Steve, have a look at Ron's site here
http://www.rondebruin.nl/sendmail.htm#Tips
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Thanks
--
Steve

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.

 

[Guest]

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