Form picks wrong email address

Form picks wrong email address

Good day,
I have created a form where external parties can enter data and in the bottom fill below two fields:

Send by: Pick email from drop-down
Cc Receipients: Pick email from multiple select

Then when submitting the form, same will be sent to predefined receipients, the sender (send by) in Cc, and then the defined Cc receipients.

The first, Send by works fine and when replying to the emails, the email will reply to the actual email address stated.
Howver, the Cc fields work in a strange way, as it picks a completely different email address from the database than the one specified.

Does anyonw have any idea what could be wrong>
My deluge code below:


Vessel_Record = Vessel[ID == input.Vessel] ;    
Terminal_Record = Terminal[ID == input.Terminal] ; 
Contacts_Record = Contacts[ID == input.Submitted_By] ; 
Cc_Record = ContactsID == input.Cc_Receipients

SendMail 
[ 
  From    : zoho.adminuserid
 
  To      : zoho.adminuserid
 
  Cc      : Contacts_Record.Email, Cc_Record.Email
 
  Reply to: Contacts_Record.Email
 
  Subject : Vessel_Record.Vessel + " arrived at " + Terminal_Record.Terminal_Code + " " + Arrival_Time
 
  Message : ""
 
  Attachments: template:Arrival_Report as Inline