I want to send an email by extracting information from excel. The information will be displayed in email row by row. How can i do so? Information for column will be delimited by enter. What advanced commands can i use to extract this information. I have tried using the split command.

This is what I intend to send at the email format

Example:

Name: john

age: 21

email: john@gmail.com

what i got instead:

Name: john sarah

age: 21 22

email: john@gmail.com sarah@gmail.com

How do i fix this?