How To Copy A Single Chart To Outlook Using VBA

Поделиться
HTML-код
  • Опубликовано: 7 ноя 2024

Комментарии • 9

  • @jumannenassoro2316
    @jumannenassoro2316 Год назад +1

    I wanted to take a moment to express my sincere gratitude for the incredible video tutorial you created. Your expertise, attention to detail, and clear explanations have made a significant impact on my learning journey.
    Your dedication to sharing knowledge and helping others is truly commendable. The effort and time you invested in creating this tutorial have not gone unnoticed, and I am incredibly grateful for the valuable insights and skills I have gained from watching it.
    Your ability to break down complex concepts into digestible segments and provide practical examples has greatly enhanced my understanding and proficiency in [topic or subject]. Your video tutorial has been an invaluable resource, guiding me through the learning process and inspiring me to explore further.
    Thank you once again for sharing your expertise and passion through your exceptional video tutorial. Your contributions have made a positive difference in my learning experience, and I am truly grateful for the knowledge and inspiration you have provided.
    With heartfelt appreciation

  • @wvince
    @wvince 4 года назад

    Thanks for sharing this, really useful. Is there a way to paste chart image such that the original formatting of the chart is maintained?

  • @aakashmahajan1416
    @aakashmahajan1416 3 года назад

    Hey, this was very useful, but is their any way by which we can insert some text after one chart and past another chart after that and so on.

  • @mohamaddia2752
    @mohamaddia2752 Год назад

    Hey, thanks for this video, but I am encountering the problem where the code runs successfully and prints the body, subject… but I don’t see any chart any reason why, thank you

  • @PedroHernandez-pc7nb
    @PedroHernandez-pc7nb 5 лет назад

    Hey, this was very useful! Thanks. I wanted to ask you if there's a way to copy not one but multiple charts into an email. Also, is there a way to paste the charts into an already existing email?
    I have a macro that already creates the email and the body has strings and excel ranges in it, and I wanted to add some charts in between.
    Thanks in advance

    • @SigmaCoding
      @SigmaCoding  5 лет назад

      Lucky for you, I already have a video covering that topic. Here is the link: ruclips.net/video/tNXHUB9RfrQ/видео.html
      For your second question, there is a way to use an existing email structure. If I was in your position, I would probably just set up a template and then call it from VBA. Here is a general idea of how it would look:
      # Declare the object variable.
      Dim MyTempItem As Outlook.MailItem
      # Create from a template.
      Set MyTempItem = Application.CreateItemFromTemplate("C:\statusrep.oft")
      # Display that template
      MyTempItem.Display
      Let me know if this points you in the right direction.

  • @simonbalcaen2734
    @simonbalcaen2734 2 года назад

    great thanks!

  • @jamesnoz
    @jamesnoz 2 года назад

    Sadly threw user defined error on the first line. :( Dim oLookApp As Outlook.Application newb problems

    • @danielseeger7763
      @danielseeger7763 2 года назад

      maybe you forgot to add the outlook reference?