Open MS-Word and click on Tools > Mail Merge in the main menu.
In the Mail Merge Helper dialog that appears, click on the Create button and select Form Letter in the sub-menu.
Click on Get Data > Create Data Source in the Mail Merge Helper dialog.
In the Create Data Source dialog, click on MS Query button.
IF MS QUERY BUTTON IS GRAYED OUT, YOU WILL NEED TO RE-INSTALL MICROSOFT WORD. SEE BELOW FOR INSTRUCTIONS.
1. When re-installing Microsoft Word, you will see a screen in the wizard that lists all the office programs.
2. Highlight Data Access in this list and click on "Options" button.
3. In the Options list make sure "Microsoft Query" is checked.
4. Continue with the wizard to complete re-install.
MS-Query is opened with the Choose Data Source Dialog
In the Choose Date Source dialog, make sure that the Database tab is selected. Then select <new data source> in the list and click OK.
The Create New Data Source dialog is displayed:
Enter
a name for your Data source
Select
Microsoft Visual FoxPro Driver from the list.
Click
on Connect
button.
In
the Configure Connection dialog, click on Visual FoxproDatabase (.DBC) option,
and click on Browse
button to select the Database file.
Find
the location where you have installed Easy InnKeeping program. Under EasyInn,
goto Database directory and select Easyinn.dbc (for example, C:\Easyinn\Database\EasyInnDB.DBC)
and Click Ok
This
brings the list of tables present in the database
Select “GUESTINFO “ table, and press OK
Select the data source you created in the choose data source dialog This brings the Query Wizard - Choose Columns dialog.
Select the fields you want to use in your mail merge and click on the > button.
Select Filters if any and Sort Order if any and then click on the Next Button
In the Query Wizard – Finish dialog, select “Return Data to Microsoft Word" option and click on the Finish button.
The program is back in MS-Word. Now click on the Edit New Document button.
Now the Mail Merge Tool bar will appear on your MS-Word application.
Select Insert Merge Field button and select the fields that you want to merge in the document.
Then click on Tools > Mail Merge. In the Mail Merge Helper dialog, click on the Merge button. Now the values from the database fields will be added on to your document.