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