Macro to send excel spreadsheet
 

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

Macro to send excel spreadsheet
 

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

Macro to send excel spreadsheet
 

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

"Steve" wrote in message
...
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

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

Macro to send excel spreadsheet
 

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


"Paul B" wrote:

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

"Steve" wrote in message
...
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