how do you prevent zip code errors in mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

OfficeChic - 19 Mar 2008 20:52 GMT

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 to this Message

Doug Robbins - Word MVP - 20 Mar 2008 03:45 GMT

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

Signature

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

> 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
[quoted text clipped - 4 lines]
> that begin with zero. AND the longer zip codes only show the first digit.
> Does anyone know how to fix this?

Reply to this Message

Rate this thread: