A generic field code looks something like Press Shift + F9 to display the coding of the selected field or Alt + F9 to expose the codes of all the fields in your document.This can be Date, Currency, Percent or some other field. Select the merge field whose format you want to change.To add a numeric switch, perform these steps: If this solution is not applicable to you for some reason, you can control the formatting of Excel data in Word by adding a numeric switch (formerly called a picture switch) to a particular merge field.Ī numeric switch is a kind of mask that lets you format the contents of a field in a Word document the way you want. Now, all numeric values in the Word mail merge document retain their original formats.Ĭonnecting to an Excel worksheet via DDE is the fastest way to fix all formatting problems in one go. To prevent multiple prompts displayed by Word every time you open the data file, clear the Confirm file format conversion on open check box after connecting to your mailing list. It may take Word quite a while to connect to your Excel data source via DDE, so please be patient - this will save you even more time in the long run :) In the Confirm Data Source dialog box that opens, check the Show all box in the lower left corner, then choose MS Excel Worksheets via DDE (*.xls), and click OK.Browse to your spreadsheet, select it, and click Open (or double-click the file). When it comes to selecting recipients, choose Use an existing list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |