Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-09-2016, 07:51 AM
Kuzcomerlin Kuzcomerlin is offline Serial letter/envelope Windows XP Serial letter/envelope Office 2007
Novice
Serial letter/envelope
 
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Serial letter/envelope Use L and R arrow to move cursor letter to letter, not top of the line mellowkitten Word 2 05-12-2016 07:23 PM
How to replace a letter to random letter with different color? cikanoz87 Word 7 06-18-2015 09:43 PM
Envelope merge with specially formatted envelope not working. Paul_L Mail Merge 5 05-13-2015 10:27 PM
Serial letter/envelope Serial Number Issue rehan5001 Excel 1 06-08-2011 02:46 AM
Serial letter/envelope Help with Serial No. Macro pikerman Word VBA 3 05-14-2011 03:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft