Creating USPS bar code in mail-merge

PaulW
2StarLounger
Posts: 125
Joined: 17 Feb 2010, 16:25

Creating USPS bar code in mail-merge

Post by PaulW »

I would like to create USPS bar code characters in a word 2013 mail-merge document using the input data (zip+4) which is in an Excel file. Is this doable?

TIA
PaulW
Lost Wages, NV USA
(former Cobol Programmer)

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Creating USPS bar code in mail-merge

Post by Rudi »

Are the codes in formula state in Excel?
What happens if you copy and paste as values and then use this Excel file as the source for a mail merge.
Do the bar codes display?
SC391.jpg
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
HansV
Administrator
Posts: 78540
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Creating USPS bar code in mail-merge

Post by HansV »

Have you looked at Fonts and Encoders Download from the USPS. One of the downloads is uspsEncoderMsOffice-1.3.1.zip, with description
USPS Intelligent Mail barcode Encoder distribution for MS Office 32-bit edition applications such as MS Word, MS Excel and MS Access, running on either 32-bit or 64-bit MS Windows operating systems. The distribution includes procedures and sample templates for performing a Mail Merge operation from MS Excel or MS Access to MS Word.
Best wishes,
Hans

PaulW
2StarLounger
Posts: 125
Joined: 17 Feb 2010, 16:25

Re: Creating USPS bar code in mail-merge

Post by PaulW »

Hans and Rudi,

Thanks for the information. I now think I have enough information to proceed. I had hoped all I needed was to be pointed in the right direction.

Thanks again,
Paul
PaulW
Lost Wages, NV USA
(former Cobol Programmer)