問題 Sharepoint Designer Workflow Records Reading

  • 2012年4月30日 下午 10:47
     
     

    I have a list of contacts. I want a workflow that will read through a filtered down version and create one string of all the emails from those contacts so that I can then email everyone in the list when an announcement is created.

    Data

    John     j@email.com       

    Jim       jj@email.com

    Susy    S@email.com

    Resulting string

    j@email.com; jj@email.com; s@email.com

    That is the part I don't know how to do

    Any suggestions?

所有回覆

  • 2012年4月30日 下午 11:11
     
     

    1) Drag Send Email Activity and then click Email "These Users" link. This will open send email dialog.

    2) In the To field click the Book icon to select the user and in the opened dialog pick Workflow Lookup for a user.. and click Add.

    3) This will open another dialog box and in that dialog box pick your contact list in Data Source field. For the Field from source field pick your email address column.

    4) In the Find the field section pick the field which is common for all user e.g. Company Name and Enter the company name as the value.

    I think this should take care of what you want to do.

    In the screen shot above I have picked my custom contact list so dont worry too much about the field names. This is just for your reference so that you get the idea.


    Amit

  • 2012年5月1日 上午 06:47
     
     
    Amit,  Thank you for responding. Unfortunately this only returns only the first record and not all of the records. - Mike
  • 2012年5月2日 下午 06:40
     
     

    Hi Mike

    In that case I think the best approach would be (you  might already know this) use SharePoint group or you create your custom activity which reads your contact list and sends an email.


    Amit