Standalone Program to auto email message from excel data

2 views (last 30 days)
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?

Accepted Answer

Image Analyst
Image Analyst on 1 Mar 2014
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.

More Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!