Thread: How to remove space between header and first bullet in Outlook email created by Excel macro
View Single Post
 
Old 03-07-2019, 09:32 PM
kevinbradley57 kevinbradley57 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Jul 2017
Posts: 85
kevinbradley57 is on a distinguished road
Default How to remove space between header and first bullet in Outlook email created by Excel macro
I have an Excel macro that creates an Outlook email. The email body has a Strbody statement that includes variables in two bulleted lists. My problem is that the bulleted lists have a space between the header and the first bulleted item. How can I eliminate that space?

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>" _