How do I create a line spacing macro for Outlook messages?

Toshiba / SATELLITE A215
June 8, 2015 at 09:16:42
Specs: Windows 8.1, Intel Core i5 2.5GHz/6GB
In Outlook 2007, I often receive e-mail responses from people where the line spacing in their message (and in my original e-mail to which they are responding) has been set to Auto, which looks like double-spaced text.

I hate going through the trail of attached e-mails changing the line spacing back to get rid of the extra space, but not doing it means that I must do a lot more scrolling to see what I'm responding to.

I wanted to create a simple macro for changing the line spacing of the selected text, but Outlook has no "macro record" button! So I had to write one. In order to do this, I recorded the same macro in Word, then copied the macro code to a new macro in Outlook. But when I run it, it doesn't work at all. I get an error message: "The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros."

Previously I had a different error. I used the following code:

With Selection.ParagraphFormat
.SpaceBefore = 0
.SpaceBeforeAuto = False
.SpaceAfter = 0
.SpaceAfterAuto = False
.LineSpacingRule = wdLineSpaceSingle
End With

And I had an error that "Selection" was not defined (or something like that).

What do I need to do to get this to work?


See More: How do I create a line spacing macro for Outlook messages?

Report •

June 10, 2015 at 09:18:12
Have you tried changing the macro settings to Enabled?

Report •

June 11, 2015 at 06:19:56
My setting is currently: "Warnings for signed macros; all unsigned macros are disabled." When I had changed this to "Warnings for all macros", it still didn't work (and I received no warning before it ran!).

I think MS Outlook is missing a major category in it's Macro Security settings. Basically, macros created by the user. If I create the thing, they should automatically consider it safe!



Report •

Related Solutions

Ask Question