If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
From fellow MVP Graham Mayor:
US Zip Codes Five digit zip codes are reported as dropping the leading zero when merging from Excel/Access data files. A simple numeric switch should fix that one Formatting problem: the zip codes in my data source are 5-digit or 9-digit. What I'd like to do is apply a number format that will convert all ZIP codes to ZIP + four format, i.e. 12345 becomes 12345-0000, 123450000 becomes 12345-0000 and 123456789 becomes 12345-6789 This requires the use of a conditional field which tests whether the field has five or nine digits then applies appropriate formats. -- Greg Maxey A peer in "peer to peer" support Rockledge, FL To e-mail, edit out the "w...spam" in TBBPMGE wrote: Running into a problem I never experienced previously. When I perform a mail merge using an Excel address database as a source, Zip Codes that begin with "0" come through without the lead "0". Example: Excel cell formatted as a zip code "01234" is merged and displayed on mailing labels in Word as "1234". |
#12
|
|||
|
|||
From fellow MVP Graham Mayor:
US Zip Codes Five digit zip codes are reported as dropping the leading zero when merging from Excel/Access data files. A simple numeric switch should fix that one Formatting problem: the zip codes in my data source are 5-digit or 9-digit. What I'd like to do is apply a number format that will convert all ZIP codes to ZIP + four format, i.e. 12345 becomes 12345-0000, 123450000 becomes 12345-0000 and 123456789 becomes 12345-6789 This requires the use of a conditional field which tests whether the field has five or nine digits then applies appropriate formats. -- Greg Maxey A peer in "peer to peer" support Rockledge, FL To e-mail, edit out the "w...spam" in TBBPMGE wrote: Running into a problem I never experienced previously. When I perform a mail merge using an Excel address database as a source, Zip Codes that begin with "0" come through without the lead "0". Example: Excel cell formatted as a zip code "01234" is merged and displayed on mailing labels in Word as "1234". |
#13
|
|||
|
|||
From fellow MVP Graham Mayor:
US Zip Codes Five digit zip codes are reported as dropping the leading zero when merging from Excel/Access data files. A simple numeric switch should fix that one Formatting problem: the zip codes in my data source are 5-digit or 9-digit. What I'd like to do is apply a number format that will convert all ZIP codes to ZIP + four format, i.e. 12345 becomes 12345-0000, 123450000 becomes 12345-0000 and 123456789 becomes 12345-6789 This requires the use of a conditional field which tests whether the field has five or nine digits then applies appropriate formats. -- Greg Maxey A peer in "peer to peer" support Rockledge, FL To e-mail, edit out the "w...spam" in TBBPMGE wrote: Running into a problem I never experienced previously. When I perform a mail merge using an Excel address database as a source, Zip Codes that begin with "0" come through without the lead "0". Example: Excel cell formatted as a zip code "01234" is merged and displayed on mailing labels in Word as "1234". |
#14
|
|||
|
|||
From fellow MVP Graham Mayor:
US Zip Codes Five digit zip codes are reported as dropping the leading zero when merging from Excel/Access data files. A simple numeric switch should fix that one Formatting problem: the zip codes in my data source are 5-digit or 9-digit. What I'd like to do is apply a number format that will convert all ZIP codes to ZIP + four format, i.e. 12345 becomes 12345-0000, 123450000 becomes 12345-0000 and 123456789 becomes 12345-6789 This requires the use of a conditional field which tests whether the field has five or nine digits then applies appropriate formats. -- Greg Maxey A peer in "peer to peer" support Rockledge, FL To e-mail, edit out the "w...spam" in TBBPMGE wrote: Running into a problem I never experienced previously. When I perform a mail merge using an Excel address database as a source, Zip Codes that begin with "0" come through without the lead "0". Example: Excel cell formatted as a zip code "01234" is merged and displayed on mailing labels in Word as "1234". |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I am doing a mail merge and only the regular 5 digit zip codes ap. | Leppy | Mailmerge | 1 | August 26th, 2004 05:16 PM |
Word Mail Merge and Zip Codes | Dave | General Discussions | 1 | June 11th, 2004 07:01 PM |
merge field codes in frames/textboxes? | Chip Orange | Mailmerge | 1 | May 24th, 2004 04:53 PM |
Merge to Fax with SBS/Exchange? | Tom | Mailmerge | 3 | May 18th, 2004 11:22 PM |
Find and Replace Merge Codes | SandyE | Mailmerge | 0 | May 15th, 2004 09:53 PM |