WD2002: Excel Data Does Not Retain Its Formatting in Mail Merge Operations

Traduzione articoli Traduzione articoli
Identificativo articolo: 320473 - Visualizza i prodotti a cui si riferisce l?articolo.
Espandi tutto | Chiudi tutto

Sintomi

If you perform a mail merge in Microsoft Word and you use a Microsoft Excel worksheet as the data source for the recipient list, some of the numeric data may not retain its formatting when it is merged.

This behavior applies to formatted percentages, currency values, and postal codes, as shown in the following table:
   Format          In Excel data     In Word MergeField
   ----------------------------------------------------
   Percentage          50%                  .5
   Currency         $12.50                12.5
   Postal Code       07865                7895
				

Cause

This behavior occurs because the data in the recipient list in Word appears in the native format in which Excel stores it, without the formatting that is applied to the worksheet cells that hold the data.

Risoluzione

To resolve this behavior, use Dynamic Data Exchange (DDE) to connect to the Excel worksheet that contains the data that you want to use. To do this, follow these steps:
  1. Start Word, and then open a new blank document.
  2. On the Tools menu, click Options, and then click the General tab.
  3. Click to select the Confirm conversion at Open check box, and then click OK.
  4. On the Tools menu, point to Letters and Mailings, and then click Mail Merge Wizard.
  5. In the Mail Merge task pane, select the type of document that you want to work on, and then click Next.
  6. Under Select starting document, select the starting document that you want to use, and then click Next.
  7. Under Select recipients, click Use an existing list, and then click Browse.
  8. In the Select Data Source dialog box, locate the folder that contains the Excel workbook that you want to use as your data source, select the workbook, and then click Open.
  9. In the Confirm Data Source dialog box, click MS Excel Worksheets via DDE (*.xls), and then click OK.
  10. In the Microsoft Excel dialog box, under Named or cell range, select the cell range or worksheet that contains the data that you want to use, and then click OK.
    NOTE: Your data now appears in the Mail Merge Recipients dialog box with the same formatting that appears in the Excel worksheet.

Riferimenti

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
304387 WD2002: Date, Phone Number, and Currency Fields Are Merged Incorrectly When You Use an Access or Excel Data Source

Proprietà

Identificativo articolo: 320473 - Ultima modifica: domenica 29 febbraio 2004 - Revisione: 1.0
Le informazioni in questo articolo si applicano a
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Word 2002 Standard Edition
Chiavi: 
kbprb KB320473
LE INFORMAZIONI CONTENUTE NELLA MICROSOFT KNOWLEDGE BASE SONO FORNITE SENZA GARANZIA DI ALCUN TIPO, IMPLICITA OD ESPLICITA, COMPRESA QUELLA RIGUARDO ALLA COMMERCIALIZZAZIONE E/O COMPATIBILITA' IN IMPIEGHI PARTICOLARI. L'UTENTE SI ASSUME L'INTERA RESPONSABILITA' PER L'UTILIZZO DI QUESTE INFORMAZIONI. IN NESSUN CASO MICROSOFT CORPORATION E I SUOI FORNITORI SI RENDONO RESPONSABILI PER DANNI DIRETTI, INDIRETTI O ACCIDENTALI CHE POSSANO PROVOCARE PERDITA DI DENARO O DI DATI, ANCHE SE MICROSOFT O I SUOI FORNITORI FOSSERO STATI AVVISATI. IL DOCUMENTO PUO' ESSERE COPIATO E DISTRIBUITO ALLE SEGUENTI CONDIZIONI: 1) IL TESTO DEVE ESSERE COPIATO INTEGRALMENTE E TUTTE LE PAGINE DEVONO ESSERE INCLUSE. 2) I PROGRAMMI SE PRESENTI, DEVONO ESSERE COPIATI SENZA MODIFICHE, 3) IL DOCUMENTO DEVE ESSERE DISTRIBUITO INTERAMENTE IN OGNI SUA PARTE. 4) IL DOCUMENTO NON PUO' ESSERE DISTRIBUITO A SCOPO DI LUCRO.

Invia suggerimenti

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com