Look in help at the SendMail command.
--
Regards,
Tom Ogilvy
"jabax" wrote in message
...
hello,
i would like to mail the workbook i work in with the use of a button.
i have attached the folowing code to the button
Application.Dialogs(xlDialogSendMail).Show
this works fine but i would like to add a recipients email address
(which never changes) in the code
thank you very much
yves alexis
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements