Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I use Google Apps email to send out details of a product I sell to people who enquire about it via a web form.

After a month or so I go through my Sent Mail folder and send a follow up email to all those I haven't heard off. Each email is the same except for the person's name in the greeting.

So in summary, periodically I need to send the same email to recipients in my Sent Mail folder that meet certain criteria: I emailed them in the past 2 months, the subject of the email was "My Super Product", I haven't had a reply off them since my last email.

Is there any tool available that can do this automatically?

share|improve this question

migrated from superuser.com Sep 21 '12 at 14:44

This question came from our site for computer enthusiasts and power users.

add comment

3 Answers 3

up vote 6 down vote accepted

Gmail filters only act on messages when they arrive. There's not a way to do what you want with filters.

For a pure Gmail solution, you can accomplish almost what you want by judicious use of search and the Canned Responses Lab. That will make sending identical messages to a bunch of people relatively easy.

Another option would be to use some third-party tool. You can get your email via POP3 or IMAP, so virtually any desktop email client can get your messages. There are probably tools out there that will allow you to do what you're looking for. (That's outside the ken of WebApps, though.)

Alternatively, what you really need is a Customer Relationship Management (CRM) solution. Salesforce.com and its ilk probably already have the tools that you want.

share|improve this answer
add comment

You should try Boomerang, I think it will do what you want

Schedule an email to be sent later. Easy email reminders.
Boomerang for Gmail is a Firefox / Chrome plugin that lets you take control of when you send and receive email messages.

share|improve this answer
    
Could you expand on that a little? In what way? –  Al E. Sep 22 '12 at 3:17
add comment

Modified the sample code in GmailApps a little. Spreadsheet contains, Name, email, date (m/d/yyyy), text. worked fine for me.

function sendEmails() {
  var sheet = SpreadsheetApp.getActiveSheet();
  //var mSheet = sheet.getSheets()[0];

  var startRow = 2;  // First row of data to process
  var numRows = sheet.getLastRow()-1;   // Gets last number of rows to process
  //Logger.log(sheet.getLastRow());
  var tDate = new Date();
  var tFormat = tDate.getMonth()+1 + "/" + tDate.getDate() + "/" + tDate.getYear();

  // Fetch the range of cells A2:D2
  var dataRange = sheet.getRange(startRow, 1, numRows, 4)
  // Fetch values for each row in the Range.
  var data = dataRange.getValues();
  for (i in data) {
    var row = data[i];
    var emailAddress = row[1];  // Second column
    var message = "Dear " + row[0] + ", \n\n" + row[3] + "\n\nCheers";       // Fourth column
    var dFormat = row[2].getMonth()+1 + "/" + row[2].getDate() + "/" + row[2].getYear();
    if (dFormat == tFormat){
      var subject = "Hi";
      MailApp.sendEmail(emailAddress, subject, message);
    }
  }
}
share|improve this answer
1  
The OP is specifically asking about Gmail. Your solution appears to use data stored in a Google Spreadsheet? Can this directly reference Gmail instead? –  w3d Nov 8 '13 at 14:33
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.