Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-30-2013, 08:21 PM
macropod's Avatar
macropod macropod is offline Line spacing after mail merge Windows 7 32bit Line spacing after mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
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

A generalised construction would be:
{MERGEFIELD First_Name} {IF{MERGEFIELD Spouse_First_Name}= "" {MERGEFIELD Last_Name} {IF{MERGEFIELD Spouse_Last_Name}= {MERGEFIELD Last_Name} "and {MERGEFIELD Spouse_First_Name} {MERGEFIELD Last_Name}" {IF{MERGEFIELD Spouse_Last_Name}= "" "and {MERGEFIELD Spouse_First_Name} {MERGEFIELD Last_Name}" "{MERGEFIELD Last_Name} and {MERGEFIELD Spouse_First_Name} {MERGEFIELD Spouse_Last_Name}"}}}
Note: You need to have all of the spaces indicated in the field code.

For a macro to convert field text strings like the above to working field codes, see: http://www.gmayor.com/export_field.htm#TextToField

In your case, you could substitute 'firstname' for 'First_Name' and 'firstname1' for 'Spouse_First_Name', but I'm not sure what 'optional1' and 'optional2' represent, so I can't comment on what you want there or whether they should be substituted for 'Last_Name' and 'Spouse_Last_Name'. As for the paragraph break, you should be able to insert one after each 'and' in the field code and format those and the paragraph break following the field with the attributes you require.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
What does 1.5 line spacing mean? Ugeen Word 7 11-24-2013 04:25 PM
Double Line Spacing in Word 2010 address merge Chevydean Word 1 09-15-2013 11:51 AM
Line spacing after mail merge line spacing ? strato Word 1 02-20-2012 05:48 AM
Line spacing after mail merge Mail merge line break camlad Mail Merge 3 06-29-2011 05:01 PM
Line spacing after mail merge email as pdf attachment - subject line and attachment named after mail merge Nexus Mail Merge 12 04-13-2011 11:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:32 AM.


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