![]() |
#3
|
||||
|
||||
![]()
As Outlook uses a subset of Word to edit messages, you can use some Word VBA in Outlook messages, but you have to tell the macro what you are doing. The following will remove the paragraph spacing (attributable to the paragraph formatting) of the selected message:
Code:
Sub ClearParagraphSpacing() 'Graham Mayor - https://www.gmayor.com - Last updated - 05 Dec 2022 Dim olMsg As Outlook.MailItem Dim olInsp As Outlook.Inspector Dim wdDoc As Object Dim oRng As Object On Error Resume Next Select Case Outlook.Application.ActiveWindow.Class Case olInspector Set olMsg = ActiveInspector.currentItem Case olExplorer Set olMsg = Application.ActiveExplorer.Selection.Item(1) End Select On Error GoTo lbl_Exit With olMsg Set olInsp = .GetInspector Set wdDoc = olInsp.WordEditor Set oRng = wdDoc.Range .Display With oRng.ParagraphFormat .SpaceBefore = 0 .SpaceBeforeAuto = False .SpaceAfter = 0 .SpaceAfterAuto = False End With End With lbl_Exit: Set olMsg = Nothing Set olInsp = Nothing Set wdDoc = Nothing Set oRng = Nothing Exit Sub End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need Help with this Macro-Partially Working | rsrasc | Excel Programming | 10 | 09-10-2020 02:38 PM |
Just one macro not working | Ulodesk | Word VBA | 1 | 04-01-2019 09:16 AM |
How to move data - Macro not working | ecarter312 | Excel Programming | 1 | 08-10-2016 11:26 PM |
![]() |
Ulodesk | Word VBA | 1 | 07-18-2012 04:01 PM |
Macro to open template not working | Brandi | Mail Merge | 2 | 06-24-2010 09:29 AM |