Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
ShaniraW
 
Posts: n/a
Default Can I format zip code merge field to add hyphen if zip plus 4?

We have several people who enter addresses, and some put only the five main
digits of the zip code, others put the zip +4 code and include a hyphen,
while the rest use the zip+4 format but don't add the hyphen. Is there a way
I can format the results of this field during the merge to add a hyphen where
needed, remove the hyphen if not needed, etc. In trying one way, it added a
hyphen to all results, including the 5 digit only code. On these, it also
added 4 zeros after the hyphen. Any thoughts on how to fix my problem and
avoid the added problem mentioned?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Can I format zip code merge field to add hyphen if zip plus 4?

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"ShaniraW" wrote in message
news
We have several people who enter addresses, and some put only the five
main
digits of the zip code, others put the zip +4 code and include a hyphen,
while the rest use the zip+4 format but don't add the hyphen. Is there a
way
I can format the results of this field during the merge to add a hyphen
where
needed, remove the hyphen if not needed, etc. In trying one way, it added
a
hyphen to all results, including the 5 digit only code. On these, it also
added 4 zeros after the hyphen. Any thoughts on how to fix my problem and
avoid the added problem mentioned?


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
My zip code format is lost when merging from Excel to Word... Merging Zip Code Errors Microsoft Word Help 12 October 20th 09 09:46 PM
Merge Field with Title Case format issue Craig Mailmerge 2 February 18th 06 08:47 AM
Form Letter Mail Merge using field code: {Database} jyan Mailmerge 8 December 19th 05 10:18 PM
How do I format a merge field to display as $ rounded to 2 decima. Val Mailmerge 1 February 18th 05 10:04 AM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 02:13 PM


All times are GMT +1. The time now is 04:28 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"