I am exporting two files from an EHR application via their crystal reports plugin with no option to modify the reports.
EETestPatients (attached) contains Email Address which I need added to the corresponding patient ID in EEAged-AR.CSV.
The intention here is to perform a list merge to email that will show the patient's outstanding balance from Aged-AR and give them a convenient link to enable them to pay online.
Please note that I created test data with matching Patient ID in both files. The names do not match which is insignificant to me.
I would greatly appreciate some code in VBA or Script that would make it easy for an end user to add Email Address to their Aged AR report and then perform a list merge to email (outlook).
(Unfortunately, the EHR application does not offer the ability to email billing statements.)