How to Send notification email via Outlook to all the users of TeamTrack?

choudary_ss's picture
choudary_ss asked on April 3, 2012 - 8:46am | Replies (4).

I am new to the teamtrack and do not have basic knowledge on TT.

I have been asked to create a script which wil send notification mail to all the internal/external users via Outlook for outages, maintenance, etc…

Please help me.. waiting for the response

4 Answers

jptownsend's picture

Where is your TeamTrack Administrator? You can do this from TeamTrack if you wish too. Open a report and select the email icon from one of the opened issues. You can then email all fo the people in that Solution.

choudary_ss's picture

Thanks for the response. But I my request is to send mail to all the users of TT via Outlook for outages, maintenance, etc…

We are being admin for the tool. Supose we need to bring down the tool and we have no way to communicate to the users that the TT will be down for a while

TechWell Contributor's picture

Since you need to use Outlook to send, your best approach might be to get all the email addresses from the TS_USERS and TS_CONTACTS tables in the db:

select ts_email as email from ts_users UNION select ts_email as email from ts_contacts;

choudary_ss's picture

Thanks for the query.

CMCrossroads is a TechWell community.

Through conferences, training, consulting, and online resources, TechWell helps you develop and deliver great software every day.