Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Closed Thread
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-07-2019, 09:32 PM
kevinbradley57 kevinbradley57 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,390
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:
http://www.msofficeforums.com/outloo...ore-after.html
http://www.msofficeforums.com/excel-...ered-list.html
http://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
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


All times are GMT -7. The time now is 10:44 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft