Step 2: Create the report in Microsoft Word

Next we create a mail merge report in Word. First we look at creating a report where only one .csv file is generated.

In this example, we use the main .csv file (eloans.csv). In the majority of cases in which only a single .csv file is generated when a report is run out of EMu, the steps described here are all you will require to create a mail merge report. At this stage the report will include details about the loan and the borrower (but not the objects loaned).

Note: The steps described here for connecting to the DSN are required whether you have one or more than one .csv file to access.

We will then adapt out report to access data included in the second .csv file (ObjObjec.csv) in order to include details about the objects loaned.