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.
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?
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.
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
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.
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.