emailing from excel
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 |
emailing from excel
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 |
All times are GMT +1. The time now is 07:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com