Is there a way to pull the Email Subject from an external
datasource?

I have an Excel spreadsheet with Subject, To, etc...
columns.  I would like to use the data in the Subject
Column as the Subject for the email that I am sending for
that particular rowset.

I have tried using «Subject» in the setup for the email
options and it gets the first one right, the others are
sent with the Subject of «Subject».

Any help is appreciated.