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?