Markter Posted May 18, 2005 Report Share Posted May 18, 2005 About 6 months ago someone posted a question asking what was the coolest thing you've ever done in ME? At the time I was just starting to use ME and it was inspiring to here all the different ways ME is used. I would like to ask the question again. I will start: I work for a small Health system and we have had a problem with claims being denied because some patients did not have the insurance coverage we thought they did. I have a macro(really 12 macros that work together) that kicks off a report out of out billing system that shows all the patients who have appointments that day. Then it goes out to insurance websites and gets the eligibility info for each patients, Writes the info to a file, and saves the webpage as a file. Then the macro exports that info to an Excel file that shows all the info and contains a Hyperlink to the Webpage. THis all happens in the middle of the night. It takes a couple of hours for the macro to finish. It then emails the Excel file to 11 of our clinics. I works great. And saves time and money. And best of all - it is fun. Mark Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.