Creating Email & Including Specific Corresponding Data from Range

Hello,

This question is quite tricky for me, any help would be greatly appreciated I'm trying to create a sub that will create and then display a customized/formatted email (in the example below I'm going to be trying to send out email type 1). Within the sub, I'm trying to figure out if there's a way for me to insert specific cells of data from the same row of data as the email type selected while running the counter and then insert them into specific spots of the email body. Essentially, the title would reference the exact project # for the row of data selected under the email type 1 sub. Then, the body of the email would contain references to the project name, end date, balance remaining, and encumbrances remaining all from the same row of data as the email type that is currently being run in the sub.

I've searched for ways of trying to do this and have not have much luck. Currently I'm receiving a compile error: expected array when I try to run my code with the ReDim Answer13 line highlighted. I'm not sure if my approach is the best so please let me know if you need any further information and thank you for any assistance

Please Login or Register  to view this content.

Here's the .HTMLBody portion of my code on its own. I think I'm getting closer, or hope... any assistance would be greatly appreciated

Please Login or Register  to view this content.