Hello,

I have problems changing my current code to make B1, E1, H1 and K1 into a selectable cell to call Send_The_Email. It works fine on the sheet "Original Code" (vertically).
Problem is that B1, E1, H1 and K1 are clickable, but they all use the values of Client 1 (B1) instead of E1, H1 and K1 for client 2, client 3 and client 4 respectively.

Adding workbook : email_test_horizontally.xlsm

I am sure its something small, but I can't figure it out.

Thank you.