emailing from excel

  • Thread starter Thread starter jabax
  • Start date Start date
J

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
 
Look in help at the SendMail command.

--
Regards,
Tom Ogilvy

jabax said:
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


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top