Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-09-2015, 05:43 PM
macropod's Avatar
macropod macropod is offline Elegant / better solution to mail merge file cover problem Windows 7 64bit Elegant / better solution to mail merge file cover problem Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,514
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

For the first problem, the simple solution is to merge the cells containing the address into a single cell. Then, assuming address fields 2-4 may or may not have data, you'd put them all on a single line with address field 1, thus:
«Address_Line_1»«Address_Line_2»«Address_Line_3»«A ddress_Line_4»↵
«Address_Line_5» «Postcode»
where ↵ is a manual line break to keep «Address_Line_5» «Postcode» on a separate line. Then for each of address fields 2-4, you'd use the mergefield \b switch to conditionally output line breaks when those fields have data. To do that
• select a given mergefield (e.g. «Address_Line_2») and press Shift-F9 to expose the field code, which will look like:
{MERGEFIELD Address_Line_2}
• edit the field code so that you get:
{MERGEFIELD Address_Line_2 \b "↵
"}
where ↵ is a manual line break.
That's all there is to it. Now, when you merge, only the lines with data will be output.

As for the second problem, you only need to switch off the 'fit text' and 'wrap text' options, which you've added to some cells. You also need to delete the extra paragraph marks from those cells and give the rows concerned an 'Exact' height setting, rather than the present 'At Least' setting.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook mail merge w/attach and cover page COGICPENNY Outlook 0 01-08-2013 01:41 PM
Elegant / better solution to mail merge file cover problem Mail Merge Problem Hook Mail Merge 2 01-11-2012 09:36 AM
Elegant / better solution to mail merge file cover problem Cover page problem bluegum87 Word 2 08-02-2011 09:43 AM
Mail Merge Problem JohnRG Mail Merge 0 11-02-2009 02:50 AM
problem in Mail merge rjagathe Mail Merge 0 08-12-2009 08:25 AM

Other Forums: Access Forums

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