Results 1 to 21 of 21

Send multiple emails to multiple recipients

Threaded View

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Send multiple emails to multiple recipients

    Hello everyone
    I have a code that send one message to multiple recipients
    Sub Send_Multiple_Emails()
        Dim lastRow         As Long
        Dim I               As Long
        Dim strFolder       As String
        Dim mailObject      As Variant
        Dim outApp          As Variant
    
        strFolder = ThisWorkbook.Path & "\Files\"
        lastRow = Cells(Rows.Count, "A").End(xlUp).Row
    
        For I = 3 To lastRow
            Set mailObject = CreateObject("Outlook.Application")
            Set outApp = mailObject.CreateItem(0)
    
            With outApp
                .Subject = Range("B2").Value
                .Body = Range("C2").Value
                .To = Cells(I, 1).Value
                .Attachments.Add strFolder & Cells(2, 4).Value
                .Send
            End With
        Next I
    
        Set mailObject = Nothing
        Set outApp = Nothing
    
        MsgBox "Done...", 64
    Debugs:
        If Err.Description <> "" Then MsgBox Err.Description
    End Sub
    But I need to send multiple emails as attached and if possible make attachments optional by using check boxes for example

    Thanks advanced for help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 04-17-2015, 06:01 AM
  2. Sending emails to multiple recipients through VBA
    By MikeFranz123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-17-2014, 09:47 AM
  3. [SOLVED] Macro To Send Emails with PDF: Multiple Emails and PDF's
    By totoga12 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-19-2014, 06:13 PM
  4. send email to multiple recipients
    By plans in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-18-2014, 09:26 AM
  5. Macro to send multiple attachments to several recipients
    By dave1983 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2013, 11:07 AM
  6. send email from excel to multiple recipients
    By hariexcel1987 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-13-2013, 01:41 PM
  7. Send email to multiple recipients
    By Court16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2009, 05:20 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1