+ Reply to Thread
Results 1 to 2 of 2

need to have macro that emails the workbook, adds in subject and body to email

  1. #1
    Registered User
    Join Date
    10-12-2012
    Location
    Philadelphia, Pa
    MS-Off Ver
    Excel 2007
    Posts
    72

    need to have macro that emails the workbook, adds in subject and body to email

    I have a workbook that I want to be able to email to other people. I want it to create the email, attach the workbook and fill in the subject and body of the email. Also need it to attach a pdf file to the email. Thanks for any help.
    Last edited by CityInspector; 10-17-2013 at 02:55 PM.

  2. #2
    Registered User
    Join Date
    10-12-2012
    Location
    Philadelphia, Pa
    MS-Off Ver
    Excel 2007
    Posts
    72

    Re: need to have macro that emails the workbook, adds in subject and body to email

    I have the following and in works perfect. I just cant get it to attach a pdf file to the email as well. Any help?

    Please Login or Register  to view this content.

+ 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. Replies: 0
    Last Post: 09-12-2013, 07:43 AM
  2. Replies: 2
    Last Post: 05-09-2013, 09:56 PM
  3. [SOLVED] Create macro to send worksheet as body of email using cells as subject line
    By LindaABH in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-16-2012, 07:43 PM
  4. Replies: 6
    Last Post: 12-02-2011, 02:14 PM
  5. Standard Email Macro connecting Body to Subject
    By jncswe in forum Outlook Programming / VBA / Macros
    Replies: 5
    Last Post: 02-23-2011, 06:28 PM

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