Data Source - Access Database

Using Recipients Information from an Access Database

It is quite common to save your names and addresses in an Access database.

Letter Mail Merge

Open or create your letter

Select the Mailings tab and choose (Start Mail Merge > Letters)
Then choose (Select Recipients > Use Existing List)
SS

Select Data Source

This will display the "Select Data Source" dialog box
In this example we are going to use the Northwind database as it should already be installed by default.
Browse to its location and press Open

Select the table containing your details, in this example it is going to be the Customers table.
Select Table dialog
SS

Editing the Recipients List

Then choose (Edit Recipient List)
This will display the Mail Merge Recipients dialog box
Select the ones you want to include and press OK
SS

Inserting Mail Merge Fields

Select (Insert Merge Field) to display the "Insert Merge Field" dialog box,

Preview Results

You can use the Preview Results group to preview the results and
Once you are happy with it press "Finish and Merge"
This displays the "Merge to New Document" dialog box.

SS task pane

(Tools > Letters and Mailings > Mail Merge)
Type of document choose letters
click next starting document
select "use current document"
ckuck "next: select recipients"
select data source identical to above
C:Program Files\Microsoft Office\Office 11\Samples\Northwind.mdb
Display the "select table" dialog

Edit recipients list - identical to above
click recipient list - identical to above
click - next write your letter
click - next preview your letter
Preview your letters on task pane
SS
click on more items to display the "Insert Merge Field" dialog box
click next - complete the merge

click on browse to select your Access database

Display "Data Link Properties" dialog box
Test the connection press OK
click on More Items and pick the fields
Preview and complete