4TOPS Excel Link is an add-in for Microsoft Access (both mdb and adp), which adds data from Microsoft Access in Excel documents. You can compose simple and more complex documents, such as standard letters, invoices and reports. Open the Microsoft Access form which contains the data you want to appear in the document. Excel Link creates a template containing mergefields for all the fields in the form (and subforms). Now you can lay out the template by putting the mergefields in the right place, adding text, formatting, etcetera. You can now create documents by selecting the template from the selection form, the mergefields are substituted with the Access data.
Automatic naming and storing of documents
Creation of multiple documents in one go
Creation of other document types (supported by Excel, e.g. HTML format from Excel 2000 onwards)
Starting document creation from code / a button on your form