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 in excel and send the sheet not not the workbook using outlook.

Any ideas?

Here is some pseudo code:

ActiveSheet.Copy ' creates new workbook
ActiveWorkbook.SendMail Recipient:="[email protected]", 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
>
>