Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sending outlook mail
i'm trying to send a message based on some worksheet
circumstance, and the only way that i've found to do this, is to use the activeworksheet.followhyperlink ("mailto: ..."), application.sendkeys "%s" method. i wanted to use the sendmail method, but it sends the whole worksheet, which i dont want it to do. regardless, the followhyperlink method seems to be working fine, except that, on the initial run (when outlook and excel of just been started), the delay of the overhead of this action seems to be beyond the acceptable scope, and so messages that are supposed to be sent simply get created, but not sent. is there any way to get around this? thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sending outlook mail
See my webpage for some code examples Bilal
http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "bilal" wrote in message ... i'm trying to send a message based on some worksheet circumstance, and the only way that i've found to do this, is to use the activeworksheet.followhyperlink ("mailto: ..."), application.sendkeys "%s" method. i wanted to use the sendmail method, but it sends the whole worksheet, which i dont want it to do. regardless, the followhyperlink method seems to be working fine, except that, on the initial run (when outlook and excel of just been started), the delay of the overhead of this action seems to be beyond the acceptable scope, and so messages that are supposed to be sent simply get created, but not sent. is there any way to get around this? thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending a Mail from outlook with body coming from excel file | Excel Discussion (Misc queries) | |||
Sending Excel through Outlook | Excel Discussion (Misc queries) | |||
Sending notifications through outlook | Excel Discussion (Misc queries) | |||
General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) | |||
How to make Microsoft Outlook default e-mail when sending excell . | Excel Discussion (Misc queries) |