Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2024, 08:46 AM
DarrylBurge DarrylBurge is offline Replace blank field with Carriage Return Windows 10 Replace blank field with Carriage Return Office 2016
Novice
Replace blank field with Carriage Return
 
Join Date: Apr 2024
Location: Nottingham, UK
Posts: 1
DarrylBurge is on a distinguished road
Default Replace blank field with Carriage Return

It is years since I have used MailMerge, so please be patient.

I am making a “Meet the Team” board, and I have a Word document where I am adding 4 records to a page - 4xA5 cards per A4 page.

Some of the fields for some of the records are blank - I am adding Echoism to explain how to say people’s names. How can I add a Carriage Return if the field is blank, allowing me to ensure that each record is set out identically rather than looking like it is “missing” a line.
Reply With Quote
  #2  
Old 04-22-2024, 12:03 AM
gmayor's Avatar
gmayor gmayor is offline Replace blank field with Carriage Return Windows 10 Replace blank field with Carriage Return Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
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

Your question raises a couple of issues. The most obvious is that A5 is half the size of A4, so it is difficult to see how you will get four A5 cards to the A4 page.
Normally when a field is blank, and that field is in a line by itself e.g as in an address block, the missing field simply leaves an empty line i.e. the 'missing line' that you describe. Replacing the field with a paragraph break (what you describe as a carriage return) would give you an extra 'missing line'. How are your fields laid out on the 'cards'?
With four records to a page, you should be thinking in terms of a label merge document.
__________________
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Replace blank field with Carriage Return replace cell text results in extra carriage return abonsey Word VBA 2 05-27-2022 02:55 AM
Replace blank field with Carriage Return Unable to insert line break or carriage return in mail merge field shahid.majeed Mail Merge 4 09-19-2019 01:08 AM
Replace blank field with Carriage Return Find / Replace hard Carriage Return with Line break. GreenBoy Word 2 03-11-2018 02:32 AM
carriage return on PPT yangthomson PowerPoint 0 04-21-2016 07:16 PM
Adding a carriage return at end of each line, and then a blank space, after text entry complete CEMurphy4 Word VBA 1 12-02-2015 11:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:46 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