Selecting an email from another App to SendMail
I'm currently creating an Application (AppB) which allows one of our suppliers to fill in details about their product and have it sent directly to one of our customers. So i have a form where they enter the product and select from a dropdown (a lookup on AppA which stores customer details) which customer they would like to send the details they have entered to.
As I've mentioned the email details of the customers are stored in AppA. I don't want our suppliers to have the email details of our customers, so i want this to be automatically and discretely filled in for them and then used to send the email to their selected customer. Any advice please, i've spent about half a day on this problem already.