Both formats can readily be uses as an import source by other application (e.g., Access and Excel).Įxecuting the "Export" command displays the following dialog. Exporting single or selected entries is not supported.Īddress book entries can be exported to and XML file or a simple text file as comma separated values (CSV). The add-in export utility supports exporting all address books entries in the active address book in one of two formats. Importing using one of the other supported formats is performed in a similar manner. Note: To avoid a sparse listing, as illustrated above, and to ensure the aesthetic look of your address book it is best to define a "Display As" field in your source files. The Import Utility is fully enabled and ready for importing. Here the user selects the "Last Name" field from the source field list and executes the "Display As" command. As the source file did not contain a "Display As" field for auto-detection and mapping, the user must define manually. To enable importing a the "Display As" field must be defined. Here all of the simple source fields were mapped. The add-in automatically attempts to map source file fields with the appropriate add-in address book entry fields. The illustrations below depict an active address book with several address book entries defined by a user and configuration of the tab controls after various combinations of user actions.Īdd-in supports importing from several source formats.Įxecuting "Set Source Fill" displays a dialog box to define the source file.Īfter selecting the source file, click "OK" Note: With the add-in methods described later, the user can define and create multiple address books, define new individual address book entries or import entries from other address book source files. The Active Address Book tab provides the means to insert a selected address book entry in the active document and tools for deleting, filtering or editing active address book entries. In addition to the Disclaimer, the add-in UI consists of the main VBA userform with a multi-page control and five tabs (show above) and four supporting VBA userforms. On installation, an empty address book named "Address Book" is defined and set as the active address book. Note: For functionality, the add-in requires an active address book. The Disclaimer is automatically displayed on first use and each time thereafter until the ACCEPT command button is used.Īdd-in user interface (U/I) on first use after accepting the terms defined in the disclaimer. It adds an "Address Book" group and "Insert Address" button control to the ribbon "Insert" tab and an address book button control to the Quick Access Toolbar (QAT). When loaded, the add-in reconfigures the Word built-in user interface as shown below. #.#.dotm file either in your Word Startup folder (so the add-in is available and loaded automatically when Word starts) or you can save it in any other convenient location and load it manually when needed.įor more on using and loading Word template add-ins see: Organizing Your Macros/Template Add-Ins. Installation and First Useĭownload the add-in file using this link: Word Address BookĪfter downloading, unzip the compressed file and save the unzipped Address Book Ver. Graham shared his code with me and I have adapted and expanded on it to provide the add-in published here. I had done some previous tinkering with document Custom XML Parts and thought I would try using one or more Custom XML Parts to store the add-in address book entries. While I liked Graham's concept of address books for Word, I became interested in trying to create multiple self-contained address books stored in the add-in and independent of Excel or any other application. Graham's version uses Excel spreadsheet to store the add-in address books and entries. Some time ago, Graham published his own Address Book Add-In to overcome this problem. When Microsoft produced the Home and Student versions of Office, without the benefit of Outlook to store frequently used addresses, Word users lost a convenient means of inserting postal addresses into Word documents. The add-in is a collaborative effort with Word MVP Graham Mayor. The purpose of this Microsoft Word Tips & Microsoft Word Help page is to publish my self contained Word Address Book Add-In.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |