PUB2000: "Numeric Field Overflow" Error Message When You Try to Perform a Mail Merge (827321)
The information in this article applies to:
SYMPTOMSWhen you try to perform a mail merge in Microsoft Publisher
2000, and you use a Microsoft Excel spreadsheet as your data source, you may
receive the following error message: numeric field
overflow CAUSEThis problem occurs when the Excel workbook that you are
using as your data source contains cell formatting that defines the cells of
the first record in the merge data list as numeric data. Because of this,
Publisher's Mail Merge Wizard expects that every cell for that merge field
contains numeric data. If any subsequent record has text or other formatting
defined for the same merge field, Publisher will then generate the error
message that is listed in the "Symptoms" section of this article.WORKAROUNDTo work around this problem, save the Excel address list as
a .csv file or a comma delimited file. To do this in Excel, follow these steps:
- Start Excel and open your address list document.
- On the File menu, click Save
As.
- In the Save as type box, click CSV
(Comma delimited) (*.csv).
- Click Save.
Modification Type: | Minor | Last Reviewed: | 1/6/2006 |
---|
Keywords: | kberrmsg KB827321 kbAudEndUser kbAudITPRO |
---|
|