Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does this work now?
I posted a query about sending a mail from Excel (controlling Outlook) and
thanks to a reply I have got it working, but I don't understand why. It seems that the only change I had to make is this line "[ApplicationObjectReference].Session.Logon" - and sure enough when I add this line it all works fine. Does anyone know what this line does? Thanks M |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does this work now?
Hi Michelle
If you see all the examples on my site have this line In Excel 2007 you must add this line (not needed in older versions) If I remember correct you only need it when you mail text in the body of the mail. If you add a attachment it is working without But Why ?? In the 2007 Beta I find this problem and this is the solution and then it is OK for me <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michelle" wrote in message ... I posted a query about sending a mail from Excel (controlling Outlook) and thanks to a reply I have got it working, but I don't understand why. It seems that the only change I had to make is this line "[ApplicationObjectReference].Session.Logon" - and sure enough when I add this line it all works fine. Does anyone know what this line does? Thanks M |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does this work now?
Thanks Ron, I don't know what it does, but it all works now, which is
fantastic. Thanks to everyone who's helped. M "Ron de Bruin" wrote in message ... Hi Michelle If you see all the examples on my site have this line In Excel 2007 you must add this line (not needed in older versions) If I remember correct you only need it when you mail text in the body of the mail. If you add a attachment it is working without But Why ?? In the 2007 Beta I find this problem and this is the solution and then it is OK for me <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michelle" wrote in message ... I posted a query about sending a mail from Excel (controlling Outlook) and thanks to a reply I have got it working, but I don't understand why. It seems that the only change I had to make is this line "[ApplicationObjectReference].Session.Logon" - and sure enough when I add this line it all works fine. Does anyone know what this line does? Thanks M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007 | Excel Programming | |||
If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? | Excel Programming |