Send email to multiple users using Sharepoint Designer 2007

To send email to multiple users, stored in multi-user people picker field, using sharepoint designer 2007, one needs to play a little trick. Please do as follows:

1) Create a variable ,  create a new action of type Build Dynamic string:

        Click on “Actions” and choose “Build Dynamic string”. Click on “Dynamic string”, this will open a new multiline textbox. Click on Add lookup , choose Source as Current Item and select your multiple user people picker column. You will see multiple values column only while creating dynamic string. Store it in a new variable something named like “EmailUsers”.

2) Create another action to send email and in TO section , choose “EmailUsers” variable under Workflow data.

Thats it !!

Leave a Comment

Your email address will not be published. Required fields are marked *