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 |
#1
|
|||
|
|||
Mailmerge zip code problem
9-digit zip codes merge as single zero (while 5-digit codes merge
successfully). I've tried formatting field to text, even reducing original 9-digit codes to 5 digits, but nothing seems to work. |
#2
|
|||
|
|||
See the relevant section at http://www.gmayor.com/formatting_word_fields.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SamFortMyers wrote: 9-digit zip codes merge as single zero (while 5-digit codes merge successfully). I've tried formatting field to text, even reducing original 9-digit codes to 5 digits, but nothing seems to work. |
#3
|
|||
|
|||
See the relevant section at http://www.gmayor.com/formatting_word_fields.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SamFortMyers wrote: 9-digit zip codes merge as single zero (while 5-digit codes merge successfully). I've tried formatting field to text, even reducing original 9-digit codes to 5 digits, but nothing seems to work. |
#4
|
|||
|
|||
I'm having the exact same problem. I went to this web
site, but have no idea what the information means or is telling me to do. I have worked with mail merges for years but have never had to customize anything like this. Why doesn't word just bring the right numbers over as it has always done in the past? -----Original Message----- See the relevant section at http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SamFortMyers wrote: 9-digit zip codes merge as single zero (while 5-digit codes merge successfully). I've tried formatting field to text, even reducing original 9-digit codes to 5 digits, but nothing seems to work. . |
#5
|
|||
|
|||
I'm having the exact same problem. I went to this web
site, but have no idea what the information means or is telling me to do. I have worked with mail merges for years but have never had to customize anything like this. Why doesn't word just bring the right numbers over as it has always done in the past? -----Original Message----- See the relevant section at http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SamFortMyers wrote: 9-digit zip codes merge as single zero (while 5-digit codes merge successfully). I've tried formatting field to text, even reducing original 9-digit codes to 5 digits, but nothing seems to work. . |
#6
|
|||
|
|||
This is the relevant part of the site. You must toggle on the field codes
(Alt+F9) and add a formatting switch to force the display into the required format. 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 { MERGEFIELD Zip \# "00000" } 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. { IF { MERGEFIELD Zip } "99999" "{ MERGEFIELD Zip \# "00000'-'0000" }" "{ MERGEFIELD Zip \# "00000" }-0000" } Zip = 12345 12345-0000 Zip = 123456789 12345-6789 -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Carole" wrote in message ... I'm having the exact same problem. I went to this web site, but have no idea what the information means or is telling me to do. I have worked with mail merges for years but have never had to customize anything like this. Why doesn't word just bring the right numbers over as it has always done in the past? -----Original Message----- See the relevant section at http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SamFortMyers wrote: 9-digit zip codes merge as single zero (while 5-digit codes merge successfully). I've tried formatting field to text, even reducing original 9-digit codes to 5 digits, but nothing seems to work. . |
#7
|
|||
|
|||
This is the relevant part of the site. You must toggle on the field codes
(Alt+F9) and add a formatting switch to force the display into the required format. 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 { MERGEFIELD Zip \# "00000" } 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. { IF { MERGEFIELD Zip } "99999" "{ MERGEFIELD Zip \# "00000'-'0000" }" "{ MERGEFIELD Zip \# "00000" }-0000" } Zip = 12345 12345-0000 Zip = 123456789 12345-6789 -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Carole" wrote in message ... I'm having the exact same problem. I went to this web site, but have no idea what the information means or is telling me to do. I have worked with mail merges for years but have never had to customize anything like this. Why doesn't word just bring the right numbers over as it has always done in the past? -----Original Message----- See the relevant section at http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SamFortMyers wrote: 9-digit zip codes merge as single zero (while 5-digit codes merge successfully). I've tried formatting field to text, even reducing original 9-digit codes to 5 digits, but nothing seems to work. . |
#8
|
|||
|
|||
I will give this a try. With some files, though, Word is
changing the zero-leading zips -- as well as all nine- digit codes -- to "0" only (not simply dropping the leading "0"). I'm not sure that this is the same issue. Either way, my bigger question is why is this now necessary? I've never had to customize merge fields before. Isn't there a way just to tell Word to bring in the data exactly as it appears in Excel? -----Original Message----- This is the relevant part of the site. You must toggle on the field codes (Alt+F9) and add a formatting switch to force the display into the required format. 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 { MERGEFIELD Zip \# "00000" } 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. { IF { MERGEFIELD Zip } "99999" "{ MERGEFIELD Zip \# "00000'-'0000" }" "{ MERGEFIELD Zip \# "00000" }-0000" } Zip = 12345 12345-0000 Zip = 123456789 12345-6789 -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Carole" wrote in message ... I'm having the exact same problem. I went to this web site, but have no idea what the information means or is telling me to do. I have worked with mail merges for years but have never had to customize anything like this. Why doesn't word just bring the right numbers over as it has always done in the past? -----Original Message----- See the relevant section at http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SamFortMyers wrote: 9-digit zip codes merge as single zero (while 5-digit codes merge successfully). I've tried formatting field to text, even reducing original 9-digit codes to 5 digits, but nothing seems to work. . . |
#9
|
|||
|
|||
I will give this a try. With some files, though, Word is
changing the zero-leading zips -- as well as all nine- digit codes -- to "0" only (not simply dropping the leading "0"). I'm not sure that this is the same issue. Either way, my bigger question is why is this now necessary? I've never had to customize merge fields before. Isn't there a way just to tell Word to bring in the data exactly as it appears in Excel? -----Original Message----- This is the relevant part of the site. You must toggle on the field codes (Alt+F9) and add a formatting switch to force the display into the required format. 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 { MERGEFIELD Zip \# "00000" } 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. { IF { MERGEFIELD Zip } "99999" "{ MERGEFIELD Zip \# "00000'-'0000" }" "{ MERGEFIELD Zip \# "00000" }-0000" } Zip = 12345 12345-0000 Zip = 123456789 12345-6789 -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Carole" wrote in message ... I'm having the exact same problem. I went to this web site, but have no idea what the information means or is telling me to do. I have worked with mail merges for years but have never had to customize anything like this. Why doesn't word just bring the right numbers over as it has always done in the past? -----Original Message----- See the relevant section at http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SamFortMyers wrote: 9-digit zip codes merge as single zero (while 5-digit codes merge successfully). I've tried formatting field to text, even reducing original 9-digit codes to 5 digits, but nothing seems to work. . . |
#10
|
|||
|
|||
In ToolsOptionsGeneral, check the "Confirm conversions at Open" box and
try the different connection methods that are presented when you attach the datasource to the mailmerge main document. Connecting via DDE might be what you are after. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Carole" wrote in message ... I will give this a try. With some files, though, Word is changing the zero-leading zips -- as well as all nine- digit codes -- to "0" only (not simply dropping the leading "0"). I'm not sure that this is the same issue. Either way, my bigger question is why is this now necessary? I've never had to customize merge fields before. Isn't there a way just to tell Word to bring in the data exactly as it appears in Excel? -----Original Message----- This is the relevant part of the site. You must toggle on the field codes (Alt+F9) and add a formatting switch to force the display into the required format. 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 { MERGEFIELD Zip \# "00000" } 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. { IF { MERGEFIELD Zip } "99999" "{ MERGEFIELD Zip \# "00000'-'0000" }" "{ MERGEFIELD Zip \# "00000" }-0000" } Zip = 12345 12345-0000 Zip = 123456789 12345-6789 -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Carole" wrote in message ... I'm having the exact same problem. I went to this web site, but have no idea what the information means or is telling me to do. I have worked with mail merges for years but have never had to customize anything like this. Why doesn't word just bring the right numbers over as it has always done in the past? -----Original Message----- See the relevant section at http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SamFortMyers wrote: 9-digit zip codes merge as single zero (while 5-digit codes merge successfully). I've tried formatting field to text, even reducing original 9-digit codes to 5 digits, but nothing seems to work. . . |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with my TOC Field Code | Jed Sheckler | New Users | 1 | August 31st, 2004 10:59 PM |
Problem is clicking min. button, not minimizing in code | paul | Using Forms | 1 | August 13th, 2004 02:22 PM |
Problem with recent Drop Down List Code | krislyn | General Discussion | 1 | August 2nd, 2004 11:10 PM |
Problem with Access db as a source for mailmerge document | patblake | Mailmerge | 1 | June 18th, 2004 05:47 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |