Here is some pseudo code:
ActiveSheet.Copy ' creates new workbook
ActiveWorkbook.SendMail ", Subject:="ABC"
ActiveWorkbook.close SaveChanges:=False
see Ron de Bruin's site for more options:
http://www.rondebruin.nl/sendmail.htm
--
Regards,
Tom Ogilvy
"bsnapool" wrote:
Hi All
Looking for some code to use.
I would like: To copy the active sheet, then select a list of names in
excel and send the sheet not not the workbook using outlook.
Any ideas?
--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...o&userid=36115
View this thread: http://www.excelforum.com/showthread...hreadid=562808