+ Reply to Thread
Results 1 to 1 of 1

Using VBA to attach temp Excel sheet and email with Outlook

  1. #1
    Registered User
    Join Date
    06-17-2015
    Location
    Orange County, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Exclamation Using VBA to attach temp Excel sheet and email with Outlook

    Hi all,

    I've been using the VBA found on www.rondebruin.nl and it has been really helpful but I'm trying to combine a couple of the code segments without success. My goal is to email everyone on the "Email_List" tab with an attached Excel sheet called "Bed Board". I've been able to get the emails to work and I can get the sheet to show as a visible temp file but I can't seem to get the sheet attached to the emails for everyone listed on the "Email_List" tab.

    Here is the code I'm working with:

    '"Email" Button
    Please Login or Register  to view this content.
    I've attached the Excel file I'm working with as well.
    Any help offered is appreciated! Thanks!
    Attached Files Attached Files
    Last edited by Leith Ross; 06-17-2015 at 07:07 PM. Reason: Added Code Tags

+ 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] VBA to Convert Excel sheet to PDF and attach in Outlook
    By lorber123 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-09-2014, 09:53 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. 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
  5. Automatically attach Excel spreadsheet to Outlook Email with Macro?
    By nbaj2k in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-01-2006, 11:45 AM

Tags for this Thread

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