Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Closed Thread
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-27-2019, 03:43 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 Need VBA for SpaceAfterAuto=False

The following is part of an Excel macro that reports totals from a workbook in the body of an Outlook email as two unordered lists. The logic works, but it adds a space above and below each list. I've narrowed the problem down to the SpaceAfter paragraph formatting of the list items getting set to Auto by default. I need the VBA that sets SpaceAfterAuto=False on just those list items.



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><li>" & intReportsIssued & " audit reports</li>" _
     & "<li>" & intMemoIssued & " memos</li>" _
     & "<li>" & intProjCompleted & " audit support projects</li>" _
     & "</ul>" _
     & "Remaining:" _
     & "<ul><li>" & intReportsRemain & " audit reports</li>" _
     & "<li style=margin-top: -10px; margin-bottom: 0px; >" & intMemoRemain & " memos</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
Formula for Mailmerge sherrin Mail Merge 3 05-10-2019 03:12 PM
Converting a 1 or 0 into TRUE or FALSE? ayupchap Mail Merge 1 04-25-2017 02:45 PM
Embedded SWF - 'Playing' is false after run Cosmo PowerPoint 14 11-03-2013 01:21 AM
False fonts in word peterv Word 5 07-19-2012 02:11 AM
MSWord false pattern or background????? controlengineer Drawing and Graphics 3 04-02-2011 06:14 AM


All times are GMT -7. The time now is 10:04 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