Serial letter/envelope

[Kuzcomerlin]

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

[macropod]

Mailmerges do not work well with mixed data formats. To a large extent, that is because they are designed to work with databases where only one data format is permitted per field - in cases such as this the postal codes would have to be stored in a text field. With your Excel data source, the simplest solution is to ensure the first few records include data in the alpha-numeric format, so the mailmerge process will interpret it as a text field. You should then be able to do the merges with just:
{MERGEFIELD ZIP}.

See the Mailmerge Data Format Problems topic in the Mailmerge Tips and Tricks 'sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html