HTML Email via VBA with bullets

html vba excel

10,638

You want to use an Ordered List which uses the layout of:

<ol>
  <li>Item 1</li>
  <li>Item 2</li>
  <li>Item 3</li>
</ol>

Where the <ol> tag stands for Ordered List and the <li> tags stand for List Item. The above code produces the following:

Item 1

Item 2

Item 3

Alternatively, if you don't want numbers and just want bullet points you can use an Unordered List which uses the same layout except the <ol> tag changes to <ul>:

<ul>
  <li>Item 1</li>
  <li>Item 2</li>
  <li>Item 3</li>
</ul>

And looks like this:

Item 1

Item 2

Item 3

10,638

Author by

Dames

Updated on July 08, 2022

Comments

Dames almost 2 years
I am struggling to get my HTML formatting correct on an automated email generated through VBA. I have never used HTML before in my life, so this is a totally new thing for me... I have tried to research online already but I just can't make sense of this.
```
.HTMLBody = "<style> body{color:black;font-family:Calibri;font-size: 11pt;}" & "<HTML><body>Dear " & Addressee & ", As you would be aware, the... Please find attached spreadsheet showing: &emsp;&mdash;&emsp;Example list 1. &emsp;&mdash;&emsp;Example list 2. &emsp;&mdash;&emsp;Example list 3. Kindly reply to ALL indicating... Regards, " & Signature
```
The problem with the above is that it doesn't automatically indent the lines if they subsequently move into a second row as I have "created" fake bullets. Also, this code above is terribly basic (reflecting my lack of understanding :/) - but I essentially want to find a way to have a bunch of text, list 3 bullets keeping all the formatting as would be in the case of normal bullets (i.e. indent the lines) and then have a conclusion and normal end of email.

Any chance someone will be able to assist me with the HTML code to have bullets..? I have cleared out a lot of the text in the above code due to confidential information.

Thank you!