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)
