Embed picture in outlook mail body excel vba

by

You need to add the image and hide it. The position 0 will add and hide it.

.Attachments.Add Fname, 1, 0

The 1 is the Outlook Constant olByValue

Once you add the image then you have to use "cid:FILENAME.jpg" as shown below.

Try this

With OutMail
    .To = tName
    .CC = ""
    .BCC = ""
    .Subject = STAT.Range("C1").Value
    .Attachments.Add Fname, 1, 0
    .HTMLBody = "<html><p>Summary of Claim Status.</p>" & _
                "<img src=""cid:Claims.jpg""height=520 width=750>"
    .Display
End With

Screenshot

enter image description here

More Related Contents:

  1. Download attachment from Outlook and Open in Excel
  2. How to do late binding in VBA?
  3. using for loop for vba
  4. Open folder in new instance
  5. Copy data from cell in selected row
  6. Assign code to a button created dynamically
  7. HTML Text with tags to formatted text in an Excel cell
  8. Split comma separated entries to new rows [closed]
  9. Get list of Excel files in a folder using VBA [duplicate]
  10. Assign event handlers to controls on user form created dynamically in VBA
  11. Programmatic Access To Visual Basic Project Is Not Trusted
  12. How to move each emails from inbox to a sub-folder [duplicate]
  13. Conditional Formatting using Excel VBA code
  14. Controlling IE11 “Do you want to Open/Save” dialogue window buttons in VBA
  15. VBA Macro to compare all cells of two Excel files
  16. What does ReDim Preserve do?
  17. How to create a separate CSV file from VBA?
  18. VBA: How to change the value of another cell via a function?
  19. Running VBA from a HYPERLINK()
  20. Range.Find not making a difference between January and November (February and December) in VBA Excel
  21. Switching the FROM Inbox
  22. Excel Select vs Activate
  23. Fast compare method of 2 columns [closed]
  24. Fastest way to check if two ranges are equal in excel vba [duplicate]
  25. Embedding image in email with VBA
  26. How does Excel’s worksheet password protection work
  27. Hiding active workbook programmatically in Excel
  28. Excel VBA Project has generated multiple Workbook objects
  29. How to find a value in an excel column by vba code Cells.Find
  30. How to Send Email When Computer is Locked?

Leave a Comment