Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jack Jack is offline
external usenet poster
 
Posts: 83
Default how do you get zip+4 to work with Word Mail Merge Address block

I'm trying to create labels with zip+4 but it comes accross as 0 when ever i
have a zip code with the +4

60046 - shows as 60046
60046-6756 shows as 0


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default how do you get zip+4 to work with Word Mail Merge Address block

Don't use the addressblock field - use the individual fields that make up
the address.

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word
2007 it is Office Button Word Options Advanced General Confirm file
format conversion on open). Then when you attach the data source to the mail
merge main document, you will be given the option of using the DDE method of
connection which should read the data as you have it formatted in the table.

See also the section on zip codes at
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"Jack" wrote in message
...
I'm trying to create labels with zip+4 but it comes accross as 0 when ever
i
have a zip code with the +4

60046 - shows as 60046
60046-6756 shows as 0




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Address Block Debbie Mailmerge 2 July 15th 09 01:37 PM
Word 2007 Mail merge - omit blank lines & address block Piers Alington Mailmerge 7 April 29th 09 07:36 AM
Address block problem in mail merge labels SteveH Page Layout 1 July 25th 08 09:34 PM
Word 2003 mail merge address block inconsistency S trainer Mailmerge 2 February 18th 06 07:32 AM
Mail Merge Address Block Missing Address 3 Joe Champagne Mailmerge 3 September 23rd 05 06:09 PM


All times are GMT +1. The time now is 06:01 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"