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 (907348)
The information in this article applies to:
- Microsoft Office Publisher 2003
- Microsoft Publisher 2002
SYMPTOMSWhen 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.CAUSEThis 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.RESOLUTIONTo 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.REFERENCES
For more information about Excel data sources, click the following article number to view the article in the Microsoft Knowledge Base:
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
| Modification Type: | Major | Last Reviewed: | 10/13/2005 |
|---|
| Keywords: | kbtshoot kbprb KB907348 kbAudEndUser |
|---|
|