Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2017, 04:17 PM
JennEx JennEx is offline Help Breaking Text Within A Mail merge Field Windows XP Help Breaking Text Within A Mail merge Field Office 2013
Competent Performer
Help Breaking Text Within A Mail merge Field
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default Help Breaking Text Within A Mail merge Field

I'm here again looking for some more help ...

How can I break the text in the highlighted merge field between two line. In all cases it is a word (bantam) followed by the numbers (60' / 40')?

Before:




After:


Here is the mailmerge field code I currently have. The value in the field I seek help with relies on the value of the Reline and Change boxes.

{ if{ MERGEFIELD "r1_relchg" }="" "" { if{ MERGEFIELD "r1_relchg" }="CHG" "{ MERGEFIELD "r1_division" } { MERGEFIELD "r1_base" } / { MERGEFIELD "r1_pitch" }"{ MERGEFIELD "r1_division" } } }
Reply With Quote
  #2  
Old 04-29-2017, 04:52 PM
macropod's Avatar
macropod macropod is offline Help Breaking Text Within A Mail merge Field Windows 7 64bit Help Breaking Text Within A Mail merge Field Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You need only insert a manual line break:
{ if{ MERGEFIELD "r1_relchg" }= "" "" { if{ MERGEFIELD "r1_relchg" }="CHG" "{ MERGEFIELD "r1_division" }↵
{ MERGEFIELD "r1_base" } / { MERGEFIELD "r1_pitch" }"{ MERGEFIELD "r1_division" } } }
where the ↵ is the actual line break.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-29-2017, 05:34 PM
JennEx JennEx is offline Help Breaking Text Within A Mail merge Field Windows XP Help Breaking Text Within A Mail merge Field Office 2013
Competent Performer
Help Breaking Text Within A Mail merge Field
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default That was easy. Thank you.

Wow. That was it? I expect things to be so complicated that I neglect thinking even the basics.

Thank you!
Reply With Quote
  #4  
Old 04-29-2017, 08:30 PM
macropod's Avatar
macropod macropod is offline Help Breaking Text Within A Mail merge Field Windows 7 64bit Help Breaking Text Within A Mail merge Field Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I suggest you look at the final { MERGEFIELD "r1_division" } in your field code, too. It's outside the quoted output, so probably doesn't ever show up - in which case it can be deleted.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help Breaking Text Within A Mail merge Field How do I mail merge records into table columns with more than one merge field? tech123 Mail Merge 1 04-26-2017 07:13 PM
Help Breaking Text Within A Mail merge Field Mail Merge - Age field jay_son Mail Merge 1 06-30-2014 02:33 PM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Help Breaking Text Within A Mail merge Field How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Help Breaking Text Within A Mail merge Field How big can a mail merge field be? Engineer Mail Merge 2 12-11-2012 01:20 AM

Other Forums: Access Forums

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