+ Reply to Thread
Results 1 to 2 of 2

Attach Excel WS to Email

  1. #1
    Registered User
    Join Date
    United States
    MS-Off Ver
    Excel 2007

    Attach Excel WS to Email


    I am using the following code currently:

    Please Login or Register  to view this content.
    Can I add to this so that the worksheet that saves will attach itself to an email? If it means multiple windows opening up that's fine. Just curious to see how this would work.


  2. #2
    Forum Expert Domski's Avatar
    Join Date
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010

    Re: Attach Excel WS to Email

    You can use the SaveCopyAs method to save a distinct copy of the workbook and then email that.

    There are plenty of examples here: http://www.rondebruin.nl/sendmail.htm

    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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