Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 03-06-2019, 04:14 PM
kevinbradley57 kevinbradley57 is offline Remove "space before" of unordered list Windows 7 64bit Remove "space before" of unordered list Office 2010 64bit
Advanced Beginner
Remove "space before" of unordered list
 
Join Date: Jul 2017
Posts: 84
kevinbradley57 is on a distinguished road
Default 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  
Old 03-07-2019, 12:21 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Remove &quot;space before&quot; of unordered list Windows 7 64bit Remove &quot;space before&quot; of unordered list Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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  
Old 03-07-2019, 12:25 AM
kevinbradley57 kevinbradley57 is offline Remove &quot;space before&quot; of unordered list Windows 7 64bit Remove &quot;space before&quot; of unordered list Office 2010 64bit
Advanced Beginner
Remove &quot;space before&quot; of unordered list
 
Join Date: Jul 2017
Posts: 84
kevinbradley57 is on a distinguished road
Default

The code is in an Excel macro. Is this not the right place to ask the question?
  #4  
Old 03-08-2019, 12:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Remove &quot;space before&quot; of unordered list Windows 7 64bit Remove &quot;space before&quot; of unordered list Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove &quot;space before&quot; of unordered list 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
Remove &quot;space before&quot; of unordered list The heading doesn't "obey" the "before" space! why? Jamal NUMAN Word 1 07-06-2011 04:25 AM
Remove &quot;space before&quot; of unordered list How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft