| On this page: Download | Upgrade | Buy | Which mail merge product(s) do I need? |
Also: Screenshot | Demo workbook | Help file |
Mail merge using only Microsoft® Excel® software.
- Simple and easy to use
- No need to know Microsoft® Word software or other programs
- Various output options
- Easy to merge forms and data requiring formulas, lookups, 'if' statements etc
- Numerous advanced options
- On-line help file and troubleshooting
- Demo workbook with examples
- FREE to try for as long as you wish with full functionality
To run a merge you simply create two worksheets:
- The destination sheet is your form/letter etc, with the merge field
names marked by << >> in any cells
eg cell A6 might contain "Name: <<Firstname01>>,".
The sheet can be named as you wish, and can contain any number of merge fields alongside any other lookups, in a formula or within text. - The source sheet will contain the rows of data to be merged. In row 1 you put the merge field names (eg Firstname in cell A1, excluding <<>> and the 2 digits), and below you have your data to be merged (eg John in cell A2).
The results can be output to:
- print preview for testing / individual printer selection
- your printer
- individual emails, either in the email body or as attachments (text files, Microsoft® Excel®
workbooks, html files or pdf files*)
If you use Microsoft® Outlook® there are various options, and you can send the emails straight to your outbox - a file - either one plain text file with page breaks, or individual text files, or individual Microsoft® Excel® workbooks, or html or pdf files*
- a new workbook with each merge result on a separate worksheet
There are also a number of advanced options such as different numbers of printouts per merge, insert different images, selective source row merging, and merge to different destination templates in one run, plus a whole range of options for emails if you use Microsoft® Outlook®.
Download and try it out for free now, and buy securely on-line with license details by return email.
* To create pdf files you will need Excel 2007 or later, and for Excel 2007 the free Microsoft add-in
Click to see full size screenshot
| Which mail merge
product(s) do I need? |
||
|
PATools Mail Merge 1
row of data per merge Examples:
|
PATools Advanced Mail Merge
Multiple rows of data per merge Examples:
|
PATools Page Merge 1
row of data per merge Examples:
|
By installing and using this software you affirm your complete and unreserved acceptance of the PATools
End User License Agreement
For new users, the software will run on an evaluation basis, which means that you can use it for as long as you wish but it will only run up to 6 merges in each run. This restriction is lifted once you have bought a license.
You can purchase a license 24/7 using our secure automated service from this webpage below.
Changes since last release
Upgrade
No need to uninstall your current version - simply close Excel, download as above and overwrite your existing copy.
If you have a licensed copy then you should download into the same folder as the previous version, otherwise you may need to re-enter your licensing details and may lose any saved settings.
Contact us if you have problems.
Buy
BUY NOW from the secure ordering site of our payment partner share-it! where you can pay in various currencies
Licenses expire after 1 year.
SAVE MONEY by buying an extended license (lasting more than 1 year) - see here
SAVE MONEY ONLY GBP 80.00 for a 1 year license for the full PATools Merge Suite* - buy here
* Suite consists of PATools Mail Merge, Advanced Mail Merge, Page Merge and Label Merge
SAVE MONEY by buying several PATools Excel products - see here