Category: Office

Word Template Mail Merge in Business Central: What is it?

Ian Grieve4 minute read0 comment

Microsoft Dynamics 365 Business CentralThis article is part of the In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

The mail merge functionality in Business Central is relatively new, having been introduced in the 2021 Wave 1 Release.

The purpose behind this functionality is to allow the mail merge functionality of Microsoft Word to use data from Business Central. For example, you might want to send a document to a lot of recipients to tell them of a change of address or produce mailing labels for a brochure to be sent to all customers.

The mail merge is configured first in Business Central where you start to create a new Word document into which you choose the tables and fields to be available and then export a zip containing a blank Word document and data source which you can use to create the document into which the data will be merged and place the fields. This document is then imported back to Business Central and is then ready to be used.

When a mail merge is done, you can apply filters to restrict the data and then produce the merge, which can be in Word, PDF, HTML or text formats. Unfortunately, there is no option to email the resulting mail merged document, which seems an odd limitation in 2024.

Over the next couple of articles in this series, I will show how a Word document for mail merge can be created and then used.

In Microsoft Dynamics 365 Business Central, how do I…

In Microsoft Dynamics 365 Business Central, how do I…
In Microsoft Dynamics 365 Business Central, how do I… Sign Up For a Trial
In Microsoft Dynamics 365 Business Central, how do I… Get Access to the Microsoft 365 Admin Center
In Microsoft Dynamics 365 Business Central, how do I… Create a Company
In Microsoft Dynamics 365 Business Central, how do I… Copy a Company
In Microsoft Dynamics 365 Business Central, how do I… Switch Between Companies
In Microsoft Dynamics 365 Business Central, how do I… Create a Sandbox Environment With Cronus
In Microsoft Dynamics 365 Business Central, how do I… Access Dynamics BC Admin Centre
In Microsoft Dynamics 365 Business Central, how do I… Create a Sandbox Environment With a Copy of Production
In Microsoft Dynamics 365 Business Central, how do I… Create a User
In Microsoft Dynamics 365 Business Central, how do I… Add a User In 365 Admin Center
In Microsoft Dynamics 365 Business Central, how do I… Add a User in Dynamics BC
In Microsoft Dynamics 365 Business Central, how do I… Change My Role
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Role Center
In Microsoft Dynamics 365 Business Central, how do I… Create an Advanced Evaluation Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Update Rollout Timeline
In Microsoft Dynamics 365 Business Central, how do I… Change the User Experience in a Company from "Essentials" to "Premium"
In Microsoft Dynamics 365 Business Central (Administration), how do I… Set Update Date
In Microsoft Dynamics 365 Business Central, how do I… Hide the Teaching Tips
In Microsoft Dynamics 365 Business Central (Administration), how do I… Set Update Window
In Microsoft Dynamics 365 Business Central (Administration), how do I… Extend Trial
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Search
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Types of Pages Available
In Microsoft Dynamics 365 Business Central (Administration), how do I… Know Which Keyboard Shortcuts Are Available
In Microsoft Dynamics 365 Business Central (Administration), how do I… Switch Between Companies
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use List Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Advanced Filters on Lists
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Card Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the FactBox
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Action Bar
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Company Badges to Identify Companies or Environments
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Document Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Worksheet Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the On-premise Lifecycle Policy
In Microsoft Dynamics 365 Business Central (Administration), how do I… Start a Free Trial (Updated for the new "customised trial")
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Sandbox for a Preview Release
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand General Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Specific Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Tax Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Tax Business Posting Group
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Tax Product Posting Group
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create the Tax Posting Setup
In Microsoft Dynamics 365 Business Central (Administration), how do I… Add a Company Logo
In Microsoft Dynamics 365 Business Central (Administration), how do I… Share a Saved List View
In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename a Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename an Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete a Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete an Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore an Environment to a Point in Time
In Microsoft Dynamics 365 Business Central (Administration), how do I… Refresh an Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Approaches to Configuring a New Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… View Two Pages at the Same Time
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Maintain Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand What Data Can Be Deleted
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Master Data Management
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Relationships Between Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create Relationships Between Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Access Business Central
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Master Data Management
Using Extended Texts In Microsoft Dynamics 365 Business Central: What are Extended Texts?
In Microsoft Dynamics 365 Business Central (Administration), how do I… Add Branding to Business Central by Setting a Theme
Word Template Mail Merge in Business Central: What is it?
Word Template Mail Merge in Business Central: Create Word Template for Mail Merge
Word Template Mail Merge in Business Central: Create Mail Merge from Business Central Entity
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize a Page
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Remove Personalization from a Page
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize Card Pages
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Understand the Best Way of Customising a Card Page
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize the FactBox
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize the Action Bar
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Understand the Best Way of Personalizing the Action Bar
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Create Customizations for Other Users Using Profiles
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Copy Profile Personalizations to Another Environment
In Microsoft Dynamics 365 Business Central (Customization), how do I… Understand the Difference Between Personalization vs. Design
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand the Chart of Accounts
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand G/L Account Categories and Subcategories
In Microsoft Dynamics 365 Business Central (Financial), how do I… Maintain G/L Account Categories
In Microsoft Dynamics 365 Business Central (Financial), how do I… Create a G/L Account
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand the Types of G/L Account Available
In Microsoft Dynamics 365 Business Central (Financial), how do I… Indent Chart of Accounts
In Microsoft Dynamics 365 Business Central (Finance), how do I… Understand Dimensions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Maintain Dimensions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Global and Shortcut Dimensions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Default Dimensions and Priorities
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Default Dimensions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Dimension Restrictions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Default Dimension Priorities
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Dimension Combinations
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Dimension Combination Blocks
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Dimension Combination Limits
In Microsoft Dynamics 365 Business Central (Financial), how do I… Remove Dimension Combination
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand General Journal Templates and Batches
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Dimension Sets
In Microsoft Dynamics 365 Business Central (Financial), how do I… Create a General Business Posting Group
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Accounting Periods and Fiscal Years
In Microsoft Dynamics 365 Business Central (Financial), how do I… Create a General Product Posting Groups
In Microsoft Dynamics 365 Business Central (Financial), how do I… Create a New Fiscal Year
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure the General Posting Setup
In Microsoft Dynamics 365 Business Central (Financial), how do I… Manually Create a New Fiscal Year
In Microsoft Dynamics 365 Business Central (Financial), how do I… Close a Period
In Microsoft Dynamics 365 Business Central (Financial), how do I… Allow a User to Post into a Closed Period
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand the Recommended Steps for Closing a Period
In Microsoft Dynamics 365 Business Central (Financial), how do I… Close a Fiscal Year
In Microsoft Dynamics 365 Business Central (Financial), how do I… Close the Income Statement
In Microsoft Dynamics 365 Business Central (Financial), how do I… Stop People Posting to a Closed Fiscal Year
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Why You Can Post to a Closed Year
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Locations
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Setup Inventory for Locations
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create an Inventory Location
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create an Inventory Posting Group
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create the Inventory Posting Setup
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand the Difference Between Inventory and Warehouse Management
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create a Warehouse User
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand the Different Levels of Inventory and Warehouse Management
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Basic Inventory
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Basic Inventory With Shelves
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Basic Inventory With Bins
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Enable Processing of Inventory Using Bins
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Add Bins to a Location
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Stock Using Bins
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create Bins in Bulk
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Bin Contents
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Set Default Bin for Items
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Inventory Put-aways in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Inventory Put-aways
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Put-away from the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Multiple Inventory Put-aways Using a Batch Job
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Put-away in Two Steps by Releasing the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Put-away Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Inventory Picks in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Inventory Picks
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick from the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Multiple Inventory Picks Using a Batch Job
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick in Two Steps by Releasing the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Receipts in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process a Receipt From the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Receipts
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Receipt From a Warehouse Receipt Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Warehouse Receipts and Put-aways in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Receipts and Put-aways in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post a Receipt From a Warehouse Receipt Document and Post Put-away From a Warehouse Put-away Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand the Warehouse Put-away Worksheet in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Put-aways to Use the Put-away Worksheet in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create a Warehouse Put-away Worksheet Template
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Put-away Stock Using the Warehouse Put-away Worksheet
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Shipments in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process a Shipment from the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Shipments
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Shipment From a Warehouse Shipment Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Warehouse Picks and Shipments in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Picks and Shipments in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Pick From a Warehouse Pick Document and Post Shipment From a Warehouse Shipment Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Use the Pick Worksheet for Warehouse Picks
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Prevent Negative Stock Levels
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock at a Customer Location
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock in My Warehouse
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Stock On a Van
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Mass Insert Item Pictures
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Remove a Warehouse/Location from Use
Using Extended Texts In Microsoft Dynamics 365 Business Central: Add Extended Texts to Items
Using Extended Texts In Microsoft Dynamics 365 Business Central: Add Extended Texts to Stockkeepping Units
Using Extended Texts In Microsoft Dynamics 365 Business Central: Enable Item Extended Texts to be Added to Transactions Automatically
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Create a Vendor Posting Group
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Produce a Goods Received Not Invoiced Report
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Keep Invoiced Purchase Orders
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Understand Dates on Purchase Invoices
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Override VAT on a Purchase Invoice
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Assign Number Series in Purchasing
Using Extended Texts In Microsoft Dynamics 365 Business Central: Create a Purchasing Transaction with Manually Added Extended Texts
In Microsoft Dynamics 365 Business Central (Sales), how do I… Create a Customer Posting Group
In Microsoft Dynamics 365 Business Central (Sales), how do I… Produce a Goods Shipped Not Invoiced Report
In Microsoft Dynamics 365 Business Central (Sales), how do I… Keep Shipped Sales Orders
In Microsoft Dynamics 365 Business Central (Sales), how do I… Assign Number Series in Sales
Using Extended Texts In Microsoft Dynamics 365 Business Central: Create a Sales Transaction with Manually Added Extended Texts
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Understand For What Power Automate can be Used
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Types of Flows Are Available
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Actions Are Available with Power Automate
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Triggers Are Available with Power Automate
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Flow Templates Are Available from Microsoft
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create Environment Variables for the Environment and Company
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a Flow For a Selected Record
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a New Cloud Instant Flow
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for when a Business Event Occurs
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… An Alternative to Environment Variables
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for an Approval
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record on Create
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a New Cloud Flow for Business Central From a Template
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record on Delete
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record on Modification
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record Change
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Understand Business Central Power Automate Actions
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get url V3" Action
In the "For a selected Record V3" Microsoft Dynamics 365 Business Central Trigger in Power Automate, the Record URL is Avalable Without Using "Get url V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Find records V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Find One record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Update Record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Create Record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Delete Record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "List Companies V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Run Action V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get Adaptive Card V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get an Image, File or Document V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Update an Image, File or Document V3" Action
In Microsoft Dynamics 365 Business Central (Development), how do I… How to Upload an Extension

In Microsoft Dynamics 365 Business Central (Administration), how do I…

In Microsoft Dynamics 365 Business Central (Administration), how do I…
In Microsoft Dynamics 365 Business Central, how do I… Sign Up For a Trial
In Microsoft Dynamics 365 Business Central, how do I… Get Access to the Microsoft 365 Admin Center
In Microsoft Dynamics 365 Business Central, how do I… Create a Company
In Microsoft Dynamics 365 Business Central, how do I… Copy a Company
In Microsoft Dynamics 365 Business Central, how do I… Switch Between Companies
In Microsoft Dynamics 365 Business Central, how do I… Create a Sandbox Environment With Cronus
In Microsoft Dynamics 365 Business Central, how do I… Access Dynamics BC Admin Centre
In Microsoft Dynamics 365 Business Central, how do I… Create a Sandbox Environment With a Copy of Production
In Microsoft Dynamics 365 Business Central, how do I… Create a User
In Microsoft Dynamics 365 Business Central, how do I… Add a User In 365 Admin Center
In Microsoft Dynamics 365 Business Central, how do I… Add a User in Dynamics BC
In Microsoft Dynamics 365 Business Central, how do I… Change My Role
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Role Center
In Microsoft Dynamics 365 Business Central, how do I… Create an Advanced Evaluation Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Update Rollout Timeline
In Microsoft Dynamics 365 Business Central, how do I… Change the User Experience in a Company from "Essentials" to "Premium"
In Microsoft Dynamics 365 Business Central (Administration), how do I… Set Update Date
In Microsoft Dynamics 365 Business Central, how do I… Hide the Teaching Tips
In Microsoft Dynamics 365 Business Central (Administration), how do I… Set Update Window
In Microsoft Dynamics 365 Business Central (Administration), how do I… Extend Trial
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Search
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Types of Pages Available
In Microsoft Dynamics 365 Business Central (Administration), how do I… Know Which Keyboard Shortcuts Are Available
In Microsoft Dynamics 365 Business Central (Administration), how do I… Switch Between Companies
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use List Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Advanced Filters on Lists
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Card Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the FactBox
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Action Bar
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Company Badges to Identify Companies or Environments
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Document Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Worksheet Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the On-premise Lifecycle Policy
In Microsoft Dynamics 365 Business Central (Administration), how do I… Start a Free Trial (Updated for the new "customised trial")
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Sandbox for a Preview Release
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand General Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Specific Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Tax Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Tax Business Posting Group
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Tax Product Posting Group
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create the Tax Posting Setup
In Microsoft Dynamics 365 Business Central (Administration), how do I… Add a Company Logo
In Microsoft Dynamics 365 Business Central (Administration), how do I… Share a Saved List View
In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename a Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename an Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete a Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete an Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore an Environment to a Point in Time
In Microsoft Dynamics 365 Business Central (Administration), how do I… Refresh an Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Approaches to Configuring a New Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… View Two Pages at the Same Time
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Maintain Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand What Data Can Be Deleted
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Master Data Management
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Relationships Between Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create Relationships Between Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Access Business Central
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Master Data Management
In Microsoft Dynamics 365 Business Central (Administration), how do I… Add Branding to Business Central by Setting a Theme
Word Template Mail Merge in Business Central: What is it?
Word Template Mail Merge in Business Central: Create Word Template for Mail Merge
Word Template Mail Merge in Business Central: Create Mail Merge from Business Central Entity
PrintFriendlyLinkedin

Word Template Mail Merge in Business Central: Series Index

Ian Grieve2 minute read0 comment

Microsoft Dynamics 365 Business CentralThis article is part of the Word Template Mail Merge in Business Central series, but articles within it will also be part of the larger ongoing In Microsoft Dynamics 365 Business Central, how do I… and In Microsoft Dynamics 365 Business Central (Administration), how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

The Word template functionality in Business Central allows you to leverage the mail merge functionality of Microsoft Word to create documents which pull data from Business Central.

This is the series index for the Word Template Mail Merge in Business Central related posts I will be writing. The series index, below, will automatically update as each article in the series goes live.

Word Template Mail Merge in Business Central
What is it?
Create Word Template for Mail Merge
Create Mail Merge from Business Central Entity
PrintFriendlyLinkedin

Splitting a Table on a Microsoft Dynamics 365 Business Central Word Template

Ian Grieve3 minute read0 comment

Microsoft Dynamics 365 Business CentralThis technically isn’t a Microsoft Dynamics 365 Business Central issue, but I encountered it when working on a Word template from Business Central. The same action will work for any table in Microsoft Word regardless of what data is in the table.

I was doing some work for a client, adapting the layouts of the Word templates used to produce documents such as the sales invoice. The client asked me if it was possible to pin the footer of the document to the bottom of the page instead of having it floating up and down with the invoice lines.

I figured this might be possible to do, if I could have them in a separate table. I had a fiddle around with it and realised the option to split a table was exactly for what I was looking. When you have the cursor inside the table where you want the table to be split, select the Layout tab on the action pane and, in the Merge section, click Split Table:

MS Word showing the Spit Table button

From the cursor down, the existing table will now be split into two.

PrintFriendlyLinkedin

Microsoft Excel Showing Formula Instead of Result

Ian Grieve2 minute read0 comment

Microsoft OfficeI was doing some work with a client a while ago and encountered a problem with Excel where it was showing me the formula in a call, rather than the result of the formula. I have no idea if the spreadsheet was sent to me with the formulas set this way (I’m not sure if this is possible) or if I inadvertently hit the keyboard combination to enable the setting at some point (Alt + M and then Alt + H).

It took me longer than it should have done to revert Excel back, so I am posting this as a reminder should it happen again.

To switch this setting off, select the Formulas tab on the action pane and, under Formula Auditing, click Show Formulas, which will toggle the setting off (or on if it is currently off):

Excel example showing formulas and the Show Formulas button highlighted
PrintFriendlyLinkedin

Add Calculated Field to PivotTable in Microsoft Excel

Ian Grieve3 minute read0 comment

Microsoft OfficeClients often think that I know more Excel than I do, because I know how to use some functions such as IF, CONCAT and more, but my knowledge of Excel is quite limited when it comes to charts, graphs and PivotTables. I was recently writing a report for a client using Jet Reports to pull Intrastat information from Microsoft Dynamics 365 Business Central (both Jet and Business Central are irrelevant as far as the detail fo this post are concerned).

One of the things I wanted to do was create a summary of the data pulled from Business Central, which meant using a standard Excel PivotTable, something with which I have almost no experience. I managed to get most of the PivotTable configured without issue, but I needed to perform a calculation within the PivotTable and it took me a while to work out.

This is done by adding a calculated field through the PivotTable Analyze tab on the action bar; click the Fields, Items & Sets » Calculated Field button:

Excel showing the Calculated Field button on the PivotTable Analyze tab

Continue reading “Add Calculated Field to PivotTable in Microsoft Excel”

PrintFriendlyLinkedin

Set New Table Style as Default in Microsoft Word

Ian Grieve2 minute read0 comment

Microsoft OfficeI’ve been doing some work recently in Microsoft Word, where I’ve been tidying up some of the formatting. One of the issues was the embedded tables were styled to look the same, but they weren’t actually a using style so any new table added, either had to be a copy of an existing one or formatting manually applied.

I formatted the table up as required and applied the format to all of the existing tables and you could apply the style to a new table:

Table with style

Continue reading “Set New Table Style as Default in Microsoft Word”

PrintFriendlyLinkedin

Change Prompt of a Drop-Down List Content Control in Microsoft Word

Ian Grieve2 minute read0 comment

Microsoft OfficeWhile I have been using Microsoft Word for years, the most I’ve generally done with it is typing and formatting documents; I’ve rarely used the content controls which, from the Developer toolbar, allow you to add drop-down lists and so on. Well, recently, I was working with a template created by someone else which had a lot of embedded drop-down lists for the client to select answers to questions.

However, the client we were working with was getting a little confused by the prompt for the drop-down lists which said Choose an item (in their defence they were working with inventory items and the drop-down control doesn’t explicitly say to click it. Below is a mocked up example showing what I mean:

Word doc showing drop-down list example

Continue reading “Change Prompt of a Drop-Down List Content Control in Microsoft Word”

PrintFriendlyLinkedin

Excel Snippets: Formula to Zero Pad to 6 Digits

Ian Grieve2 minute read0 comment

MicrosoftI might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find.

A colleague posted an Excel formula which could be used to zero pad a column in Excel, which was to be used as the ID column for data being integrated to Microsoft Dynamics 365 Business Central. The formula they had used was longer and more convoluted than was needed.

In fact you only need to use one function to zero pad. That function is TEXT which you provide with two parameters; the cell you want to zero pad and a string of zeros, the length of the output required.

So, to zero pad cell A2 with 6 zeros we would use the following:

=TEXT($A2, "000000")

You can also use the REPT function to provide the required zero [adding length, which if you’re dealing with a long string can ease readability).

The REPT function takes two parameters; the first is the character to repeat and the second is the number of times to repeat:

=TEXT($A2 ,REPT("0", 6))
PrintFriendlyLinkedin

Stop Microsoft Word Checking for Oxford Comma

Ian Grieve2 minute read0 comment

Microsoft OfficeOne of the small annoyances I’ve been ignoring in Microsoft Word for a while is the punctuation check it is showing as a problem; this is the Oxford comma (also known as the serial comma, series comma or Harvard comma). When separating a list of values, you do so with commas and the final item in the list is preceded by the word and; the Oxford comma includes a comma before the word “and”.

Microsoft Word in Office 365 has the Oxford comma enabled by default (older versions of Word did not); to disable it, open the Word Options from the File tab, select the b]Profing[/b] tab. Find the Writing Style option, set it to Grammar& Refinements and click the Settings button:

Word Options - Proofing tab

Continue reading “Stop Microsoft Word Checking for Oxford Comma”

PrintFriendlyLinkedin