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