Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I get excel to mail merge zip codes plus 4 correctly?
I have tried everything to get an excel spreadsheet that contains customer
addresses to merge with either Word or Publisher and retain the zip code plus 4 on some of the customers. The customers that have a 5 digit zip code come through correctly, but the ones that have the plus 4 zip code come through with a 0 in the zip code fields and nothing else. I have messed with the formatting function within Excel to no avail. I tried creating my own format to no avail. I have been online searching this topic and tried the suggestion of putting the format for the entire column as [<=99999]00000;00000-000. This did not work either. If anyone has a suggestion on how to get the 2 types of zip codes to merge into one document correctly, PLEASE let me know. Thank you! |
#2
|
|||
|
|||
Hi Kathy,
You really want those zip codes as text ALL of them. Then your US zipcodes are all left justified text as they should be and you can include the zipcodes used by any country.. Canadian addresses look practically the same as the US except for zipcodes and you would be able to handle them. as well. I can't tell from your description what you have and what you got the important test is =ISTEXT(F4) Normally if you enter zip codes the zip+4 would be text, and you formatted numbers as 00000 FixUSzip5() corrects US 5-digit zipcodes by conversion to 5 digit numbers as text. http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5 format the column as text before running the macro Mail Merge http://www.mvps.org/dmcritchie/excel/mailmerg.htm BTW, History page source on your website -- &nbspThis year Whoever does the webpage should make a global change &nbsp to: or pehaps to (avoiding the indented paragraph look): and then perhaps change all of to <P which would be easier to read. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kathy at Sauder Feeds" wrote in message ... I have tried everything to get an excel spreadsheet that contains customer addresses to merge with either Word or Publisher and retain the zip code plus 4 on some of the customers. The customers that have a 5 digit zip code come through correctly, but the ones that have the plus 4 zip code come through with a 0 in the zip code fields and nothing else. I have messed with the formatting function within Excel to no avail. I tried creating my own format to no avail. I have been online searching this topic and tried the suggestion of putting the format for the entire column as [<=99999]00000;00000-000. This did not work either. If anyone has a suggestion on how to get the 2 types of zip codes to merge into one document correctly, PLEASE let me know. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to filter on a date field during mail merge | Excel Worksheet Functions | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
Mail merge (Word97) only importing 1st 85 rows of info from Excel | Excel Discussion (Misc queries) | |||
Extract Data for Mail Merge | Excel Discussion (Misc queries) | |||
Mail merge to a chart | Charts and Charting in Excel |