VBA coding (1 Viewer)

[kasper5023]

Good Morning everyone,
I have a dilemma that I have come across that I can’t figure out and hoping someone with greater knowledge can assist. I have an access database that has a form that generates an auto email that I need to have changed. I have located the code for the email but figure out how to edit the text to change the font color to a line of text and to do indentions. Below is what I have:
If RequestCategory = "sds" Then
varSubject = "Your Request has been Processed for " & [SiteProductLocation]
VarReport = "RptCompletedSDSEmail"
varBody = "</h5>" & [POCFirst] & " " & [POCLast] & ",</P></h5><br/>" & _
"Please review the attached copy of your request and verify that there are no follow-up actions required. </P></h5><br/>" & _
"The request can also be accessed " & _
"<A href='https://vaww.cmopnational.va.gov/cmop/CEOSH/msds/DASHBOARD/NEW/tool/Lists/Requests/Status%20of%20My%20Request.aspx'> here. </A></SPAN><br/><br/>" & _
"</h5> Please Note:</P></h5><br/>" & _
"Complete Status = No Action Required, Product has been associated per your request.</P></h5><br/>" & _
"Cancelled Status = Additional Information Required, Product SDS could not be located (see attachment for comment). </P></h5><br/>" & _
"</h5>Your feedback is valuable; please complete our <A href=" & _
"'https://vaww.cmopnational.va.gov/cmop/CEOSH/msds/DASHBOARD/NEW/tool/Lists/SDSChemical%20Inventory%20Service%20Customer%20Feedback%20Su/NewForm.aspx?Source=https%3a//vaww.cmopnational.va.gov/cmop/CEOSH/msds/DASHBOARD/NEW/tool/'>survey</A></SPAN>" & _
" that will take less than 1 minute.</P></h5><br/>" & _
"</h5>" & [AssignedTo]

 

[sneuberg]

This seems to be a question about HTML. You might find people with more expertise on that topic in a forum more in line with the subject. Maybe this web site for example.

 

[static]

<p>text formatting

<div style='font-family:arial;font-size:12pt;color:green'>hello</div>
</p>

<p>
indents using list

<ul>
<li>option 1<br>some text here
<li>option 2<br>some text here
<li>option 3<br>some text here
</ul>
</p>

<p>
indents using list without bullets

<ul style='list-style: none'>
<li>option 1<br>some text here
<li>option 2<br>some text here
<li>option 3<br>some text here
</ul>
</p>