Sending email using VBA

[richanor]

Hi, I am using a bit of code I found on here to send a selected worksheet by email. Below is a snippet of the code:

    With Dest
        .SaveAs TempFilePath & TempFileName & FileExtStr, _
                FileFormat:=FileFormatNum
        On Error Resume Next
        .SendMail "myemail@domain.com", _
                  "Subject"
        On Error GoTo 0
        .Close SaveChanges:=False
    End With

    Kill TempFilePath & TempFileName & FileExtStr

I wondered if there is any way to tweak the code to add in a second email address, or a cc - as I wanted to sent the sheet to two people at once, but I don't want the user to have to click 'allow' several times. I've tried a few tweaks but none of them have worked - is this possible?

many thanks

Rich

 

[Andrew Poulsom]

You can add more recipients by separating them with a semicolon. You can't cc with SendMail. For that you need Outlook:

http://www.rondebruin.nl/mail/folder2/mail2.htm

 

[richanor]

Hi Andrew

thanks for your reply, and sorry about the delay in responding - I've been away. Your help, as always, is very much appreciated.

Rich