+ Reply to Thread
Results 1 to 5 of 5

Macro. compiling email, attaching 1x sheet + 1x powerpoint file.

  1. #1
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    Macro. compiling email, attaching 1x sheet + 1x powerpoint file.

    Hi all
    I'm using a macro to compile an email. I have used this macro before on some other projects but now I need to make some adjustments and I'm struggling a little bit.


    The main adjustments that I'm trying to achieve are:
    1. Instead copying entire sheet and attach it to the email I only want to copy section of it (named range "Charts_breakdown").
    2. I would also like the macro to copy and rename a PDF file (Statistics.ppt - this file will be open before launching any macro). Macro should rename it as per value of "emailRenamePDFattachment", attach it to the email and kill the Statistics.ppt without saving it.

      I have made some notes on the code. Example spreadsheet is attached. It has a macro button ("Compile EMAIL") to launch the current code. There is also a sheet called "Example of attached sheet" that is simulating the outcome of the sheet that should be attached to the email.


    Please Login or Register  to view this content.





    Any help would be extremely helpful.
    Cheers
    Attached Files Attached Files
    Last edited by rain4u; 11-28-2011 at 02:24 PM.

  2. #2
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    Re: Macro. compiling email, attaching 1x sheet + 1x PDF file.

    ***bump***

  3. #3
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    Re: Macro. compiling email, attaching 1x sheet + 1x PDF file.

    ***bump***

  4. #4
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    Re: Macro. compiling email, attaching 1x sheet + 1x PDF file.

    I realized that I made a mistake on my post 1. Just to clarify, the file that I'm trying to attach to the email is powerpoint ppt file not PDF as mistakenly stated. My sincere apologizes.

    I have overcome of the problem with problem 1
    1. Instead copying entire sheet and attach it to the email I only want to copy section of it (named range "Charts_breakdown").
    I created a hidden sheet within my workbook where I pre-sorted the sheet to my liking. I no longer need to attach only a partial section of my spreadsheet as I can attach the entire presorted hidden sheet to the email. (for this task my current code works just fine).

    I would still love some help with problem 2.

    Essentially I have powerpoint file called Statistics.ppt which is open before running any macro. I would like the macro to use this powerpoint file and attach it to the email as well. It should rename it as "Weekly statistics" and then todays date (e.g. Weekly Statistics 28-11-2011).


    Any help would be greatly appreciated.
    Cheers

  5. #5
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    Re: Macro. compiling email, attaching 1x sheet + 1x PDF file.

    ***bump***

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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