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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MSWord false pattern or background?????	controlengineer	Drawing and Graphics	5	11-02-2025 02:54 PM
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