Help with Google Scripts to send E-Mails

I have a Google Sheet that has information in it and I would like a script to automatically send Emails back that have a Gmail Label on them. The Google Sheet is used so it is easy to be updated easily and it would change the email that is auto sent. I tried using "[login to view URL]" it worked great but it seems like it would not send to anyone that did not have an @[login to view URL] email address. Please Help