Send e-mail with Excel
Posted by Daniel on August 27, 2001 2:34 PM
In the Tip 16, I found the way to send a sheet by mail :
Application.Dialogs(xlDialogSendMail).Show arg1:="firstname.lastname@example.org", arg2:="Essai"
Everything is ok, but I don't know the way to finally send the mail with no action of the user. The macro prepares the message correctly, but Outlook Express stays waiting for a click on the "Send" button. Is it possible to add a command that automatically clicks on "Send" ? I tried to add :
but nothing happens.
Thank you for your help.