Be sure that you have the lookups set to ignore errors so the values that it doesn't find in the first lookup can fall through to the other lookups.

It should...

Sounds like you've got a case of parameter sniffing.

See this blog post for more details:

It sounds like from that example that you could do that with For or Foreach Loop container to loop through your emails and do the appropriate operations instead of maybe...

I agree with the earlier post saying this is MUCH more easily done with a Send Mail task and expressions. You're doing nothing but replicating functionality already built into...

I usually do and haven't encountered any hiccups. For my backups, I have a full backup kick off every night, differentials every six hours, and log backups every hour....