Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2011, 11:21 AM
camlad camlad is offline Mail merge line break Windows 7 Mail merge line break Office 2010 (Version 14.0)
Novice
Mail merge line break
 
Join Date: Nov 2010
Posts: 6
camlad is on a distinguished road
Default Mail merge line break

How can I introduce a line break (^l) or paragraph mark (^p) in this field if the answer is Yes, ie, there is an Address3



{ IF { MERGFIELD Address3 }<> “”” { MREGEFIELD Address3 } “” }

I cannot find a way of avoiding a blank line if there is a blank field in a record.
Reply With Quote
  #2  
Old 06-28-2011, 03:52 PM
macropod's Avatar
macropod macropod is offline Mail merge line break Windows 7 64bit Mail merge line break Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Hi camlab,

See: http://office.microsoft.com/en-us/wo...005186172.aspx
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-29-2011, 05:16 AM
camlad camlad is offline Mail merge line break Windows 7 Mail merge line break Office 2010 (Version 14.0)
Novice
Mail merge line break
 
Join Date: Nov 2010
Posts: 6
camlad is on a distinguished road
Default

Thanks Paul but I don't see how I can do what I want with that.
What I am after is:
within an 'IF' statement I need to include a paragraph mark if TRUE in order to put the next part of te address on the next line but I dont want a paragraph mark if the field is FALSE (blank).
So, I should like the lines to look something like this:

{ MERGFIELD Address1 }{ IF { MERGFIELD Address2 }<> “” { ^p
MREGEFIELD Address2 } “” }{ IF { MERGFIELD Address3 }<> “” { ^p
MREGEFIELD Address3 } “” }{ IF { MERGFIELD Address4 }<> “” { ^p
MREGEFIELD Address4 } “” }{ IF { MERGFIELD Postcode }<> “” { ^p
MREGEFIELD Postcode } “” }
Reply With Quote
  #4  
Old 06-29-2011, 05:01 PM
macropod's Avatar
macropod macropod is offline Mail merge line break Windows 7 64bit Mail merge line break Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Hi camlab,

With the mergefield switches, you don't need an IF test. The switches simply tell Word what to do if the field is not empty. If you tell it to insert a new line, and place that mergefield on the same line as the one before/after (depending on which switch you use), then the line you're concerned about is only created if the field is not empty.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge line break Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Mail merge line break email as pdf attachment - subject line and attachment named after mail merge Nexus Mail Merge 12 04-13-2011 11:34 PM
paragaph hard break, soft break and ...strange break czomberzdaniela Word 2 12-03-2010 06:58 PM
Mail Merging more than 1 line of data ?? Keith24249 Mail Merge 0 10-16-2009 06:36 AM
Mail merge line break mail merge Anthony Outlook 1 09-29-2009 06:09 PM

Other Forums: Access Forums

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