Standalone Program to auto email message from excel data

I was wondering if it is possible to create a standalone program with the use of the MCR compiler to make an application that would send out different messages to different people depending on their server email (i.e. gmail, yahoo, etc.) I would be feeding in an excel data sheet with the names and email addresses to the program.

I understand that I could feed the excel in as a cell array and use their certain element positions and/or use a switch case to find what server they have to send the correct message. Or is there another route that I could take?

Answer 1

[Image Analyst]

I use sendmail to attach an Excel workbook to an email message and send it out. So the answer to your questions are "yes". Use readtable() to read in the Excel workbook with the email addresses in them (or xlsread() if you unfortunately don't have R2013b and have to use xlsread instead of readtable) then make up your email with from, to, subject line, body, any attachments, and send it out. It might or might not go out depending on what kind of security and firewall issues you run into.