Error while using Hyperlink and Vlookup

Hello! I am attempting to create a hyperlink that sends mail to a person depending on multiple variables. Everything works well, but it fails when there are more than 4 values that are pulled from the vlookups to incude in the body of the email. This is a problem because I have a very large table that needs data to be pulled from many spots in order for the correct email body to be sent. I have attached my formula for generating the email by clicking. Also - I have tried using a vlookup with multiple return columns as an array formula, but that seems to only print out to multiple cells, rather than keeping it all in one cell - and in this case printing them all to an email.

=HYPERLINK("mailto:" & $L4 & "?subject=360 Reviews" & "&body=Hello,%0A%0AYou have been chosen to be a 360 Reviewer for the following employee(s):%0A%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,2,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,3,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,4,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,5,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,6,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,7,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,8,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,9,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,10,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,11,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,12,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,13,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,14,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,15,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,16,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,17,FALSE)&"%0A"&VLOOKUP($K4,UniqueListTranspose!$A$2:$DH$420,18,FALSE), "Generate Email")

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)