Welcome to the Exact Product Blog

On this blog we will cover stories from all around the Exact ecosystem.

Posts Tagged ‘Word merge’

Technology adoption

Written by Michiel Dorjee on . Posted in Exact Synergy

Nowadays the speed of new technologies becoming available for us is tremendously high. Together with this rapidity new functionalities and possibilities are being introduced. It’s quite an effort to catch up and follow in the same pace as these new products are being launched. To give our (early adopter) customers a peek inside, I have listed the new products from the Microsoft “train” which we will be supporting.

Exact is currently working on making our products Exact Globe Next (‘with extended functionality’) and Exact Synergy Enterprise ready to support the newest Microsoft platforms: Windows Server 2012, Windows 8, Internet Explorer 10 and Office 2013.

Below you see the list of new technologies which will be supported in each product:

Exact Globe Next

  • Windows Server 2012
  • Windows 8
  • Internet Explorer 10 (only for Exact Globe Next ‘with extended functionality’)
  • Office 2013

Exact Synergy Enterprise

Somewhere next half year we expect to support all the above technologies in the specific product. For the exact release dates please keep a close eye on this blog.

Word Merge is the new standard

Written by Martin Ortgiess on . Posted in Exact Synergy

Easily send a predefined email or letter in corporate style. That was the goal we had in mind when designing the new Word Merge functionality. And… I think we succeeded!

This is how I introduced Word Merge for Product Update 249 in April this year. Since then, we have customers positively working with this new feature. We continued to improve Word Merge in Product Update 250 by adding new features and made it even easier to make a letter or send an email.

Based on the positive feedback and rich functionality that the New Word Merge offers, it will be our standard Merge offering as of Product update 250. This means that newly created administrations will have ‘new Word Merge’ only! Existing administrations will have the option to use ‘New Word Merge’.

New in product update 250:

New menus and functions

  • Create letters for, or Send email messages to, a group of recipients based on Account-, Contact person, People- and Request search  result
  • Create letter or send email from project card
  • Creating a Quotation in MS Word is heavily extended with the new Word Merge implemented. Item pictures can be added to item lines and much more information (tags) is available to be used in the template.
  • Send automated emails related to customer- and reseller portal:
    • Portal access activation
    • Reset password
    • Portal access deactivation
  • Give your letter or email a unique reference number which can be easily traced back:
    • Setting to determine the format of reference number
    • the reference number is one of the fields that can be used to make your template (tag)
    • the reference number can be published in the Synergy document description, which make it easy to trace it back
  • Send email messages including attachments: When sending an email, the user can select a Synergy document. All attachments linked to this document, will become email attachments

Improvements on existing features

  • User can add recurring lines to a template. This means that you can add information to a template that you normally would store in a table. Think about quotation item lines, an overview of all roles linked to a person or a list of all members of a project
  • The process of creating a letter or sending an email is improved and simplified.
    • The user first selects a template from a list.
    • After selection the template, the user can fill in related information that is defined for this template. The options the user has, is set by the template creator and is template specific. Think about:
      • User must fill in the contact person to send the email, where other fields will not appear for this template
      • Fields can be set mandatory and/or editable
      • Defaults are already prefilled
  • You can use all information available in Synergy on your templates: just extend your merge schema with the fields needed


  • ‘Old’ Merge functionality is no longer offered in new databases
  • Support Word Merge in combination with multiple Synergy environments on 1 server
  • Support 64 bit Synergy environments
  • Support basic authentication

Exact Synergy Enterprise product update 249 and Exact Globe Next product update 404 are in controlled release

Written by Bert Siekmann on . Posted in Exact Globe, Exact Synergy

As of now Exact Synergy Enterprise product update 249 and Exact Globe Next product update 404 are in controlled release. That means that these releases are now available for resellers as well as all controlled release customers. After a successful controlled release period we will announce both products generally available, planned for mid-June.

Responding to challenges and needs of professional services organizations we have extended our PSA offering with numerous enhancements which will allow users to work more efficiently, save costs and achieve higher margins. Among others we will offer now integration of WBS (work breakdown structure) and budgets, a new flexible project cockpit and the possibility to copy a scope of a project  for easy project scope creation. Additionally, in this product update of Exact Synergy Enterprise we will launch a new Word Merge functionality that makes it easier to generate MS Word documents in which content from various entities from Exact Synergy Enterprise, such as accounts, projects and persons is automatically included. Moreover, we have extended Exact Synergy Enterprise with numerous enhancements, such as UX improvements, a solution to facilitate new Dutch holiday entitlement legislation and other improvements that have been developed based on direct feedback from our customers.

In Exact Globe Next we focused on facilitating the needs of our Wholesale customers; we have implemented numerous changes to the current functionality, such as improvements to E-WMS (release notes in tab Warehouse Management System). Additionally, after an extended controlled release period the B2B e-Commerce Portal will be generally available as of Exact Globe Next product update 404. To further extend the value proposition for customers in the Manufacturing field, we offer new solutions such as Exact Visual Scheduler (to be generally available) and back flushing for by-products. Moreover, we have extended Exact Globe Next with a large number of new features that facilitate changes in regional legislations and other enhancements that have been developed based on direct feedback from our customers.

Furthermore, in advance to launching Exact Globe Next product update 404 and Exact Synergy Enterprise product update 249 we have introduced numerous solution: Exact Synergy Enterprise Configurator and Central Master Data Management are now generally available. The Exact’s Service Management solution that strengthen wholesale and manufacturing companies is now in controlled release.

Please note that as a result of an extensive controlled release period and the feedback we received from our customers we have made a decision to change the name of Exact Globe to Exact Globe Next. What it means in practice is that when a customer decides to update his current Exact Globe, it will be updated to Exact Globe Next product update 404. An upgrade is not mandatory but when a customer decides to do so he will automatically benefit from the improvements of the Exact Globe Next version. Furthermore, he can request extended functionality that is standard in Exact Globe Next but not available without requesting it: Exact Synergy Enterprise with the Synergy user, integration with SSRS reports that offers real-time dashboard reports and a selection of alerts facilitated by Exact Event Manager. And a new menu/shell with state-of-the-art UX from which a user can operate all new and existing features. In the coming weeks we will provide more information on how this request process will work.

Should you have any questions regarding controlled release of Exact Synergy Enterprise product update 249 or Exact Globe Next product update 404, do not hesitate to comment on this blog post.

Word Merge tricks: Create professional letters and emails using all data available in your system

Written by Martin Ortgiess on . Posted in Exact Synergy

Exact Synergy offers the possibility the send (bulk)-emails and -letters. This has been possible for years already, but last year this mechanism was completely renewed. This new Word Merge is by default activated for new customers. Customers already using Synergy for over a year can also benefit from these new possibilities. Switching to this new mechanism is quite straighforward and the benefits are great. For more information go to this video or this blog post.

With the new Word Merge, letter- and email-templates can be made in MS Word. In MS Word, the template creator selects which schema to use, where a schema is nothing more than a group of merge fields. Merge fields from the selected template(s) can be dragged into the MS Word template. At the moment a user is creating a letter or sending an email to a customer or colleague, these merge fields will be filled with the correct corresponding data.

Exact delivers a huge set of merge fields by default which are stored in one big schema. Administrators can create their own schemas with their own set of merge fields. He can use default merge fields or add new merge fields to this schema: field that were not delivered by default. How this works, is described in the example below. Credits for this example go to my colleagues Sanja Djuretic and Mahyar Shojaeifar.

A real life example

In this example we will extend a schema used to create a Word Merge template for this scenario: For the request type “I Need” a “TextFreeField4” is linked to the item. In this example an item with a code 80003 and description Flowers is selected in specific request, as shown in the following screenshot.1picture


When the WordMerge template for the letter from Request is created using Exact General schema then mapping TextFreeField4 to the content control in template document will result in showing item code, here 80003, in the final letter. 2picture 

– If user wants to show description of the TextFreeField4, in this example Flowers, than it is necessary to extend the schema used for xml mapping by means of adding new metadata and creating new schema related to the new metadata.

One can get new metadata, here item description of the “TextFreeField4” (“freetextfield_04″ DB name), in 2 different ways:
• By sub query:
<Field name=”ItemDescFromTextFreeField4″ sql=”(SELECT Description FROM Items WHERE ItemCode = {0}.freetextfield_04)” />
• By using join:
<Join name=”ItemFromTextFreeField4″ lookUpEntity=”Items” lookUpJoinType=”left” fieldName=”freetextfield_04″ lookUpKey=”Code”  />

Note that using join it is possible to get more information from the Item while sub query returns only one value, description in here.

-Following section shows the content of new metadata file and schema and explains how and where to save these files.  
These files should be created and saved according to the naming conventions and in the folders as described in the document How to: Extending Word Merge schemas

1.Save following metadata as “MailMergeTags.Req.xml” file in the “xml” folder of the Synergy “Exact WordMerge Integrator” installation:

<?xml version=”1.0″ encoding=”utf-8″?>
    <Entity name=”Request”>
        <Field name=”ItemDescFromTextFreeField4″ sql=”(SELECT Description FROM Items WHERE ItemCode = {0}.freetextfield_04)” />
        <Join name=”ItemFromTextFreeField4″ lookUpEntity=”Items” lookUpJoinType=”left” fieldName=”freetextfield_04″ lookUpKey=”Code”  />

2.Save following text as “Req.Schema.xml“. You can save it in the same folder as the above metadata file is saved.

<eExact  xmlns=”Exact extended Request schema”>
    <ItemDescFromTextFreeField4>Description of item, stored in request free text field no.4</ItemDescFromTextFreeField4>

3.Upload new schema to the Synergy – click on the Documents menu in the Word Merge section on the Schemas and select New Schema. Choose Request as a group.
Note: It is not necessary to upload new schema to Synergy before you use it to create the Word Merge template but in case that you want to share it with other users we recommend the upload.

-Next step is to update the existing Word document used for Request letter template with the free field description field from the new schema.
This can be achieved by adding new schema in the Xml Mapping pane – add new Custom XML Part –  and then adding new description field to the template document as shown below.
Save and upload this document template to Synergy and you are ready to use it!

The letter created from the Request using latest template (created with the field from extended schema) will contain description for the item selected in related TextFreeField4. 3picture

 Our customers and partner can go to this document in the customer portal, where attached is a simple app Word2SQLApp which gets the template, extracts used tags and output final SQL; it can help to understand how template will behave during merge process.

Furthermore, attached here are extended metadata file, schema and template used as examples in this document.

New Word Merge: The video part II

Written by Martin Ortgiess on . Posted in Exact Synergy

Last year we have been working on a new platform to easily create letters and send emails using Exact synergy Enterprise.
In Product Update 249 the first features of the new Word Merge became available. See this blog post and the new Word Merge video part I for more information.
In Product Update 250 we finished the project and all features are there now. See this blog post for more information.

In this 7:52 minutes video we show you all features deliver in Product Update 250. Have a look and see how your organisation can benifit from it.
Don’t hestitate to contact me for more details!

Video of the new Word Merge functionality – PU249

Written by Martin Ortgiess on . Posted in Exact Synergy

The new Word Merge functionality is introduced in Product Update 249 (around July 2012). In this previous blog I already wrote something about it, but a drawing (and certainly a fantastic video) says more than a 1000 words! See for your self how the New Word merge can improve the communication with your (potential) customers, employees and other stakeholders.

Got interested to start using the new Word Merge? Don’t hesitate and active it!

Read the Release Notes to see how you can start using the New Word Merge. How do you know if you are using the new Word Merge? Go to an account card: in the header you should have the buttons: ‘Create letter’ and ‘Create email’. If you have the button ‘Mail merge’ you are still using the previous version. (or check the Word Merge checkbox in DocumentsàSettings)

Introduction of the new Word Merge

Written by Martin Ortgiess on . Posted in Exact Synergy

Easily send a predefined email or letter in corporate style. That was the goal we had in mind when designing the new Word Merge functionality. And… I think we succeeded!

With Exact Synergy Enterprise product update 249, the first version of the new Word Merge will become generally available. It is the successor of current merge functionality in Exact Synergy Enterprise (HTML and Word Merge) and offers a wide range of improvements. (video)

For every company it is of great significance that documents that are sent to external stakeholders or employees are professional and follow the guidelines of your company. There are a couple of things that are important when you want to achieve this, where again the most crucial one is that it should be simple to create a letter or send an email. To realize this, the screen where ‘it all happens’ must be clear and to the point. The key elements here are the number and quality of templates available. The number of templates should be kept to a minimum, so that the end user can easily pick the right one. The quality of the templates should be guaranteed. The new Word Merge functionality takes care of all of this.

The new Word Merge offers the following features:

– You can easily create a letter or send an email

  • Easy screen from where you can send email or create a letter
  • Templates are available based on roles and action
  • User can select to save a copy of the sent email to Exact Synergy Enterprise
  • Server side merging: good performance and no tools needed on client machine

– Templates

  • Define who can use which templates
  • Define who can maintain which templates
  • Template settings, to define which templates can be used from where (like: send email from account card or create letter from person search)
  • Set language of the template
  • Templates are made in MS Word

– Schema

  • A schema is needed to make a template. It contains a set of merge tags which can be dragged into the template. While performing the merge, these tags will be replaced by the actual value (like {account name} = Exact International Development)
  • Exact delivers default schemas. The merge tags in the schema are comparable with the merge fields currently in HTML merge
  • Consultants can easily extend the schema and add new fields
  • Consultants can make their own schema’s
  • Define who can use which schema

UPDATED: In product update 249, Exact introduces a first version of the new Word Merge functionality. This first version is limited to single merge actions only. This means that you can perform a Word Merge from account-, contact-, person- and request-card. All other merge functionality, like merge from account-, request- and person-search will remain as is. We plan to have most used Word Merge functionality available as of product update 250 which will become available second half 2012.