Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-20-2020, 05:20 AM
Kuzcomerlin Kuzcomerlin is offline Problem with ZIP code serial printing Windows XP Problem with ZIP code serial printing Office 2007
Novice
Problem with ZIP code serial printing
 
Join Date: Jun 2016
Posts: 3
Kuzcomerlin is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 01-20-2020, 02:12 PM
macropod's Avatar
macropod macropod is offline Problem with ZIP code serial printing Windows 7 64bit Problem with ZIP code serial printing Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,902
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 01-22-2020, 07:13 AM
Kuzcomerlin Kuzcomerlin is offline Problem with ZIP code serial printing Windows XP Problem with ZIP code serial printing Office 2007
Novice
Problem with ZIP code serial printing
 
Join Date: Jun 2016
Posts: 3
Kuzcomerlin is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 01-22-2020, 02:12 PM
macropod's Avatar
macropod macropod is offline Problem with ZIP code serial printing Windows 7 64bit Problem with ZIP code serial printing Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,902
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

Quote:
Originally Posted by Kuzcomerlin View Post
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;}"}
And where did I say to copy that particular field??? Kindly read what I did post...
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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
Problem with ZIP code serial printing Macro Code for Duplex Printing Leftovercity Word VBA 4 01-27-2017 10:43 AM
Problem with ZIP code serial printing 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


All times are GMT -7. The time now is 10:21 AM.


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