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
|
|||
|
|||
0 in Zip code field
I have addresses in an Excel file, with a Zip code column. When I identify the Zip code element in the Mailmerge Address block with this column some of the zip codes get converted to 0 in the labels. I discovered that some of these records were marked with the "little green corner" when Number as Text error checking was on. Some had a leading apostrophe, which I deleted, and they no longer came out as 0 in the labels. Others had no apostrophe, so I did the "convert to number" operation on the (!) select list for the cell. However, these are still converted to 0 by MailMerge. I've tried everything I can think of... retyping the zip code, Cell formatting to text, etc. etc. Nothing will get MailMerge to convert these stubborn cells to other than 0. So, what's going on here? IOW, what does MailMerge want from me in the Zip field? What am I missing? TIA Ed |
#2
|
|||
|
|||
0 in Zip code field
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 "Ed" wrote in message ... I have addresses in an Excel file, with a Zip code column. When I identify the Zip code element in the Mailmerge Address block with this column some of the zip codes get converted to 0 in the labels. I discovered that some of these records were marked with the "little green corner" when Number as Text error checking was on. Some had a leading apostrophe, which I deleted, and they no longer came out as 0 in the labels. Others had no apostrophe, so I did the "convert to number" operation on the (!) select list for the cell. However, these are still converted to 0 by MailMerge. I've tried everything I can think of... retyping the zip code, Cell formatting to text, etc. etc. Nothing will get MailMerge to convert these stubborn cells to other than 0. So, what's going on here? IOW, what does MailMerge want from me in the Zip field? What am I missing? TIA Ed |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
error 550 won't deliver | theMooooo | General Discussion | 3 | March 29th, 2005 12:47 PM |
*Another* OLK 2002 sendmail/SMTP problem | steviegb | General Discussion | 11 | March 23rd, 2005 12:59 AM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Outlook XP email goes to sent folder -receipient doesn't receive,. | Jobde | General Discussion | 3 | February 9th, 2005 04:29 PM |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |