emailing from excel

[jabax]

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

 

[Tom Ogilvy]

Look in help at the SendMail command.

--
Regards,
Tom Ogilvy

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

creating financial statements