Thread: [Solved] Mail Merge
View Single Post
 
Old 12-07-2013, 11:39 PM
inwell inwell is offline Windows XP Office 2007
Novice
 
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