Mail Merge drops leading zeros from Access text field zips?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LisaLynnGuy - 25 Aug 2005 14:19 GMT

Access 2003 is my data source. Postal codes are set up as text fields.
Postal codes include U.S. and Canadian codes. Mail Merge in Word 2003 drops
leading zeros. What can I do to fix this without editing individual
addresses every mailing?

Reply to this Message

Doug Robbins - 25 Aug 2005 18:59 GMT

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

> Access 2003 is my data source. Postal codes are set up as text fields.
> Postal codes include U.S. and Canadian codes. Mail Merge in Word 2003
> drops
> leading zeros. What can I do to fix this without editing individual
> addresses every mailing?

Reply to this Message

Rate this thread: