If they just need SELECT just GRANT them that:

USE msdb;
GO
GRANT SELECT ON sysmail_allitems TO [UserName];

Perhaps this helps:
CREATE TABLE #Sample (X xml);
GO

INSERT INTO #Sample
VALUES (
'<session id="342338">
<properties dateModified="2015-02-27" manuscript="Test_1_0_0_0" engineVersion="2.0.0" cultureCode="en-US" cultureName="United States [english]" caption="Test"...

A simple change would be:
SELECT Contact, Role, SecretarysExpert
FROM (
SELECT ExpertID, Expert AS [Contact], 'Expert' AS [Role], '' AS [SecretarysExpert] FROM #tblExperts
UNION
SELECT E.ExpertID, Secretary...

I'm wondering if you seem to be over thinking this, as AD groups actually seem like a good solution to this.

Say you have following Schemas for the following...

Not a question for help, we fixed the problem, but just wondered if anyone knows of any updates "recently" that caused problem with the Log on as Service permissions. Our...