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. An Excel Link creates a template containing mergefields for all the fields in the form (and subforms).
Mapping is done using named ranges, which are added automatically to the template and can be moved to the exact position you require.
Used in:
- Microsoft Excel based Trade messaging
- Microsoft Excel based reporting / charting
- Microsoft Excel mail merge
- Microsoft Access export to Microsoft Excel
Features:
Microsoft Excel mail merge
chart in Microsoft Excel
automatic naming and storing of documents
creation of multiple documents in one go
creation of other document types (supported by Microsoft Excel, e.g. HTML format from Microsoft Excel 2000 onwards)
data can be obtained from forms with as many sub forms as necessary.
determine where data should be merged using range names
starting document creation from code / a button on your form |
