Send an email with the click of a button in excel 1

[IanStrange]

Hi
I am trying to get a macro that sends an e-mail when the user pushs a button in excel.
Thanks for any help
Ian

No man is an island but 6 tied together make quite a good raft.

 

[SQLBI]

Hi,

Take a look at this FAQ: faq68-4272

Hope this helps.


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[IanStrange]

Perfect thank you very much!!!

No man is an island but 6 tied together make quite a good raft.

 

[Chattin]

Just for info really - a couple of excellent links for sending mail with xl with macros which you can call from a button

http://www.danielklann.com/excel/sending_a_range_as_the_body.htm

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

HTH

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help