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
 



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 09:47 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