Opening a list file in Excel or Notepad

You can open list files in Microsoft Excel or Notepad.

To open a list file in Excel or Notepad

1.   In the Office Manager, click Letters & Custom Lists.

The Letters & Lists dialog box appears.

2.   Click the button corresponding to the type of letter or list that you want to create:

Birthday - Birthday letters for patients within a range of birth dates.

Continuing Care - Continuing care (recall) notices to patients within a date range of Continuing Care appointments.

Referral - Referral letters to anyone who has referred or to whom you are referring patients.

Collection - Collection notices to patients within a date range of when payments have been made.

Inactive Patient - Notices to patients within a date range of Last Visit dates.

Welcome - Welcome letters to patients within a date range of First Visit dates.

Misc - Any letter that you want to selectively send to patients in your database.

A dialog box appears, listing the letter templates for the category you selected.

3.   From the list select the template for the letter that you want to create.

Note: Depending on the type of letter you choose, you may need to set a date range. To set a date range, click the date range search button and specify the beginning and ending dates for the range. You can leave any date field blank to set an open-ended range.

If you are setting a birth date range and want to create letters for every patient born between the years January 1, 1980 and January 31, 2014, set those dates and then select Search as a Date Range. If, however, you want to create a birthday letter for a patient born in the month of January between January 1, 1980 and January 31, 2014, set those dates and DO NOT select Search as a Date Range.

4.   Click one of the following buttons:

Open in Notepad – Opens the list file in Notepad.

Open in Excel – Opens the list file in Excel.