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

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 03-07-2019, 09:32 PM
kevinbradley57 kevinbradley57 is offline How to remove space between header and first bullet in Outlook email created by Excel macro Windows 7 64bit How to remove space between header and first bullet in Outlook email created by Excel macro Office 2010 64bit
Advanced Beginner
How to remove space between header and first bullet in Outlook email created by Excel macro
 
Join Date: Jul 2017
Posts: 68
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>" _
  #2  
Old 03-27-2019, 08:39 PM
macropod's Avatar
macropod macropod is offline How to remove space between header and first bullet in Outlook email created by Excel macro Windows 7 64bit How to remove space between header and first bullet in Outlook email created by Excel macro Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Closed Thread

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
How to remove space between header and first bullet in Outlook email created by Excel macro Adjusting Header Space and Counter-adjusting another space setting to ensure identical page content cgp1689 Word 3 10-14-2015 07:34 AM
How to remove space between header and first bullet in Outlook email created by Excel macro Remove bullet bakhtawar12 Word 1 07-01-2014 03:47 AM
How to remove space between header and first bullet in Outlook email created by Excel macro Remove space after table in header melliejane Word 1 03-05-2012 04:09 PM


All times are GMT -7. The time now is 05:21 AM.


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