Here’s my try at the macro. Was able to cobble together something in AppleScript that would read the Excel sheet.
The next issue is to output each item in the list to the second application (Epic EHR in the Citrix Viewer) as noted above in the screenshot. I need to iterate through the list, but I’m not really clear how. Each output to the target application needs to be followed by a return.
Any help is appreciated.
Excel to Fill Epic SmartPhrase User List
Excel to Fill Epic SmartPhrase User List.kmmacros (3.4 KB)
This text will be hidden
An example of the spreadsheet: