In the Confirm Data Source dialog box, click MS Excel Worksheets via DDE (*.xls), and then click OK. 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. Under Select recipients, click Use an existing list, and then click Browse. Under Select starting document, select the starting document that you want to use, and then click Next.
In the Mail Merge task pane, select the type of document that you want to work on, and then click Next. On the Tools menu, point to Letters and Mailings, and then click Mail Merge Wizard. On the Tools menu, click Options, and then click the General tab.Ĭlick to select the Confirm conversion at Open check box, and then click OK. Start Word, and then open a new blank document. Use Dynamic Data Exchange (DDE) to connect to the Excel worksheet that contains the data that you want to use. To resolve this behavior, use one of the following methods.
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. This behavior applies to formatted percentages, currency values, and postal codes, as shown in the following table: 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. Excel 2010 Microsoft Word 2010 Excel 2016 Excel 2013 More.
0 kommentar(er)
