Remove "space before" of unordered list

kevinbradley57 · #1 03-06-2019, 04:14 PM

The following code creates a string in an Outlook email composed of two bulleted lists with variables. Unfortunately, it applies Outlook's default paragraph formatting of "Auto" for the Before and After spacing, resulting in space between the header ("Completed" and "Remaining") and the subsequent bullet item. I need to remove that space. Any suggestions?

Code:

StrBody = StrBody & "<body style='font-family:Tahoma;font-size:12;line-height:1; margin-bottom:0; margin-top:0;'>" _
     & "<br>Current Period Highlights (through approximately " & dtCurrQtrEnd & "):" _
     & "<br>Completed:" _
     & "<ul style=margin-top:-30px><li>" & intReportsIssued & " audit reports</li>" _
     & "<li style=margin-top: 0px; margin-bottom: 0px; >" & intMemoIssued & " validation memos</li>" _
     & "<li>" & intProjCompleted & " audit support projects</li>" _
     & "</ul>" _
     & "Remaining:" _
     & "<ul><li>" & intReportsRemain & " audit reports</li>" _
     & "<li>" & intProjRemain & " audit support projects</li>" _
     & "</ul><br>" _

Pecoflyer · #2 03-07-2019, 12:21 AM

Am I missing something, but this is an Excel subforum?

kevinbradley57 · #3 03-07-2019, 12:25 AM

The code is in an Excel macro. Is this not the right place to ask the question?

Pecoflyer · #4 03-08-2019, 12:27 AM

Duplicate thread closed

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
space bar "deletes" as it "spaces"	S.R.C.	Word	2	04-19-2015 05:56 AM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas	jocke321	Word VBA	2	12-10-2014 11:27 AM
Wierd symbols inplace of "space", "indentation" etc	aka.bhagvanji	Word	5	02-16-2012 11:50 AM
The heading doesn't "obey" the "before" space! why?	Jamal NUMAN	Word	1	07-06-2011 04:25 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM