+ Reply to Thread
Results 1 to 3 of 3

automatic email of worksheet with graph- graph doesn't show

  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    36

    automatic email of worksheet with graph- graph doesn't show

    Hey everyone,

    I have been working off of some of the Ron de Bruin coding for mailing out a daily report.

    the problem is I tried adapting the coding for a report containing graphs and the graphs don't load in the email body.
    I tried looking at some of the solutions on the Ron de Bruin website but haven't figured one out that works
    please help!


    Here is what I'm currently using
    Please Login or Register  to view this content.
    Thank you

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: automatic email of worksheet with graph- graph doesn't show

    Try something like this...

    Please Login or Register  to view this content.
    It saves Chart(1) as a gif file and inserts the image file in the email's HTMLBody.
    Last edited by AlphaFrog; 06-12-2014 at 07:15 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    01-23-2014
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: automatic email of worksheet with graph- graph doesn't show

    Thanks, this works well, the only problem is that it only grabs the first chart in the sheet
    there are a total of 4 charts,
    How can I add all of these?
    Thanks

+ 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] Creating a line graph over a bar graph to show actual v.s. goal?
    By nscarritt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-03-2014, 03:09 PM
  2. graph that doesn't want to disappear
    By elia_unifi in forum Excel General
    Replies: 2
    Last Post: 11-30-2012, 08:40 AM
  3. Replies: 2
    Last Post: 01-29-2012, 06:50 PM
  4. Replies: 1
    Last Post: 12-19-2005, 04:25 PM
  5. Replies: 0
    Last Post: 12-19-2005, 02:40 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