|
|
||||||
|
#1
04-17-08, 11:29 PM
|
|
|
|
|
I am trying to do a mail merge from my Excel database and a Word doc.
Thezip code is giving me problems. Any Zip Codes beginning with 0 do do not merge correctly. I have tried everything. I have tried as text as numbers as special with zip and still no luck. PLEASE HELP I have a mailing that has to get done. |
|
|
|
#2
04-17-08, 11:42 PM
|
|
|
|
|
You can either use the field formatting options within Word, or in Excel you
can use the TEXT function to format the number appropriately. |
|
#3
04-17-08, 11:52 PM
|
|
|
|
|
Don't send anything to the NE United States? :)
Try the suggestion here http://blog.ptraining.com/2005/08/di...ord-mailmerge/ |
|
#4
04-18-08, 12:33 AM
|
|
|
|
|
Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions here: http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. leisa.p wrote: [..] |
|
|
| Similar Threads | |
| Excel text data in a cell HELP HELP HELP I am making a spreadsheet. In Column A, I have a name. In Column B, I have two lines of data that need to be separate, i.e. ARCH 323 and ARCH 545. The problem is, I want... |
|
| Excel 2004 for Mac to Excel 2007 for Windowsdisplay/functionality issues! PLEASE HELP! Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: intel Hi everyone: I run on mac and use Excel 2004, but frequently share documents with my boss, who uses... |
|
| Help needed with opening an Excel file from an embedded excel application. Hello, I have a SDI MFC application that uses the following code to create an empty embedded excel 2003 application: (Extracted from [..]) void... |
|
| Excel/automation Gurus., please help... extract macros from excel and adding new macros into an excel sheet. Hello Excel/automation Gurus, I am working on an application where I have to keep a centralized database of all macros distributed to user and save the changes back on a... |
|
|
All times are GMT. The time now is 07:05 PM. | Privacy Policy
|
Excel Help