I am trying to automate a Google Sheets document that will contain about 3000 rows in total.

The idea is to click on a hyperlink and have my Gmail inbox open with information from a few cells, and additionally, paste some Google Drive links that are in cells M2, R2, W2. The formula opens the email in a new window, copies all the texts, but the hyperlinks do not have the link.

Do you have any idea what I’m doing wrong?

=HIPERVINCULO( "https://mail.google.com/mail/?view=cm&tf=1&to=" & BUSCARV(Z2; EMAILS; 2; FALSO) & "&su=POP - LINE " & SUPPLIERS!A2 & " - " & SUPPLIERS!E2 & " - " & SUPPLIERS!B2 & "&body=Hola,%0A%0AEnvío el comprobante de pago%0A%0ALINE: " & SUPPLIERS!A2 & "%0AEVENT NAME: " & SUPPLIERS!B2 & "%0ASUPPLIER: " & SUPPLIERS!E2 & "%0A%0ALinks:%0A" & ENCODEURL(M2) & "%0A" & ENCODEURL(R2) & "%0A" & ENCODEURL(W2) & "%0A%0ASaludos."; "POP" )