Printing more than one row of PENDING items per person in email & date/$ formatting

[rogerisin]

I am having 2 issues I cannot solve:
1) Printing more than one row of PENDING items per Banking each agent.
2) Correcting the following VBA string for proper formatting in the email:
in the Macro: ComposeEmailToBankingAgent

 

[OaklandJim]

I can't promise that I can do this but I'll try.

Pictures are not very helpful. If the data is not confidential hopefully you could post a link to your workbook. Put the file on Dropbox, Box, 1Drive, Google Drive etc. Use the link icon above the message area.

Or, consider sharing the data using Mr Excel's excellent XL2BB addin that enables you to post a portion of a worksheet. See XL2BB - Excel Range to BBCode for details.

So I am clear, you want to include the data table in an email message after filtering so only pending items are shown?

 

[OaklandJim]

I have some code but I need some help from you. Do you still need this?