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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr 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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:34 PM.


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