This blog article explains how to build an address block and format it properly with DocumentsCorePack for MS CRM 2013 templates (.docx). With the DocumentsCorePack Field Properties-functionality, users can easily format every address line and define specific line behaviour if the information was not stored in CRM.
Requirements: DocumentsCorePack (DCP) for MS CRM 2013
Example
Figure 1: DocumentsCorePack String properties-functionaltiy.
How to build an address block
An address block can easy be created with the DocumentsCorePack Template Designer. To do so, open MS Word and navigate to the www.mscrm-addons.com-tab. Click on the [Insert MailMerge Fields]-button and answer the question in teh DocumentsCorePack Question box with a click on the [Yes]-button in order to get to the DocumentsCorePack Task Pane.
Figure 2: Open the DocumentsCorePack Task Pane.
Figure 3: DocumentsCorePack Task Pane for MS CRM 2013
Once you have selected the Entity Type to work with (here: Account), you can start to insert the proper MailMerge Fields to your future address block. To do so, double-click on the required field to insert it into the document.
Figure 4: Example address block
Now save your template with a click on the [Save Template]-button at the top.
Figure 5: Save the template.
In the next window, define a name for the template e.g. Accounting_AddressBlock and click on the [Save]-button in order to continue.
Figure 6: Save Template-window
Once your template is saved, select the appropriate CRM Data with a click on the [Choose CRM Data]-button. In the so opened window, type in the Name of the entity you are looking for and click on the [Search]-button in order to look for it. Select the right result with a click on it, so it is highlighted in blue. Next, click on the [Select]-button in order to continue.
Figure 7: Select the appropriate CRM data
Figure 8 shows a possible result after the document merge, while figure 9 shows the mailmerge fields of the template.
Figure 8: Merged address block
Figure 9: Inserted Mailmerge Fields
As you can see, there is several address information missing, because the specific data has not been saved previously in CRM.
In order to format the address block properly, click in one of the fields and then on the [Field properties]-button to define what should happen if the information was missing in CRM.
The String Properties-window will pop up.
Figure 10: String Properties-window.
Now you can select between two different field options.
Figure 11: String Properties – window
- Activating the first chechbox will: delete the line/row if the whole line/row is empty.
If the whole line is empty after the merge process, then the whole line will be deleted.
Please note: all characters like hyphens, colons, commas as well as words or additional text (e.g. version #: <
- Activating the second checkbox will: delete the line/row if the selected field is empty.
If you select <> and activate this checkbox the line will be deleted if there is no postalcode stored in the chosen record. No matter if there is still data information in the remaining line.
Addional formatting information:
We recommend to activate the Show/Hide formatting marks symbol
.Figure 12: Paragraph marks and other hidden formatting symbols This is very useful to show paragraph marks and other hidden formatting symbols.
Figure 13: Activate the “Show/Hide” formatting marks symbol
In order to avoid line distance, users can press [Shift] + [Enter].
Figure 14: Avoid line distance with [Shift] + [Enter]
In this case the line ends where the Show/Hide formattings marks symbol is placed. Then the two lines are joined together and will be treated as one line/row. E.g if you mark the <
To learn more about how to remove blank lines except for address blocks, please read our blog article about the DocumentsCorePack Insert Remove Empty Line-button.
That’s it! We appreciate your feedback! Please share your thoughts by sending an email to support@mscrm-addons.com.