Thread: [Solved] Serial letter/envelope
View Single Post
 
Old 06-09-2016, 07:51 AM
Kuzcomerlin Kuzcomerlin is offline Windows XP Office 2007
Novice
 
Join Date: Jun 2016
Posts: 3
Kuzcomerlin is on a distinguished road
Default Serial letter/envelope

Hi to everybody,

I am sitting at work right now and I cannot find any solution to my problem even in Google.

I want to print a serial envelope.

The source is an excel table with adresses of our clients.

I entered in the word envelop at {MERGEFIELD ZIP \#"00000";;}

Checking the adresses the code is obviously correct but I have the problem that our clients come from all over the world. In Germany the Zip has 5 digets starting also with 0 which is covered by the code. In Belgium and The Netherlands there are only 4 digets so the appear on the envelop with a 0 before the 4 digits. The Zip from The Netherland even ends always with two letters. In Russia they even have 6 digets, I have not even yet check if this Zip is displayed correctly.

How can I solve this problem without seperating my excel list or writing some envelopes by hand?

I would be very thankful for any kind of help as I am sitting now since almost 2 hours to find a solution for this problem.

Thanks for any help

Elisabeth
Reply With Quote