Cornerstone Email Reminders: Incorrect Email Addresses
Wednesday, March 3, 2010 at 2:33PM A client asked a question of me today, and it helped me discover a little trick I wanted to share with our readers. It concerns invalid email addresses when sending email reminders. (This assumes that you do not have Cornerstone Practice Explorer; if you do there is another guide coming for that instance)
When email reminders are sent there are, almost inevitably, some that will not send correctly. You will receive a message in your Outlook Inbox stating that the message failed to send due to an invalid email address. The question now becomes "How do I discover which client had the bad email?" Sometimes it is pretty straightforward: if the email address is john.smith@gmil.com you can safely assume the client is John Smith, and his email is supposed to end in @gmail, rather @gmil. Other emails are a little more troublesome, and without Practice Explorer, Cornerstone cannot generate a report that contains both a clients name and email address. Additionally, the returned emails in Outlook only contains the pet name, and if that happens to be a rather common name, you could end up searching Cornerstone Patient Lists for quite a while. There is, however, a way to discover this information without frustrating yourself searching through Cornerstone; additionally, you do not need to resend the emails to retrieve this info.
1. If you have not already done so, generate email reminders for the appropriate dates. This can be done by left-clicking "Activities" in the menu bar, left-clicking "Reminder Selection", and then left-clicking "Generate Reminders".

2. In the "Generate Reminders" window, enter in your "Beginning date:" and "Ending date:". In the "Distribution type:" field use the drop-down arrow to select "Email Reminders Only". Left-click the "OK" button when you are finished.

3. The "Generating Reminders" window will appear showing how many email reminders have been generated. Left-click the "OK" button to close this window. The "Reports Preview" window will appear, allowing you to preview the reminders. You can close this by left-clicking the "Cancel" button.

4. Now we will locate the file the reminder information is saved into. First go to the computer desktop, then double left-click "My Computer", then the "C:" drive, followed by the "Cstone" folder. Once you have the "Cstone" folder open, scroll down until you find a file named "namelist.csv". Double-left click this file to open it; it is best viewed using the Excel program from Microsoft Office.

5. The "namelist.csv" file contains the information created by the email reminder generation. If you scroll to the right, you will a list of all the email addresses. You can expand this window by double-clicking the line between the columns titled "AA" and "AB".

6. You can now use the search function in Excel to locate the invalid email addresses and their associateed clients. On the Excel menu bar, left-click "Edit", then left-click "Find..." (you can also open it by holding the "Ctrl" key and the "F" key at the same time.)

7. In the "Find and Replace" window, type in all or part of the invalid email address, then left-click the "Find Next" button. If this does not take you to the email address for which you are searching, left-click the "Find Next" button until the correct email address is found. Left-click the "Close" button to close the "Find and Replace" window. You can now scroll left to find the corresponding client name. Once you have this information you can return to Cornerstone and locate the clients record, allowing you to make contact and update your records to include a valid email address.











