+ Reply to Thread
Results 1 to 3 of 3

Macro To Send Individual sheets To Different Email Address Based On Sheet Name

  1. 01-20-2016, 04:43 PM #1
    markusvirus
    markusvirus is offline
    Forum Contributor
    Join Date
    10-18-2015
    Location
    manila, philippines
    MS-Off Ver
    MS Office 2010
    Posts
    186

    Macro To Send Individual sheets To Different Email Address Based On Sheet Name

    Hi Experts,

    I'm looking for a vba code that I may reference my concern. I have a workbook that has sheets "Manager 1", "Manager 2" and "Manager 3", and I like to use a macro to send them to different recipients, for example: Sheet "Manager 1" should be sent to "manager1@email.com", "Manager 2" to "manager2@email.com" and so on. I've attached my file for your reference.

    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-21-2016, 03:24 PM #2
    markusvirus
    markusvirus is offline
    Forum Contributor
    Join Date
    10-18-2015
    Location
    manila, philippines
    MS-Off Ver
    MS Office 2010
    Posts
    186

    Re: Macro To Send Individual sheets To Different Email Address Based On Sheet Name

    help please...
    Reply With QuoteRegister To Reply
  3. 01-23-2016, 05:29 PM #3
    jaslake
    jaslake is offline
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro To Send Individual sheets To Different Email Address Based On Sheet Name

    Hi markusvirus

    Try this Code in the attached...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to send individual tabs from a worksheet to different email address based on in
    By mikeyexcel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-30-2014, 07:46 PM
  2. Send email to address based on cell value
    By shiftyspina in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2014, 03:06 PM
  3. Send email based on address in a cell
    By behnam in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-19-2013, 02:53 PM
  4. Macro to send individual tabs from a worksheet to different email address based on in
    By Rose3 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-26-2013, 07:45 AM
  5. Send email to address (in cell)l and individual pdf files (in cell)
    By oc2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-19-2012, 06:51 PM
  6. macro to send email.subject,body,email address are in 3 cells
    By lester.ilao in forum Excel General
    Replies: 6
    Last Post: 12-02-2011, 02:14 PM
  7. macro to send excel sheet to specific email address
    By JonnieP in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2005, 06:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1