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

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

"Amy Blankenship" wrote in message
...
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

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

"Doug Robbins - Word MVP" wrote in message
...
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

"Amy Blankenship" wrote in message
...
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

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

--
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

"Amy Blankenship" wrote in message
...
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

"Doug Robbins - Word MVP" wrote in message
...
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

"Amy Blankenship" wrote in message
...
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

Is that a no?

"Doug Robbins - Word MVP" wrote in message
...
I wouldn't use the Address Block. Better to insert the fields that YOU
want in the configuration that YOU want.

--
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

"Amy Blankenship" wrote in message
...
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

"Doug Robbins - Word MVP" wrote in message
...
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

"Amy Blankenship" wrote in message
...
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

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

--

Graham Mayor - Word MVP

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


Amy Blankenship wrote:
Is that a no?

"Doug Robbins - Word MVP" wrote in message
...
I wouldn't use the Address Block. Better to insert the fields that
YOU want in the configuration that YOU want.

--
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

"Amy Blankenship" wrote in
message ...
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

"Doug Robbins - Word MVP" wrote in message
...
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

"Amy Blankenship" wrote in
message ...
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

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

--
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

"Amy Blankenship" wrote in message
...
Is that a no?

"Doug Robbins - Word MVP" wrote in message
...
I wouldn't use the Address Block. Better to insert the fields that YOU
want in the configuration that YOU want.

--
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

"Amy Blankenship" wrote in message
...
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

"Doug Robbins - Word MVP" wrote in message
...
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

"Amy Blankenship" wrote in message
...
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