Imagine that you run a shoe store. Due to an inventory overflow, all oversize galoshes are on sale. So, you want to send an email to your customers who have size 11 and larger feet to let them know. You create a report that lists them all, but how can you send an email to all those people? If your report features an Email Address type field, you can do it in one click.
Create or display the report that includes all the email addresses you want to contact.
Click the envelope icon at the bottom of the Email Address column in the report. Quick Base launches your email program (Microsoft Outlook, for example) and generates a new message to all the email addresses in that column.
If you don't see this icon at the bottom of the report, you'll need to configure the field to display it. (See the section below.)
Note: The envelope icon is a "mailto" link. Depending upon which browser you're using, there's probably a limit on how many email addresses that a mailto link can handle. For example, Internet Explorer does not pass more than 100 email addresses at a time. This limitation is not controlled by Quick Base, but by your browser and email program.
Quick Base generates email addresses in the format used by Microsoft Outlook. This format works with most email programs, but there's a chance that it may not work with yours. If you run into one of these limitations with your software, try a quick workaround: Export the list of addresses to a .csv file and paste them into your email program.
If you don't already have a field of type Email Address in your table, create one. Then follow these steps:
Open the table you want to customize from the Table bar, click SETTINGS in the Page bar, then click Fields.
Click the name of the field to open its properties page.
Make sure that this field is of type Email Address. If it's not, complete the following steps:
Click the Change Type link to the right of the field type, then set the type to Email address.
In the Email field options section, select the Email all checkbox.
If your table has a regular User field but no Email Address field, you can still use this feature. There's no need to manually type in all those email addresses.
Create a new field and make its type Formula - Email address.
Click the name of the field to edit its properties.
In the formula field, type in the formula usertoemail([customer]).
This formula tells Quick Base to replace the user in the Customer field with the user's email address.
Replace "customer" with the name of your User field. You must use a regular User field. You cannot use a List - User field here.
Use the procedure detailed above to email the set of addresses in your new formula field.
© 1999-2018 QuickBase, Inc. All rights reserved. Legal Notices.