Creating a Mail-Shot

{{#customtitle:Report Generator - Creating a Mail-Shot|My Title}}

Search Tab

The Search Tab requires you to specify the criteria which you want to base your Report on.

The default setting for the Search Tab, is to select *****ALL***** patient records.

The below example is going to search for patients records with the surname 'Smith'.

• First of all you need to select the correct table for the field you wish to include in your search.
• Click the 'Patients' option in the 'Table' list.
• Now you need to select the correct field. Click 'Surname' in the 'Field' list.
• You need to now specify the logical operator required. Double click on 'Equals' in the 'Criteria' list. Your screen should now look like this.

• Type 'Smith' into the Search For text box.
• Click OK.
• Finally your screen should now look as below.

Display Tab

The Display tab is where you need to select the data fields that you want the Report Generator to include within your report. In this example we are going to select the First Name, Surname, Date of Birth and Address1(first line of the address) fields.

• First of all you need to select the correct table for the field you wish to include in your reprot.
• Click the 'Patients' option in the 'Table' list.
• Now you need to select the correct fields. Double Click 'First Names' in the 'Field' list.
• Repeat this process for all the other fields listed above.
• Each time you double click a field, it should be entered into the Display List on the right.
• Your screen should now look like this.

To make our report a little easier to read we can now order the report in Ascending/Descending order on one of our selected fields. In this example we are going to order the results via the 'First Names' field is Ascending order.

• Click on the 'Sort By' drop down.
• Click 'Patients.[First Names]'
• Ensure the dot is selected next to 'Ascending'.
• Your screen should now look like this.

View Tab

The View tab will now allow us to view our report.

• Click on the 'Show Data' button.
• Should the Report Generator find any results that meet your search criteria, your screen should now look something like this.

Other than the requested information, the Report Generator will show you the total number of records displayed, and will also allow you to remove duplicated records, based on all the visible fields, by ticking the 'Show Unique Records' tick box.

In order to create a Mail-Shot you will first need a custom report to work with. Please see the Creating a New Report section of the Report Generator help file.

Once you have got a report generated you need to do the following:

• Click the Output tab.
• Ensure Mailshot is selected.
• Click Mail Merge from the Mail Merge options.
• You Screen should now look something like this.

You now have to choose your Word Processor Output Option. You have two choices as listed below:

• Print - This will merge your patient list to a template of you choice, and send it straight to the Printer.
• File - This will merge your patient list to a template, and save it into MS Word Document at a location of your choice.

Please note it is always recommended that you choose the 'File' option, and check you final mail merge before you send it to the printer. This will prevent any wastage in terms of resources.

When you have selected your Word Processor Output Option, you need to click the Output Report button.

You will then see something similar to the following screen.

You need to navigate to wherever your saved Template is located, and Double Click on it.

At this point depending on which Word Processor Output Option you selected, Optisoft Enterprise will either send your mail merge directly to the printer, or display a similar screen to the one above, asking you where you would like to saved your merged document.

Once saved you can open the merged document, check the content and then print the document. There is also the option in MS Word to print your merged document in small batches, should you not wish to print a lot of letters in one go.

Back