Auto populate email subject line with offset cell

I am trying to automatically populate the subject line of my email.
If "True" is found in column AE, I want the value of the cell in column A in the same row
To be included in my email subject line. I have tried everything and I cannot
get it to work. Any help would be greatly appreciated.

I have tried everything and I cannot get it to work

Post what you have tried... It's a little difficult to offer suggestions that fit in with your existing code without seeing what you have at the moment.

Please Login or Register  to view this content.