+ Reply to Thread
Results 1 to 4 of 4

Macro to attached sheet to outlook email

  1. 08-26-2015, 06:52 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
    Last edited by Rajesh shishodia; 08-26-2015 at 06:56 AM.
    Reply With QuoteRegister To Reply
  2. 08-26-2015, 11:51 PM #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, 08:10 PM #3
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Macro to attached sheet to outlook email

    this site will tell you how to attach sheet to email

    http://www.rondebruin.nl/win/s1/outlook/amail2.htm
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  4. 08-27-2015, 11:58 PM #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 Humdingaling,


    I truly appreciate your wonderful help.This code is working fine.

    Again thanks for your help! i am fully satisfied with this solution.
    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] 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
  2. on clickin submit excel should be attached in outlook & sent to email Id in .xls format
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2014, 04:29 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