+ Reply to Thread
Results 1 to 8 of 8

Macro to attached sheet to outlook email

  1. 08-27-2015, 02:27 AM #1
    Rajesh shishodia
    Rajesh shishodia is offline
    Registered User
    Join Date
    05-20-2015
    Location
    India
    MS-Off Ver
    Office 2013
    Posts
    49

    Macro to attached sheet to outlook email

    Hi Team,
    Need your help on this one please.
    I have an excel workbook having 3 worksheets I need a macro which can attach and email particular sheets to the particular person Like sheet1 should go to [email protected], sheet2 should go to [email protected] and sheet3 should go to [email protected] and if sheet not found then skip to next.

    Please find the attached sample

    Regards

    rajesh
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-27-2015, 07:04 AM #2
    Rajesh shishodia
    Rajesh shishodia is offline
    Registered User
    Join Date
    05-20-2015
    Location
    India
    MS-Off Ver
    Office 2013
    Posts
    49

    Re: Macro to attached sheet to outlook email

    Any input?
    Reply With QuoteRegister To Reply
  3. 08-27-2015, 11:54 AM #3
    jaslake
    jaslake is offline
    Forum Expert 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 attached sheet to outlook email

    Hi Rajesh shishodia

    Try this Code
    Please Login or Register  to view this content.
    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
  4. 08-28-2015, 03:48 AM #4
    Rajesh shishodia
    Rajesh shishodia is offline
    Registered User
    Join Date
    05-20-2015
    Location
    India
    MS-Off Ver
    Office 2013
    Posts
    49

    Re: Macro to attached sheet to outlook email

    Hi Jaslake,

    Thanks for your help!

    I am facing one issue while i am trying to change the name of the sheets like sheet1 to Kolte - Patil Mar Esmeralda and sheet2 to Kolte - Patil Raaga and sheet3 to Kolte - Patil Mirabilis this code is not working.Please help!
    Reply With QuoteRegister To Reply
  5. 08-28-2015, 03:56 AM #5
    Rajesh shishodia
    Rajesh shishodia is offline
    Registered User
    Join Date
    05-20-2015
    Location
    India
    MS-Off Ver
    Office 2013
    Posts
    49

    Re: Macro to attached sheet to outlook email

    Please find the attached sample sheet
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 08-28-2015, 09:55 AM #6
    jaslake
    jaslake is offline
    Forum Expert 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 attached sheet to outlook email

    Hi Rajesh shishodia

    This seems to work...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 08-31-2015, 01:50 AM #7
    Rajesh shishodia
    Rajesh shishodia is offline
    Registered User
    Join Date
    05-20-2015
    Location
    India
    MS-Off Ver
    Office 2013
    Posts
    49

    Re: Macro to attached sheet to outlook email

    Hi Jaslake,

    Awesome! This code is working fine! Thanks for your wonderful help!

    My issue is completely resolve

    Regards

    Rajesh
    Reply With QuoteRegister To Reply
  8. 08-31-2015, 10:46 AM #8
    jaslake
    jaslake is offline
    Forum Expert 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 attached sheet to outlook email

    You're welcome...glad I could help.

    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. [SOLVED] Macro to attached sheet to outlook email
    By Rajesh shishodia in forum Outlook Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2015, 11:58 PM
  2. [SOLVED] VBA Email two different ranges to outlook (File and Code Attached)
    By JChesney in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-17-2015, 12:11 PM
  3. macro to send an email with an active excel sheet attached
    By megtoma in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2014, 11:37 PM
  4. Macro codes for sending the one sheet attached through outlook
    By Ram Behera in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2013, 10:42 AM
  5. Macro codes for sending the one sheet attached through outlook
    By Ram Behera in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-27-2013, 10:42 AM
  6. [SOLVED] Excel Macro lotus notes email clear attached sheet
    By johnny_w in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-02-2013, 08:24 AM
  7. Macro to PDF a sheet in workbook and email (outlook) to an email address in a cell
    By paul_sykes00 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-17-2012, 12:54 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1