Need VBA for SpaceAfterAuto=False

kevinbradley57 · #1 03-27-2019, 03:43 PM

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>"

macropod · #2 03-27-2019, 08:39 PM

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.

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