OFFICE 2016 MAIL MERGE DOCUMENT NOT TRANSFERRING CURRENCIES HOW TO
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:ġ97520 How to use a query to format data for a mail mergeīy default, Word uses OLEDB to connect to the data source when performing a mail merge. In the Microsoft Access query, use the FORMAT() function to format the data to be merged in Microsoft Word. Additionally, you must use quotation marks around the picture string.Ĭreate a query in Microsoft Access, and use the query in your Word mail merge. Note The picture switch is case-sensitive. In a currency field, use a Numeric Picture switch similar to: Include a numeric picture switch (\#) similar to one of the following examples: Note To view the field codes in Microsoft Word, press ALT+F9. To do this, use one of the following methods. Use a switch to format the results of the MERGEFIELD. To work around this problem, use one of the following methods. If you format the data in the data source, the formatting is not retained when you merge the data into the main document. To format merged data, you must format the merge fields in the main document. This behavior occurs because the data is displayed in its native, stored format in Access or Excel. The Currency field is displayed in the following format: The Phone Number field from an Access data source is displayed in the following format: The Date field is displayed in the following format: When you perform a mail merge in Microsoft Word by using OLEDB with a Microsoft Access or Microsoft Excel data source, the merge results for the Date, Phone Number, and Currency fields are incorrect. Lessįor a Microsoft Word 97 and Word 2000 version of this article, see 142340. Office Products Microsoft Word 2010 More.