Reporting Mailto: to group email

Posted on 2009-12-16
Last Modified: 2012-05-08
I created a company directory p[ulling employee info out of the ADO. Th report lists
The Employees, theyr Emp ID, cell# office, depatrment and email address.
I have added the mailto:  to the email address  field so a person can click on the email and open up the email window.  What i want to create now is the same by department or office.
This means that if i click on the office value in the office colum i want the report to gather up all the email addresses  of employees who have that same value in the office colum and string all their email address to gather and to the mailto:  function.

sql 2008 and reporting services. Report created in visual studio. The report pulls info from a pre populated table in the sql database. Sorting is allowed by Employee name, office and department on the report.

Thank you

Question by:acardullo
    LVL 16

    Accepted Solution


    Are you running Active Directory & Exchange??  The easiest solution to this problem would be to create distribution lists for each office & department... etc. rather than needing to build that list in a report.

    If you need to build it in the report you will need to use a CTE Expression to build the string


    Author Comment

    Yes, Ad and Exchange but crating DL's is not an option in this case.  Trust me. Love to create a dynamic DL but in this case this is not an option.
    LVL 16

    Expert Comment

    Wow, you know it always boggles the mind when customers won't use the tools they have available to them and would rather spend time or money developing their own custom directory.


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now