Mail Merge

Office trick to be able to use the combined correspondence.

Mail Merge is a system for sending mass letters to many recipients using a designed model (a template). To use this system it is necessary to create the data source (Access database or Excel spreadsheets) and then create the template in a Word document. To achieve this we will:

First we will create in Access or Excel the model that we want to combine. Next, in the Word document, we will open a new document, and in the taskbar we will click on Tools, Mail Merge and we will follow the following steps:

1.Main document.

We must define which will be the main document of the combination.

Create form letters. It will ask us if we use the active window of the current document or not, we will say yes (active window).

2. Data source.

We need a data source. In our case it is an Access database.

To select it: click on obtain data, open data source, in file type select MS Access Databases, we accept, the tables will appear, we select one and click on accept

3. It is an automatic step.

We now have two new buttons on the Word taskbar: Insert Merge Field, Insert Word Field…

To add fields from the database, we will click on Insert combination field in the place we want.

To combine all the data and all the pages of each record in the database come out, we will click on combine, in a new document, and a window will open with all the combined pages.

You can download a file with a sample BD with a file in Word Combined