Your are great! I have switched over to outlook, and other problems but i'll
go to outlook to solve them. I really appreciate all your help.
--
I B Aver


"Excel Ox" wrote:

the macro executes to the .send instruction. When it is executed, i get a
outlook express send-mail window that I have to press send for the message to
be sent.
--
I B Aver


"Ron de Bruin" wrote:

Do you mean that it stay in the outbox ?

See ToolsOptionsSend in Outlook Express

Check : "Send messages immediately"

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Excel Ox" wrote in message ...
Thanks weavtennis. I still get the email page and have to press send.
--
I B Aver


"weavtennis" wrote:


The following works just fine in my '97 version of Excel and V6 OE.


Sub Sendemails()
addy = "
ActiveWorkbook.Sendmail Recipients:=addy
End Sub

There may be more parameters (like email subject and text in the
message) - but I get an email in my OE outbox without pressing more
keys.

If you need to, use "sendkeys" to send "ALT+ENTER" to the OE mail
dialog.


--
weavtennis
------------------------------------------------------------------------
weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
View this thread: http://www.excelforum.com/showthread...hreadid=514057