Hi
G Gord Dibben May 1, 2007 #4 Bren Rather short on details here. Do you wish to email the entire workbook as an attachment? Email a range as the body of an email? Email just one sheet? See Ron de Bruin's site for methods and code and/or his Sendmail add-in which gives lots of choice. http://www.rondebruin.nl/sendmail.htm Gord Dibben MS Excel MVP
Bren Rather short on details here. Do you wish to email the entire workbook as an attachment? Email a range as the body of an email? Email just one sheet? See Ron de Bruin's site for methods and code and/or his Sendmail add-in which gives lots of choice. http://www.rondebruin.nl/sendmail.htm Gord Dibben MS Excel MVP