how to fomat zip codes in Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jz0129 - 30 May 2007 16:19 GMT

I am doing an Excel mail merge and I formatted the zip codes in excel to have
a 0 in front of them. But when I go into Word, it takes away the 0 at the
beginning of the zip code. What do I do?

Reply to this Message

Doug Robbins - Word MVP - 30 May 2007 16:37 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

>I am doing an Excel mail merge and I formatted the zip codes in excel to
>have
> a 0 in front of them. But when I go into Word, it takes away the 0 at the
> beginning of the zip code. What do I do?

Reply to this Message

jz0129 - 30 May 2007 16:55 GMT

OMG, thank you so much !!!!!!! It worked... a little confusing at first but
its OK now

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 5 lines]
> > a 0 in front of them. But when I go into Word, it takes away the 0 at the
> > beginning of the zip code. What do I do?

Reply to this Message

Rate this thread: