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 addres
(which never changes) in the code

thank you very much

yves alexi

-----------------------------------------------
~~ 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

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