send excel worksheet 1

[MarcusLCox]

Seen lots of code for emailing excel workbook or file. I want to just mail an individual work sheet. Using Microsoft Outlook cox@bucon.com

 

[DaleWatson123321]

Hi Marcus,

It sounds like you just want the simple method, with would be...

From Excels' menu, click: File - Send To - Mail Recipient

Hope this is what you wanted.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[acron]

To send just the active sheet rather that the workbook use the following code,

Sub MailActiveSheet()    
    ActiveSheet.Copy    
    With ActiveWorkbook        
        .SendMail Recipients:="Recipient"        
        .Saved = True        
        .Close    
    End With
End Sub

replacing "Recipient" with an actual email address.

A.C.

 

[DaleWatson123321]

Thanks, A.C.

I obviously missed the reference to "worksheet".

Your routine is a GOOD one ===> STAR

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca