Saved Search Email
You can use SuiteAnalytics Workbook to query your NetSuite data with the analytics data source, which gives you advanced query options. For more on SuiteAnalytics Workbook and how to recreate your saved searches as workbooks, see the following topics:
If you're an administrator or have the Create level of the Publish Search permission, you can enable system-generated email messages on the Email subtab of a saved search page. This function offers many options, such as:
-
Share search results with other users.
-
Schedule long-running searches for low usage times.
-
Alert targeted users about changes to their important records.
-
Perform drip marketing.
You can send saved search emails on a schedule, for record changes, or both. You can add multiple recipients for both types of email. Recipients can be indicated by user or group name, or use search results field values for it. With public searches, other users can get alerts too. Customize the email text and attach the results as .csv or .xls files.
CSV is the preferred format because it's the most compact.
Saved search emails use the owner's email address by default. You can set another default address as a preference, or customize the content for a saved search to define a different sender.
Because of email limitations, large search results are cut off before they are sent. Emails containing truncated results include a note about it. This happens if the email is over 5MB or has more than 10,000 rows. To include the maximum possible data, use CSV. Other formats cause email size to be larger.
Saved search emails are limited to 10,000 rows.
For more details, see the following:
Alerts and scheduled saved search emails are set up on the Email subtab. Recipients for both types are shared, so if you enable both of them, recipients get both emails. For more information, see Defining Recipients for Saved Search Email.