[et_pb_section fb_built=”1″ fullwidth=”on” custom_padding_last_edited=”on|desktop” admin_label=”section” _builder_version=”4.16″ background_color=”#ffffff” custom_margin=”0px||0px|” custom_padding=”0px|0px|0px|0px” custom_padding_tablet=”” custom_padding_phone=”” global_colors_info=”{}”][et_pb_fullwidth_slider _builder_version=”4.23.1″ background_position=”top_left” custom_padding=”10%||10%|” custom_padding_last_edited=”off|desktop” hover_enabled=”0″ global_colors_info=”{}” button_text_size__hover_enabled=”off” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_text_color__hover_enabled=”off” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_border_width__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_border_color__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off” button_border_radius__hover_enabled=”off” button_one_border_radius__hover_enabled=”off” button_two_border_radius__hover_enabled=”off” button_letter_spacing__hover_enabled=”off” button_one_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover_enabled=”off” button_bg_color__hover_enabled=”off” button_one_bg_color__hover_enabled=”off” button_two_bg_color__hover_enabled=”off” sticky_enabled=”0″][et_pb_slide heading=”Quick Merge for Excel\u2122+Word\u2122” button_text=”Download now!” button_link=”https:\/\/www.infonautics-software.com\/quickmerge-for-excelword\/download” image=”https:\/\/www.infonautics-software.com\/quickmerge-for-excelword\/wp-content\/uploads\/sites\/40\/2018\/05\/QuickMergeBoxShotTransparent300.png” use_bg_overlay=”off” use_text_overlay=”off” _builder_version=”4.23.1″ header_font=”||||” header_font_size=”35″ body_font=”||||” background_color=”#00458e” background_position=”top_left” custom_button=”on” button_font=”||||” button_use_icon=”on” button_on_hover=”on” text_orientation=”left” hover_enabled=”0″ header_font_size_tablet=”35″ header_font_size_phone=”35″ global_colors_info=”{}” button_text_size__hover_enabled=”off” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_text_color__hover_enabled=”off” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_border_width__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_border_color__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off” button_border_radius__hover_enabled=”off” button_one_border_radius__hover_enabled=”off” button_two_border_radius__hover_enabled=”off” button_letter_spacing__hover_enabled=”off” button_one_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover_enabled=”off” button_bg_color__hover_enabled=”off” button_one_bg_color__hover_enabled=”off” button_two_bg_color__hover_enabled=”off” sticky_transition=”on” button_icon=”5||divi||400″ sticky_enabled=”0″]<\/p>\n
Simple and fast use of correctly formatted numbers in mail merging.<\/p>\n
[\/et_pb_slide][\/et_pb_fullwidth_slider][\/et_pb_section][et_pb_section fb_built=”1″ specialty=”on” custom_padding_last_edited=”on|desktop” background_color_1=”rgba(0,0,0,0)” admin_label=”section” _builder_version=”4.16″ custom_padding=”23px|0px|23px|0px” custom_padding_tablet=”50px|0|50px|0″ custom_padding_phone=”” transparent_background=”off” global_colors_info=”{}”][et_pb_column type=”3_4″ specialty_columns=”3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_row_inner _builder_version=”4.16″ custom_margin=”||0px|” custom_padding=”||0px|” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”3_4″ _builder_version=”4.16″ background_color=”rgba(0,0,0,0)” custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ text_font_size=”18″ use_border_color=”off” global_colors_info=”{}”]<\/p>\n
<\/p>\n
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.<\/p>\n
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:<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/www.infonautics-software.com\/quickmerge-for-excelword\/wp-content\/uploads\/sites\/40\/2018\/05\/Example3.png” alt=”Wrong values merged from Excel? Easy mail merge with Quick Merge for Excel\u2122+Word\u2122” title_text=”Wrong values merged from Excel? Easy mail merge with Quick Merge for Excel\u2122+Word\u2122” show_in_lightbox=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ always_center_on_mobile=”on” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ text_font_size=”18px” global_colors_info=”{}”]<\/p>\n
<\/p>\n
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.<\/p>\n
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.<\/strong><\/p>\n If you use Quick Merge, the mail merge automatically looks like this, according to the Excel table (example uses Swiss formatting):<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/www.infonautics-software.com\/quickmerge-for-excelword\/wp-content\/uploads\/sites\/40\/2018\/05\/Example4.png” alt=”With Quick Merge all values will be displayed correctly in your mail merge documents.” title_text=”With Quick Merge all values will be displayed correctly in your mail merge documents.” show_in_lightbox=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ custom_padding=”||50px|” always_center_on_mobile=”on” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ text_font_size=”18px” global_colors_info=”{}”]<\/p>\n <\/p>\n 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<\/strong>. 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<\/strong> (example uses Swiss formatting).<\/p>\n <\/p>\n [\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner column_structure=”1_2,1_2″ admin_label=”Zeile” _builder_version=”4.16″ custom_margin=”0px|||” custom_padding=”0px|||” global_colors_info=”{}”][et_pb_column_inner type=”1_2″ saved_specialty_column_type=”3_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.infonautics-software.com\/quickmerge-for-excelword\/wp-content\/uploads\/sites\/40\/2018\/05\/Example1.png” alt=”Mail Merge Using an Excel Spreadsheet” title_text=”Mail Merge Using an Excel Spreadsheet” show_in_lightbox=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ always_center_on_mobile=”on” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column_inner][et_pb_column_inner type=”1_2″ saved_specialty_column_type=”3_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.infonautics-software.com\/quickmerge-for-excelword\/wp-content\/uploads\/sites\/40\/2018\/05\/Example2.png” alt=”How to correctly mail merge from Excel to Word with Quick Merge” title_text=”How to correctly mail merge from Excel to Word with Quick Merge” show_in_lightbox=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ always_center_on_mobile=”on” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner admin_label=”Zeile” _builder_version=”4.16″ global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”3_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ text_font_size=”18px” global_colors_info=”{}”]<\/p>\n 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<\/a>.<\/p>\n [\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner column_structure=”1_2,1_2″ admin_label=”Zeile” _builder_version=”4.16″ custom_padding=”29px|0px|0|0px” global_colors_info=”{}”][et_pb_column_inner type=”1_2″ saved_specialty_column_type=”3_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ text_font_size=”18px” global_colors_info=”{}”]<\/p>\nEasy Creation of Mail Merge Documents with Correct Number Formatting with ‘Quick Merge’
<\/strong><\/span><\/h2>\n