Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-29-2017, 04:17 PM
JennEx JennEx is offline Windows XP Office 2013
Competent Performer
 
Join Date: May 2010
Posts: 137
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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
[MS MVP - Word]
Reply With Quote
  #3  
Old 04-29-2017, 05:34 PM
JennEx JennEx is offline Windows XP Office 2013
Competent Performer
 
Join Date: May 2010
Posts: 137
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
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
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
How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
How big can a mail merge field be? Engineer Mail Merge 2 12-11-2012 01:20 AM


All times are GMT -7. The time now is 07:10 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft