#1
|
|||
|
|||
Problem with ZIP code serial printing
Hello there,
I am trying to modify my serial printing of adress lables and envelopes in Word. I have search the internet but could not find anything helpful. After pressing Alt+F9 this one appears: {ADRESSBLOCK\f"<<_COMANY_>><<_FIRSTO_>><<_LASTO_>> <<_SUFFIXO_>><<_STREET1_>><<_STREET2_>><<_POSTAL_> ><<_CITY_>><<_COUNTRY_>>"\|1032\c2\e"Ελλαδα"\d} In the internet they wrote to change postal to {MERGEFIELD POSTAL #"00000;;"}. Do I have to set the {} extra? Do I have to leave the _ front and back? My problem printing the ZIP codes for the lables/envelopes correctly is that eg. German ZIPs sometimes start with a 0 or Dutch and British have a combination of letters and numbers. The labeling refers to an Excel file. I created the adresses manualy as well as I tried the block function of word to create adresses but I have the same problem with Germany and Netherlands. Thanks for any ideas. Elisabeth |
#2
|
||||
|
||||
1. Don't use the AddressBlock - insert the individual mergefields where you want them.
2. Don't us a numeric picture switch in the 'postal' mergefield - all that will do is mess up the alpha-numeric post codes. 3. Read Mailmerge Data Format Problems in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Sorry, not helpful.
I have copied the field as in the threat mentioned {QUOTE{SET Zip {MERGEFIELD ZipCode}}{IF{Zip}> 99999 {SET Zip {Zip \# "00000'-'0000"}}}"{=-{=-{Zip}-Zip}/2 \# 00000;;}{=-({Zip}*(-1)-Zip)/2 \# ;-0000;}"} even in my manual list but does not work. It is just showing the inserted code when pushing again F9. My manual list looks like this: {MERGEFIELD"NAME"}{MERGEFIELD"SURNAME"} {MERGEFIELD"STREET"} {MERGEFIELD"COUNTRY_CODE"}{MERGEFIELD"ZIP"}{MERGEF IELD"CITY"} {MERGERFIELD"COUNTRY"} Any other helpful ideas. |
#4
|
||||
|
||||
And where did I say to copy that particular field??? Kindly read what I did post...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
All field code age calculations updating to same value when printing | merato | Word | 0 | 07-10-2019 06:44 AM |
VBA Code for Printing Active worksheet .. | LearnerExcel | Excel Programming | 1 | 02-11-2018 01:37 AM |
Macro Code for Duplex Printing | Leftovercity | Word VBA | 4 | 01-27-2017 10:43 AM |
Writing a VBA code for printing multiple sheets in a workbook | m85miller | Excel Programming | 1 | 02-02-2016 01:41 AM |
Printing Problem!! | JamesJulian86 | Word | 0 | 04-27-2009 12:16 PM |