Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 907348 - Last Review: October 13, 2005 - Revision: 1.3
When you perform a mail merge in Publisher 2003 or in Publisher 2002 by using an Excel spreadsheet as a data source, all the Zip+4 postal codes are converted to zero in the output
When you perform a mail merge in Microsoft Office Publisher 2003 or in Microsoft Publisher 2002 by using a Microsoft Excel spreadsheet as a data source, all the Zip+4 postal codes are converted to
0 (zero) in the output.
Additionally, performance may also be slow if the Excel data source contains many records.
This behavior occurs because Excel determines the type of data in a column by parsing the first eight rows of that column. When the type of data after the eighth row differs from the type of data in the first eight rows, Excel returns a value of
0.
To resolve this behavior, move at least one of the records that have a Zip+4 postal code so that the record is in the first eight rows of the Excel spreadsheet. Then, perform the mail merge.
For more information about Excel data sources, click the following article number to view the article in the Microsoft Knowledge Base:
304387Â
(http://kbalertz.com/Feedback.aspx?kbNumber=304387/
)
Date, Phone Number, and Currency fields are merged incorrectly when you use an Access or Excel data source in Word 2002 or Word 2003
APPLIES TO
- Microsoft Office Publisher 2003
- Microsoft Publisher 2002 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate