I would like to automatically send an e-mail to remind club members that their subscription is due. Similar to conditional formatting of a cell, but conditional e-mailing.
—–
Wieland
MacMost Q&A Forum • View All Forum Questions • Ask a Question
Can a Spreadsheet Generate an E-mail?
Comments: 2 Responses to “Can a Spreadsheet Generate an E-mail?”
Comments Closed.
No, it can't automatically send an email since neither Excel, Numbers, Google Drive or whatever spreadsheet you are using (you don't mention it) isn't an email app.
You could probably create an AppleScript or Automator task to do such a thing, but it would be complex and I don't know what your programming skills are, or budget to hire a programmer.
It would be fairly easy, however, to use a formula to put the email addresses of users dates past a certain day into a column. So if column F is their due date and column E is their email address, you could have column G contain formulas that check to see if F is past a date, and then put a copy of E into G if so, and nothing if not. Then copy the values from the entire column G and paste into your email app's "from" field to send the email.
I haven't done it in a while but you should be able to do it with Microsoft Word and Microsoft Excel.
Use Microsoft Excel to create a spreadsheet list of people (column headers for "First Name", "Last Name", "Email Address", and other items in row 1 and individual entries start in row 2).
Use Microsoft Word to right a letter using mail merge functionality.
You can then use the letter to send emails.