Excel VBA Macro: Center Image in Email Body (and Resize)

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 พ.ย. 2024

ความคิดเห็น • 9

  • @picopaco7910
    @picopaco7910 ปีที่แล้ว

    Hi Greg, thanks for this very nice tutorial. I have a question: it is also possible to Crop this image? If yes, how? Thank You

  • @PhillieRodriguez
    @PhillieRodriguez 10 หลายเดือนก่อน

    How can you center the text with the image as well?

  • @rahulkumar-gh5zo
    @rahulkumar-gh5zo ปีที่แล้ว

    in place of "everyone" i want to add name which is in one column of my excel sheet . how can I do it

  • @Noah_Oye
    @Noah_Oye ปีที่แล้ว

    what if I would like to align the image to the right and not the left, how will I achieve that please

    • @greggowaffles
      @greggowaffles  ปีที่แล้ว +1

      Hope this helps:
      .HTMLBody = strbody1 & "

    • @Noah_Oye
      @Noah_Oye ปีที่แล้ว

      @@greggowaffles thank you so much. This was helpful but I just want to move the png to 30px to the right. I don’t want it to move to the extreme end.
      I tried using margin-left but It wasn’t working

  • @barathparthas9385
    @barathparthas9385 2 ปีที่แล้ว

    The code is not working

    • @greggowaffles
      @greggowaffles  ปีที่แล้ว

      did you replace the LT and GT with < and >?

    • @AlabaUmukoro
      @AlabaUmukoro 11 หลายเดือนก่อน

      It worked for me, after setting Outlook as the default email app in Windows Settings. Try it bro, and take care to avoid typos in the code. Cheers