+ Reply to Thread
Results 1 to 4 of 4

Attach a Single Sheet to Microsoft Outlook Email with a Macro

  1. 12-27-2019, 04:20 PM #1
    wherdzik
    wherdzik is offline
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    546

    Attach a Single Sheet to Microsoft Outlook Email with a Macro

    Is there a way to copy a single sheet to a new sheet. Save it as "Pay Management File" and attach it Microsoft outlook.
    Thanks for your consideration.
    Reply With QuoteRegister To Reply
  2. 12-27-2019, 04:41 PM #2
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Attach a Single Sheet to Microsoft Outlook Email with a Macro

    https://www.rondebruin.nl/win/s1/outlook/amail2.htm
    Reply With QuoteRegister To Reply
  3. 12-27-2019, 04:42 PM #3
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Attach a Single Sheet to Microsoft Outlook Email with a Macro

    Have you checked this simple and effective code on the web: https://www.rondebruin.nl/win/s1/outlook/amail2.htm
    or may be some of other solutions by Ron deBruin - you will find more of them here: https://www.rondebruin.nl/win/section1.htm
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  4. 06-10-2020, 09:56 PM #4
    maniacb
    maniacb is offline
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Attach a Single Sheet to Microsoft Outlook Email with a Macro

    I worked up a working workbook from reviewing Ron deBruin. Let us know if it helps.
    Attached Files Attached Files
    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. Using VBA to attach temp Excel sheet and email with Outlook
    By TBrophy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2015, 04:50 PM
  2. Macros to open new outlook email and attach the excel sheet
    By nageshpolu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2014, 02:26 PM
  3. [SOLVED] Email Macro to attach a non active worksheet to outlook email
    By mickgibbons1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-21-2013, 08:38 PM
  4. [SOLVED] Macro to create a pdf and attach to an email (Outlook)
    By jsedore in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-01-2013, 03:16 PM
  5. Code to attach a sheet as an Outlook email attachment
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-30-2011, 11:32 AM
  6. Attach single sheet to outlook not entire book
    By LiLi1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2010, 09:28 AM
  7. Macro to attach workbook to Outlook email but NOT send
    By kbwilsdon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2009, 06:57 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