| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Daily send copy of Excel Spreadsheet Via Email | Excel Discussion (Misc queries) | |||
| ***** PLEASE HELP **** Send an email from Excel to outlook with an automatic macro | Excel Discussion (Misc queries) | |||
| why can't i send my excel spreadsheet? | Excel Worksheet Functions | |||
| How to Create an Excel Macro to send a meeting request. | Excel Discussion (Misc queries) | |||
| Send Excel 2002 spreadsheet to MacIntosh Excel 2004 | Excel Discussion (Misc queries) | |||
Linear Mode
