Send sheet to selected distribution list using VBA
 

Hi All

Looking for some code to use.

I would like: To copy the active sheet, then select a list of names i
excel and send the sheet not not the workbook using outlook.

Any ideas

--
bsnapoo
-----------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...fo&userid=3611
View this thread: http://www.excelforum.com/showthread.php?threadid=56280

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