Use merge tags for users, not subscribers

I’m using my site as an intranet for our organization. As such, I’m hoping to use Newsletter to distribute company wide information.

One such emails that goes out is when we hire a new employee, an employee is promoted, or an employee leaves the company. Every employee has a profile on our site with additional meta data.

Is there way to create a mail template that has merge tags that would be dynamically filled with an employee’s information? Maybe a page that would allow HR to select an employees name from a drop down (dynamically created by listing all users) and then submit/send that would email off to a distribution group?

Or if there’s a way to leverage a shortcode to create a submit button on a user’s profile page that would trigger these emails.