#1
|
|||
|
|||
Remove "space before" of unordered list
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>" _ |
#2
|
||||
|
||||
Am I missing something, but this is an Excel subforum?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
The code is in an Excel macro. Is this not the right place to ask the question?
|
#4
|
||||
|
||||
Duplicate thread closed
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
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 |