Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Postal code shows "0" when non-numeric characters present
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Postal code shows "0" when non-numeric characters present
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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Postal code shows "0" when non-numeric characters present
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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Postal code shows "0" when non-numeric characters present
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 |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Postal code shows "0" when non-numeric characters present
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 |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Postal code shows "0" when non-numeric characters present
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 |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Postal code shows "0" when non-numeric characters present
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
postal bar code on labels | Microsoft Word Help | |||
Word 2000 Postal Bar Code | Page Layout | |||
Alt key and numeric pad no longer give me special characters.???? | Microsoft Word Help | |||
Errors in Postal bar code | Mailmerge | |||
Field code # characters (no spaces) FOR SPECIFIC DOC SECTION | Microsoft Word Help |