Forum Discussion

GregGreg's avatar
GregGreg
Qrew Member
9 years ago

I want to send emails to a group of selected records. Email address is a field in the records. I could not find the answer by searching. Thanks. Greg

We have a database of prospects that we call.  Often, we are not able to call all of them.  I would like to select specific records and send an email to those records.  Email address is a field in the records.  We currently send emails to each record individually.  I would like to send the email to several selected records at once.

For example, if I choose all the records created today with address in the state of Georgia.  Send an email to all those records.

  • QuickBase is not really designed to be a mass emailing engine.  But there are solutions depending on what you are trying to do.

    For example, if you make a regular table report which has an email address, the bottom of the email column will have a blue envelope.  If you click hat it will load those email addresses into the TO box of your email client.

    Or are you looking to send out personalized emails with content from each record in the email?
    • SuryaExpert's avatar
      SuryaExpert
      Qrew Assistant Captain
      Dan, The link above takes me back to the home page. Is there an updated URL or something?
  • Thank you. This pretty much accomplishes what I want to do.  I have never attempted to code script for QB.  This solution is beyond my current skill set.  The volume of emails that I would like to send is relatively small <100 per day.  I can do them individually with not a lot of effort, but I prefer to automate the process.
  • Yes.  Thank you.  I would like to include a personalized message using the First Name and Last Name fields and maybe a couple of other fields.
  • Here is a typical native solution.  I can help you with the details of the elements or feel free to contact me directly via the information in my profile for personal assistance.

    Make a URL formula button which updates a date email sent field to the value of today and refreshes the page it's on. 

    The button would be like

    var text URL = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & ToText([record ID#])

    & "&_fid_XXX=" & ToText(Today()); // put in the field ID of  the date field here

    "javascript:" &
    "$.get('" & 
    $URL & 
    "',function(){" &
    "location.reload(true);" &
    "});" 
    & "void(0);"




    Then make any report you like, but include a filer where that date field is not equal today.

    Then make an email Notification  and trigger it to fire when the date field is changed.




     
  • Here is the other script you can use to send email to a list of email addresses:

    https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=431

    I hope you can sew these two pieces of code together on your own. I just got back from a conference so I am just following up my incomplete answers. If you need additional help ask a new question on the precise issue you need help with. Or if you want help doing the whole task feel free to contact me using the information in my profile.
  • Hi! Any update with mass sending of emails? Is there an easier way to send bulk emails without scripting? Thanks in advance.