If you need further assistance, contact the PPS Support Desk on UK 0845 0680 777 or Worldwide +44 1283 542729 then option 2

Mail Merge

A mail merge is a way of contacting multiple clients with a preset template via Email, SMS or Letter.
Before you start the process of a mail merge the first step is to configure your Client preferences.

From your main PPS screen go to Tools > options > general system options > set up client preferences.
On this screen you need to pay particular attention to the marketing & mail shots section, from here you need to select the format you would like to send your mail merge.

Section 1 – Configuring your mail merge settings

  1. You can set PPS to send the mail merge as an Email, Letter, SMS or Telephone contact. In the below example we have set the preferences to send firstly by Email, Telephone, SMS & Letter.



  2. Once you are happy with your default settings to update the changes you need to click Apply, Update Now! and then OK.

    You have now configured PPS to decide the best way to contact your clients each time you create a mail merge.

    We now need to set up your mail merge template, this will contain all the information you wish to send to your clients.

Section 2 – Setting up your mail merge template

  1. Go to Tools > Activity templates (letters, emails etc).


  2. On the list of activity templates click Add.


  3. Add the name of your template and make sure the category is set to Marketing/mail shot by using the blue drop down box. Add your subject title.


  4. The above example is based on a letter template setup.
    The next step is to decide if you are creating your template in PPS format or in Microsoft Word. If you are using Microsoft Word then skip to step e.

    To set up your template via PPS you do the following: In the (letters Using PPS) section you can add your template details. A useful tool at this stage is the Merge field option. If the click on the Merge field button you are able to insert individual merge fields. When you have chosen your merge field you then click in the letter text box and your merge field appears. Once you are happy with your letter content finish by clicking OK.

  5. Creating a template in Microsoft Word. You now need to open Microsoft Word and start to set up the format of your template. You can add the merge fields from PPS into your word document; this is done by clicking on the merge field button and selecting your merge field. You then revert to your Word document and press ‘ctrl v’ on your keyboard; this will insert the merge field. Once you are happy with you Word template save it. You then go back into PPS and click on Select Existing Document. You then need to locate your newly created word document and click OK. Your word template will appear in the word document field. Finish by clicking OK.

All the report wizards work in a similar way so the steps described below are based on the following example: Produce a list of patients, whose client status are active, are associated with the practitioner Alan Davies, who have not had an appointment in the last six months.

Step 3 – Creating/sending a mail merge


  1. From your main PPS screen go to Reports > PPS reports & Mail merge.





  2. Highlight the Client List report and click Open. You can navigate between the different sections of the report wizard by clicking the tab sections at the top of the screen or clicking Back or Next.


  3. Select the Practitioner Alan Davies. Select Last Ever Occurrence Only radio button. (As we are just interested in the last time a client had their appointment). Click the date range tab to go to the next section.


  4. Select None – Enter Dates. If there is a date in the Date from field, highlight the date and press Delete. Enter a date equivalent to six months ago into the Date To field. (This will restrict the number of clients to only the ones that last attended up to six months ago). Click on the Criteria tab where you can optionally type a heading for the report.



  5. To limit the patients to just the active ones, using the blue drop down box select Client Status. Then if not already displayed, using the blue drop down box, select 'Active'. Click Finish to run the report and open the Report Output screen. PPS will prompt you if no matches are found, i.e. the report is empty.


  6. On the report output screen click Mail Merge. This shows the mail merge output screen.



  7. On the mail merge output screen click Marketing & Mail Shots.



  8. You will then be informed how many clients have been found. Click OK.


  9. On the Marketing & Mail shots screen select your mail shot or choose to create a new one.

    Click Continue.


  10. If this is the first mail merge you have done for this particular selection then you need to select Add/combine with clients already included in the mail shot.

    If you have already got to this stage previously and you do not wish to double up your client selection then you need to select Replace clients already included with new selection. Finish by clicking Ok.



  11. On the process your mail shot screen you will see the list of clients you have selected and will then have the choice to send you mail shot via Letters, E-mails, and SMS.



  12. For this example we will send our mail shot via letter. Click Letters. You will then be prompted that you are about to produce ‘x’ number of letters. If you are happy with this amount then you click OK.



  13. You are now prompted to select your printer. Once selected click Print.
 

Replies Comments
There are no comments for this article. Be the first to post a comment.


Related Articles
BUPA Physiotherapy Tender PPS Reports
Viewed 86 times since Tue, Oct 5, 2010
Activities Report
Viewed 51 times since Tue, Oct 5, 2010
Accounts Report
Viewed 57 times since Tue, Oct 5, 2010
Excel Output
Viewed 120 times since Tue, Oct 5, 2010
Client List Report
Viewed 58 times since Tue, Oct 5, 2010
Clinical Notes Report
Viewed 59 times since Tue, Oct 5, 2010
Report Output
Viewed 47 times since Tue, Oct 5, 2010