This will be hard to implement in a workflow. Because of two issues
- Get the list of emails - The main reason is to get all items, which require some kind of loop. In 2010 this is not supported out of the box
- Run every day and sent emails (I am not sure about how frequently you want this to execute.
For #1 above we can solve it using some workarounds are explained here. Then read the items and form the email as a comma separated list into a workflow variable
For #2 - The technique is to create two identical workflows (Say A and B). The logic in A
Pause 24 hours
Start Workflow B
Logic in B
Pause 24 hours
Start Workflow A
Update
You can easily do this using JavaScript and SharePoint (client object model or WebServices)
Handle page load event
$(document).ready()
In this Using
SPServices
get the list items. http://spservices.codeplex.com/wikipage?title=GetListItems. Here you can specify aCAML
query to filter the list items to get only those who didn't picked up the packagesNow iterate through the items and form the email in the format
MailTo:[email protected];[email protected]
etc. Check thisPut the result in a hyperlink as
<a href="' + variableWithEmails + '"'>Mail To</a>
Now click the link will open the default email client.