Find mail enabled lists in SharePoint

Open SQL Query Analyzer and run the following query against your WSS_Content database. This works in SharePoint 2007 and 2010. SELECT Webs.FullUrl, AllLists.tp_Title, AllLists.tp_EmailAlias FROM AllLists Inner join webs on AllLists.tp_WebID = Webs.Id where AllLists.tp_EmailAlias is not null