How to remove space between header and first bullet in Outlook email created by Excel macro

kevinbradley57 · #1 03-07-2019, 09:32 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to remove underscores, except in email address	TomDW	Word VBA	6	09-27-2018 01:15 AM
How do you type an asterix space without OneNote turning it into a bullet?	fhickler	OneNote	0	03-17-2017 08:36 AM
Adjusting Header Space and Counter-adjusting another space setting to ensure identical page content	cgp1689	Word	3	10-14-2015 07:34 AM
Remove bullet	bakhtawar12	Word	1	07-01-2014 03:47 AM
Remove space after table in header	melliejane	Word	1	03-05-2012 04:09 PM