I have numerous workflows set up throughout our Sharepoint site that look up email addresses from a 2nd list based on the name of the person they selected in the form. These workflows ran flawlessly before. But ever since we upgraded our Sharepoint site from WSS3.0 to Sharepoint Foundation, these emails no longer get sent. Instead the workflow errors out and says "The e-mail message cannot be sent. Make sure the e-mail has a valid recipient.".
While troubleshooting, I added an action in the workflow to log to history the email address I am supposed to be pulling from the list. Doing this showed me that the workflow is pulling no information, in other words, the data being pulled was blank, so there was no email address at all. I know for a fact that all of the lookups were created correctly because they worked perfectly fine before. However, I also tried recreating the look up action to see if it would work and it still produces the same problem.
This issue is only happening with the workflows that pull email addresses from a 2nd list and not from the current item's form.
Does anyone know how I can fix this? This is a huge issue as no one is getting notifications now and some of these items are time sensitive.
Thanks for your help in advance.