Hello, I am trying to set up a button in my excel workbook to automatically
send by email to myself when someone completes it. I can set up a macro to
send by email as attachment, but it won't go any further to add my email
address. Is there a way to do this? Would appreciate any help. Thanks!!!

Everything you need to send emails from Excel can be found at Ron de Bruin's
site.

http://www.rondebruin.nl/sendmail.htm

Note the SendMail add-in which makes it all easy without writing your own
code.


Gord Dibben MS Excel MVP

On Mon, 23 Mar 2009 14:38:03 -0700, Chris O
wrote:

Hello, I am trying to set up a button in my excel workbook to automatically
send by email to myself when someone completes it. I can set up a macro to
send by email as attachment, but it won't go any further to add my email
address. Is there a way to do this? Would appreciate any help. Thanks!!!