4TOPS Mail Merge to Microsoft®Excel®

New: Excel Link successor - 4TOPS Mail Merge for Microsoft® Access

4TOPS Mail Merge to Microsoft Excel offers an easy and controlled way to export data from Microsoft Access® to Microsoft Excel. 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

Download Now! Order now!

Other 4TOPS Tools for Microsoft® Excel®:

•  4TOPS Import Assistant for Microsoft Excel files
• Compare Excel Files

Excel mail merge

Microsoft Excel mail merge tutorial

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

All these features are explained extensively in the Microsoft Excel mail merge tutorials included in the products help file.

Example: creating an invoice

In the following example we apply Mail Merge to Microsoft Excel to the North wind database order form to create an Invoice document.

Generate access export to Excel template with merge fields

Lay the template out as you like it and save. Now from the toolbar activate the 4TOPS Excel template selection form. If you added an Microsoft Excel chart changes to the chart layout will also be saved and reused!

The invoice document is generated. If you used the add-in as part of 4TOPS Document Management, it will also store the document automatically in the right folder with the right document name.

Microsoft Excel chart example

Related products

4TOPS Mail Merge to Microsoft Excel is also included in 4TOPS Office Link and  4TOPS Document Management. Microsoft Word mail merge is supported by 4TOPS Word® Link

Support

For any questions or requests concerning this product or to all other 4TOPS products please contact support@4tops.com.

Installation

The download uses self-extracting technology for easy installation.