Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-21-2022, 07:49 AM
rgm60527 rgm60527 is offline Making mail merge blank fill a line to highlight that line Windows 10 Making mail merge blank fill a line to highlight that line Office 2021
Novice
Making mail merge blank fill a line to highlight that line
 
Join Date: Feb 2022
Posts: 3
rgm60527 is on a distinguished road
Default Making mail merge blank fill a line to highlight that line


Hi,

I have used Outlook to prepare a phone book for my HOA for years using Outlook's booklet option. It was a convoluted process to get field names and data formated that included PDF save to word, a macro, and some other following around. I am replacing that multistep process with a mail merge and it's working fine... except! I would like to maintain the look and feel from Outlook and the first line of each contact is shaded. I can get the mail merge to shade the first line but only to the point where characters stop. I would like to blank fill the rest of the line. How? The field names are in a one-column/row cell to prevent page splitting.
Attached Images
File Type: jpg 2022-02-21_8-25-25.jpg (142.9 KB, 10 views)
Reply With Quote
  #2  
Old 02-22-2022, 12:23 AM
gmayor's Avatar
gmayor gmayor is offline Making mail merge blank fill a line to highlight that line Windows 10 Making mail merge blank fill a line to highlight that line Office 2019
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

Select the paragraphs you want highlighting and then from the Home Tab > Paragraph Group > Click the down arrow next to Borders and select Borders and Shading. From the Shading Tab, select Apply to Paragraph (the default and what you have been using is Text) and select a suitable light grey fill colour.
__________________
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 02-22-2022, 11:13 AM
rgm60527 rgm60527 is offline Making mail merge blank fill a line to highlight that line Windows 10 Making mail merge blank fill a line to highlight that line Office 2021
Novice
Making mail merge blank fill a line to highlight that line
 
Join Date: Feb 2022
Posts: 3
rgm60527 is on a distinguished road
Default

Thank you. Worked like a charm! My version of Word's paragraph tab did not seem to have the shading option but found an alternative under Design.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making mail merge blank fill a line to highlight that line Red line in a mail merge catflap Mail Merge 5 02-21-2022 09:28 PM
syntax for inserting blank line before inserting table and after a line or paragraph SamDsouza Word VBA 8 08-04-2019 11:10 PM
Making mail merge blank fill a line to highlight that line Mail Merge Go To Next Line widmanak Mail Merge 2 07-20-2017 04:39 PM
Making mail merge blank fill a line to highlight that line Line spacing after mail merge nasica Mail Merge 2 12-02-2013 12:08 PM
Making mail merge blank fill a line to highlight that line Mail merge line break camlad Mail Merge 3 06-29-2011 05:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:33 AM.


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