'.Body & .HTMLBody Indent and Default Signature Issue

I've set up a macro to send an e-mail through Outlook.

.Body is read from a cell inside the file with indents. Since the value will change depending on the usage, I need to reference that cell for the body.

However, there rises 2 issues using .HTMLbody I lose indents which are constructed with CHAR(10) but I keep the default HTML signature.

When using just .BODY indents are displayed are correctly however the default signature is not constructed as HTML and I lose the images.

How should I go about fixing this issue?

My code:

sig = .HTMLBody
body = xlSht.Range("B4").Value
    .To = xlSht.Range("B2").Value
    .CC = ""
    .Subject = xlSht.Range("B1").Value
    .body = body & sig
    .Display

I'd really appreciate your assistance.

Thanks.

excel vba

Solution 1:^[1]

I have figured it out. I included a helper text in the cell and used

.HTMLBODY = Replace(body,"helper","<br>")

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Jeremy Caney

'.Body & .HTMLBody Indent and Default Signature Issue

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]