Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Email sheet using a macro

  1. #11
    Board Regular
    Join Date
    Jul 2002
    Location
    India
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Email sheet using a macro

    How can you add multiple recipients to this macro

  2. #12
    New Member
    Join Date
    Nov 2009
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Email sheet using a macro

    Quote Originally Posted by arnoldmiranda View Post
    How can you add multiple recipients to this macro
    Just add 'Array', as shown below.

    Private Sub CommandButton1_Click()

    ActiveWorkbook.SendMail Recipients:= Array ("RECIPIENTS E-MAIL", "An other RECIPIENTS E-MAIL"), Subject:="Goes Here", ReturnReceipt:=True
    MsgBox "Your Request Has Been Sent", , "Title Goes Here"



    End Sub

  3. #13
    New Member
    Join Date
    Sep 2012
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Email sheet using a macro

    Quote Originally Posted by Jonnyk61 View Post
    Just add 'Array', as shown below.

    Private Sub CommandButton1_Click()

    ActiveWorkbook.SendMail Recipients:= Array ("RECIPIENTS E-MAIL", "An other RECIPIENTS E-MAIL"), Subject:="Goes Here", ReturnReceipt:=True
    MsgBox "Your Request Has Been Sent", , "Title Goes Here"



    End Sub
    How it can be work to send a single worksheet

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •