Postal code shows "0" when non-numeric characters present

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amy Blankenship - 20 Dec 2005 17:30 GMT

I'm doing a mail merge from an excel spread sheet. When the postal code
contains letters or dashes, or is forced to a text format to allow for a
leading 0, the postal code comes in as 0. I'm sure this didn't happen last
year with mostly the same list, but I had to force the column to format as
text to allow some new addresses whose zip codes began with 0. I think this
is the cause of the problem, but what's the fix?

Thanks;

Amy

Reply to this Message

Doug Robbins - Word MVP - 20 Dec 2005 18:48 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'm doing a mail merge from an excel spread sheet. When the postal code
> contains letters or dashes, or is forced to a text format to allow for a
[quoted text clipped - 6 lines]
>
> Amy

Reply to this Message

Amy Blankenship - 20 Dec 2005 20:38 GMT

Is there a way to apply these instructions to the Address Block that's added
by the insert address block button or the mail merge wizard?

Thanks;

Amy

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 11 lines]
>>
>> Amy

Reply to this Message

Doug Robbins - Word MVP - 20 Dec 2005 21:37 GMT

I wouldn't use the Address Block. Better to insert the fields that YOU want
in the configuration that YOU want.

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

> Is there a way to apply these instructions to the Address Block that's
> added by the insert address block button or the mail merge wizard?
[quoted text clipped - 18 lines]
>>>
>>> Amy

Reply to this Message

Amy Blankenship - 21 Dec 2005 02:10 GMT

Is that a no?

>I wouldn't use the Address Block. Better to insert the fields that YOU
>want in the configuration that YOU want.
[quoted text clipped - 22 lines]
>>>>
>>>> Amy

Reply to this Message

Graham Mayor - 21 Dec 2005 06:38 GMT

It's a no! Using the individual fields is preferable.
However see the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm which page also
explains how to avoid using the Mail merge wizard.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Is that a no?
>
[quoted text clipped - 39 lines]
>>>>>
>>>>> Amy

Reply to this Message

Doug Robbins - Word MVP - 21 Dec 2005 06:46 GMT

As good as. But to be precise "There is no way to apply formatting to the
individual elements of the AddressBlock"

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

> Is that a no?
>
[quoted text clipped - 24 lines]
>>>>>
>>>>> Amy

Reply to this Message