I want to send an email from a workflow using...

[Simon_Robinson]

I want to send an email from a workflow using 2 formulas.

The first will always pull 1 email address from table1.

Whereas the second forumla will pull a list of emails from table2.

Both formulas work fine, but I’m not sure how to combine them.

Tried

List(Formula1,Formula2)

in the To box of the workflow.

But it says this can’t be a list

Which is odd because the output of formula2 is itself a list.

Anyone any ideas?