Forum Discussion
- QuickBaseCoachDQrew CaptainQuickBase 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? - _anomDiebolt_Qrew EliteYou can do it with script. My answer in this post gives you an example of selecting records from a report to process:
https://quickbase-community.intuit.com/questions/1280505-how-to-process-selected-records
Also in the pastie database there is a code fragment that will send email to a list of email addys. I am on a tablet now and cannot convent ly search for this pastie at this time.- SuryaExpertQrew Assistant CaptainDan, The link above takes me back to the home page. Is there an updated URL or something?
- GregGregQrew MemberThank 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.
- GregGregQrew MemberYes. 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.
- QuickBaseCoachDQrew CaptainHere 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.
- _anomDiebolt_Qrew EliteHere 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. - ange1oange1oQrew Member
Hi! Any update with mass sending of emails? Is there an easier way to send bulk emails without scripting? Thanks in advance.
- QuickBaseCoachDQrew CaptainMy first post answers that question. Or perhaps you can explain your use case.