sending outlook mail

[bilal]

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.

 

[Ron de Bruin]

See my webpage for some code examples Bilal
http://www.rondebruin.nl/sendmail.htm