MacMost Q&A Forum • View All Forum QuestionsAsk a Question

Can a Spreadsheet Generate an E-mail?

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.

Comments: 2 Responses to “Can a Spreadsheet Generate an E-mail?”

    3 years ago

    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.

    Douglas Brace
    3 years ago

    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.

Comments Closed.