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. |
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. |
All times are GMT +1. The time now is 10:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com