Quick Merge for Excel™+Word™

Simple and fast use of correctly formatted numbers in mail merging.

Automatically Use Correct Number Formats in Mail Merge Documents – Without Using Cumbersome Mergefields!

 

The way Word takes data for mail merge documents from an Excel spreadsheet often leads to formatting difficulties. The numbers displayed in the mail merge are not copied in the user’s interest.

For example, the date is displayed in the wrong format. For numerical values, the thousand separator is missing and the decimal places and percentage values are output with countless decimal places. This may look like this, for example:

Wrong values merged from Excel? Easy mail merge with Quick Merge for Excel™+Word™

 

A Complex and a Simple Solution

 

To ensure that the data is transferred correctly to mail merge documents, the data fields in the document must be formatted accordingly using “MERGEFIELD” formulas, like {MERGEFIELD date \@ “DD.MM.YYYY”} for the date field or {MERGEFIELD number \# $######,0.0} for the currency amount.

But this can be done much easier with the software tool “Quick Merge for Excel™+Word™”. Quick Merge uses the number formats of Excel for your mail merge exactly as they are displayed in Excel. The cumbersome procedure of inserting {MERGEFIELD} formulas is no longer necessary.

If you use Quick Merge, the mail merge automatically looks, according to the Excel table, like this (example uses Swiss formatting):

With Quick Merge all values will be displayed correctly in your mail merge documents.

Quick Merge: Easy Creation of Mail Merge Documents with Correct Number Formatting

 

When using Quick Merge, you create your main document as usual. You simply insert the merge fields into your Word document with curly brackets, such as {Turnover}, without complicated {MERGEFIELD} formulas. You can use the column header or the column letter as field names. Number and date formats as well as calculated values are automatically transferred exactly as displayed in Excel (example uses Swiss formatting).

 

Mail Merge Using an Excel Spreadsheet
How to correctly mail merge from Excel to Word with Quick Merge

With Quick Merge you can directly start the merge process and afterwards print the resulting document. Quick Merge also offers the possibility to save merged documents individually with individual file names in any desired folder. Detailed functions for “Quick Merge for Excel+Word” can be found here.

Download a free demo version of “Quick Merge for Excel™+Word™” and test the software tool for your next mail merge.

Download now!

Quick Merge for Excel™+Word™ - Download free demo version

Change Language

Download

Current Version 1.15
Change Log


Buy

Kaufen

Factsheet

Information as PDF
PDF Englisch
PDF Deutsch

Folgen Sie uns

Facebooktwittergoogle_pluslinkedinyoutube



© Copyright by
Infonautics GmbH Switzerland