Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-22-2017, 06:58 AM
paulkaye paulkaye is offline VBA / macro to set paragraph spacing Windows 7 64bit VBA / macro to set paragraph spacing Office 2007
Advanced Beginner
VBA / macro to set paragraph spacing
 
Join Date: Nov 2011
Posts: 84
paulkaye is on a distinguished road
Default VBA / macro to set paragraph spacing


In Outlook 2016 I often want to set paragraph spacing such that "spacing before" is 3 pt. Despite quite a bit of searching I can't seem to find VBA/macro that will do this (or that is close enough for me to successfully modify it).
Any help would be greatly appreciated!
Paul
Reply With Quote
  #2  
Old 01-22-2017, 09:44 PM
gmayor's Avatar
gmayor gmayor is offline VBA / macro to set paragraph spacing Windows 10 VBA / macro to set paragraph spacing Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Do you need a macro for this? The Outlook e-mail editor uses a subset of Word and as such uses paragraph styles - see the Format Tab. Create or modify a style to give you the spacing that you want. Do however note that the recipient may not see it the same way - especially if the recipient uses a different e-mail application.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 01-23-2017, 05:58 AM
paulkaye paulkaye is offline VBA / macro to set paragraph spacing Windows 7 64bit VBA / macro to set paragraph spacing Office 2007
Advanced Beginner
VBA / macro to set paragraph spacing
 
Join Date: Nov 2011
Posts: 84
paulkaye is on a distinguished road
Default

Thank you - you might be correct that all I need is to change the "style" of the text. If I were to do it that way, is there a way to add a command to the Quick Access Toolbar that applies a specific style to the selected text? So far I've found commands that open menus/boxes in which I can select a style. Ideally the QAT button would simply apply a specific style immediately upon being clicked. Possible?
Reply With Quote
  #4  
Old 01-23-2017, 06:15 AM
gmayor's Avatar
gmayor gmayor is offline VBA / macro to set paragraph spacing Windows 10 VBA / macro to set paragraph spacing Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Why re-invent the wheel when Outlook has a style selector on the Format Text tab of the ribbon?
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 01-23-2017, 06:21 AM
paulkaye paulkaye is offline VBA / macro to set paragraph spacing Windows 7 64bit VBA / macro to set paragraph spacing Office 2007
Advanced Beginner
VBA / macro to set paragraph spacing
 
Join Date: Nov 2011
Posts: 84
paulkaye is on a distinguished road
Default

I'm just trying to have a simple keystroke solution. I do it so often...
Reply With Quote
Reply

Tags
paragraph spacing, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default paragraph spacing Billy Hubbs Word 3 03-22-2013 05:33 AM
VBA / macro to set paragraph spacing Paragraph spacing Talullah Word 2 05-01-2012 12:32 PM
VBA / macro to set paragraph spacing Paragraph/line spacing formating help, please! pixleprincess Word 3 01-09-2011 03:04 PM
VBA / macro to set paragraph spacing Maintain paragraph spacing? jake62 Word 2 10-20-2010 04:58 PM
spacing within paragraph psmoore Word 1 06-22-2010 02:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft