locked
Is this possible (Email Sharepoint List) RRS feed

  • Question

  • I have a SharePoint list that contains an email field that users fill out.  There are several categories of users, is it possible to send an email to a filtered list within this list? 

    In other words I would like to be able to filter the list on a particular category and then send an email to the email addresses identified within that list.  Hope that makes sense.

    Thanks in advance for any assistance in this matter.

    Thursday, September 10, 2009 3:23 PM

Answers

  • You can use Actions->Open with Access to create a link table for the list in Access. And create queries in Access to filter out the list items you would send email to. Then, use the “External Data->collect data->create email” to send email based on the email address field in the list.

    For more, please refer to http://blogs.msdn.com/access/archive/2006/06/30/data-collection-through-email.aspx

    • Marked as answer by GuYuming Tuesday, September 15, 2009 1:51 AM
    Monday, September 14, 2009 7:38 AM
  • Either you need to do custom code OR You can use SharePoint Desinger to Create Workflow and Send Email based your Categroy....  i.e  (If Categroy Field ='A' Send message A Elseif ='B' Send Message B...) 
    K.Mohamed Faizal, Solution Architect, Singapore
    http://faizal-comeacross.blogspot.com/
    Thursday, September 10, 2009 3:40 PM
  • You would have to implement some custom code to accomplish this.  It's possible to do a lookup in SharePoint Designer, but you could only lookup a single email address, as you can't really "loop" in SharePoint designer.

    I would recommend implementing a custom aspx page or custom workflow activity to send the emails.

    Note:  In theory, using InfoPath, SharePoint lists and SharePoint designer workflows, it's possible to accomlpish this, but the solution is convoluted and kludgy, involving multiple lists and would not perform.  I'm going to refrain from even describing such a setup here.
    • Proposed as answer by Pablo Gazmuri Thursday, September 10, 2009 3:43 PM
    • Marked as answer by GuYuming Tuesday, September 15, 2009 1:51 AM
    Thursday, September 10, 2009 3:43 PM

All replies

  • Either you need to do custom code OR You can use SharePoint Desinger to Create Workflow and Send Email based your Categroy....  i.e  (If Categroy Field ='A' Send message A Elseif ='B' Send Message B...) 
    K.Mohamed Faizal, Solution Architect, Singapore
    http://faizal-comeacross.blogspot.com/
    Thursday, September 10, 2009 3:40 PM
  • You would have to implement some custom code to accomplish this.  It's possible to do a lookup in SharePoint Designer, but you could only lookup a single email address, as you can't really "loop" in SharePoint designer.

    I would recommend implementing a custom aspx page or custom workflow activity to send the emails.

    Note:  In theory, using InfoPath, SharePoint lists and SharePoint designer workflows, it's possible to accomlpish this, but the solution is convoluted and kludgy, involving multiple lists and would not perform.  I'm going to refrain from even describing such a setup here.
    • Proposed as answer by Pablo Gazmuri Thursday, September 10, 2009 3:43 PM
    • Marked as answer by GuYuming Tuesday, September 15, 2009 1:51 AM
    Thursday, September 10, 2009 3:43 PM
  • The idea is to be able to do Ad Hoc emails.  For example today I may want to send an email to Category 1 users and tomorrow to Category 3 users which may include some of Category 1, 2 and 3 users.  I would like to be able to open a view, filter on a category (a user may be in several categories) and send an email on an Ad Hoc basis.
    Thursday, September 10, 2009 3:45 PM
  • If it is Ad Hoc basis the only way to do Custome code. There is no way to use Out of the box OR SharePoint Desinger.
    K.Mohamed Faizal, Solution Architect, Singapore
    http://faizal-comeacross.blogspot.com/
    Thursday, September 10, 2009 3:57 PM
  • You can use Actions->Open with Access to create a link table for the list in Access. And create queries in Access to filter out the list items you would send email to. Then, use the “External Data->collect data->create email” to send email based on the email address field in the list.

    For more, please refer to http://blogs.msdn.com/access/archive/2006/06/30/data-collection-through-email.aspx

    • Marked as answer by GuYuming Tuesday, September 15, 2009 1:51 AM
    Monday, September 14, 2009 7:38 AM