Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Thread Tools
Display Modes


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 10:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft