|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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>" _ |
#2
|
||||
|
||||
kevinbradley57: This post is a duplicate of:
https://www.msofficeforums.com/outlo...ore-after.html https://www.msofficeforums.com/excel...ered-list.html https://www.msofficeforums.com/excel...st-bullet.html Kindly desist. Thread closed. You may continue the discussion in your original thread only.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
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 |