+ Reply to Thread
Results 1 to 2 of 2

Help with Macro to email attachment to multiple recipients

  1. #1
    Registered User
    Join Date
    02-14-2013
    Location
    wales
    MS-Off Ver
    Excel 2010
    Posts
    64

    Help with Macro to email attachment to multiple recipients

    I have a macro that works perfectly fine where it emails the current workbook to multiple recipients. The thing I need help with is that at the moment the email list is hard coded and I would like to be able to pick the address from a cell or group of cell from the worksheet. so the email list can be changed without anyone needing the understanding of VBA and macros. The subject line works fine, I have fixed text followed by data in two different cells but so far I have failed to get the names to work this way. Below is the code. I would appreciate help

    Sub Email()
    Dim RecipVal As Variant
    RecipVal = Array("[email protected]", "[email protected]")
    ThisWorkbook.SendMail Recipients:=RecipVal, _
    Subject:="Email Test -" & Range("A1") & Range("b1")
    End Sub
    Last edited by markharris2004; 06-30-2014 at 02:07 PM. Reason: not in my post list

  2. #2
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: Help with Macro to email attachment to multiple recipients

    If your recipient names are listed in Sheet 1 C3:C7 then use this to compile the names to pass to the e-mail code

    Please Login or Register  to view this content.
    Regards
    Sean

    Please add to my reputation if you think i helped
    (click on the star below the post)
    Mark threads as "Solved" if you have your answer
    (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code:
    [code] Your code here [code]
    Please supply a workbook containing example Data:
    It makes its easier to answer your problem & saves time!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Email multiple recipients with Macro
    By greeneggsandsam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2014, 02:26 PM
  2. send email to multiple recipients
    By plans in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-18-2014, 09:26 AM
  3. [SOLVED] How to send Lotus email with VBA to more recipients and also to more copy recipients
    By Sachy in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-20-2013, 03:23 PM
  4. Macro to send email with multiple attachment
    By excelcheck123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2012, 05:00 PM
  5. [SOLVED] Email multiple recipients
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2009, 09:25 AM

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