Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
OfficeChic OfficeChic is offline
external usenet poster
 
Posts: 1
Default how do you prevent zip code errors in mail merge?

Trying to create a mail merge in Word and selected my recipients (an Excel
file). In the Excel file I have several zip codes that begin with zero and
several zip codes that have the additional four digits at the end. When I
select these addresses in the mail merge the zeroes are missing from the ones
that begin with zero. AND the longer zip codes only show the first digit.
Does anyone know how to fix this?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default how do you prevent zip code errors in mail merge?

You need to add a formatting switch to the merge field.

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

"OfficeChic" wrote in message
news
Trying to create a mail merge in Word and selected my recipients (an Excel
file). In the Excel file I have several zip codes that begin with zero
and
several zip codes that have the additional four digits at the end. When I
select these addresses in the mail merge the zeroes are missing from the
ones
that begin with zero. AND the longer zip codes only show the first digit.
Does anyone know how to fix this?



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
SQL errors in mail merge projectmergeleader Mailmerge 10 September 7th 07 04:27 PM
What causes field calculation errors in mail merge? Shelley78 Mailmerge 3 March 16th 06 09:39 AM
Mail Merge errors Hali Cleveland Mailmerge 2 December 12th 05 05:56 PM
How to identify and correct mail merge 'field calculation errors' Janet2357 Mailmerge 0 September 8th 05 07:15 PM
Errors in Postal bar code Tom Hadley Mailmerge 0 January 10th 05 10:13 PM


All times are GMT +1. The time now is 08:11 AM.

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"