View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Send sheet to selected distribution list using VBA

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