|
| 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
September 16th, 2004, 04:06 AM
|
|||
|
|||
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
September 16th, 2004, 04:06 AM
|
|||
|
|||
|
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
September 16th, 2004, 04:06 AM
|
|||
|
|||
|
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
September 16th, 2004, 04:06 AM
|
|||
|
|||
|
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 |
Linear Mode
