Postal Bar Codes in Mail Merge

A

Anonymous

I'm trying to insert a postal bar code field in my mail
merge document. My source data is an Excel spreadsheet
that contains two columns - 1 for the 5 digit ZIP and
another for the +4 data.

Is there any way to insert the postal barcode based on
the two combined merge fields for the 9 digit ZIP?
 
D

Dave Peterson

I'd use a helper column that combines the two:
=a1&if(b1="","","-"&b1)

And if A1 & B1 are numbers (with possible leading 0's):
=TEXT(A1,"00000")&IF(B1="","",TEXT(B1,"-0000"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Postal Bar Codes in Mail Merge Doc 3
How to merge Excel address columns when some zips begin with zeros 4
Leading 0 in Mail Merge document 4
postal bar codes in mail merge labels 7
only 5 digit zip codes 1
mail merge 2
How do I retain a zero as the first number in a postal code? 7
Excel database to mail merge 3

Top