Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2007
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am using Excel 2007 and want to use VB to copy 5 charts from excel to the body of Outlook. Then send the email. I do not want to attach the files!
    Thanks in advance!

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    Quote Originally Posted by flamingoparty View Post
    I am using Excel 2007 and want to use VB to copy 5 charts from excel to the body of Outlook. Then send the email. I do not want to attach the files!
    Have you solved this one? I'm thinking you would might be able to save the charts as images and then insert the images into the HTML message body, but it sounds as though it might be quite a bit of work to code up.

  3. #3
    New Lounger
    Join Date
    Jul 2007
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I actually have switched jobs and do not need this anymore. But, before I left, I found some code that saved it as an html. It still would not copy the charts, but it did copy the data.
    Thanks for replying!

  4. #4
    New Lounger
    Join Date
    Dec 2009
    Location
    Manchester, UK
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    not investigated it fully but there should be a way of getting at the Paste Special options & then embed the thing as an OLE object
    Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •