Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-07-2013, 11:39 PM
inwell inwell is offline Mail Merge Windows XP Mail Merge Office 2007
Novice
Mail Merge
 
Join Date: Dec 2013
Posts: 4
inwell is on a distinguished road
Default Mail Merge

Hi,
I was doing mail merge to print labels.(Excel Sheet used). In the template i added <Name> <Address> <City> <Zip> etc. in each separate row.

Now there is one special field called POST (Director,Principal etc) which is not common in every record .

So how do i make it look in order if the next record does not contain post.
<Name>ABCCCCCCC
<Post>Director


<Add>xxxxxxxxxxxxxxx
<City>xxxxxxx
<Zip>xxxxxxxx

now when there is no post present my next label leaves a blank line.How do i make it look without gaps,if few fields are not present in some records...(like this)
ABCCCCC
xxxxxxx
xxxxxxx
xxxxxxxx (4lines instead of 5 no line between)


sorry for lengthy post..

regards
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Duplication of address on merge RICKY Mail Merge 1 09-26-2012 03:14 PM
Mail Merge Can merge be done without mail merge? John H. Power Mail Merge 1 06-05-2012 11:58 AM
Mail Merge Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
Mail Merge From a beginner: Mail Merge using Windows Mail mhalpern705 Mail Merge 3 12-16-2011 04:58 AM
Mail Merge Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM

Other Forums: Access Forums

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