Sending Transaction Email in Bulk

Bulk transaction email can be generated from scriptable templates and can include attachments. Sending transaction email in bulk is useful if, for example, you want to send reminder email for multiple transactions for which payments have not been received. You enter search criteria to generate a list of transactions and then select which transactions you want to send email for.

To send transaction email in bulk:

  1. Go to Lists > Mass Update > Mass Updates.

  2. Click Transactions to expand the mass update options.

  3. Click Bulk Email.

    The Mass Update page opens.

  4. On the Criteria subtab, define the transactions you want to send email for using the Filter dropdown list. For example, you can create a list of all unpaid invoices by doing the following:

    1. Select Type in the Filter column.

    2. In the popup window, select Invoice, and click Set.

    3. In the next row, select Status in the Filter column.

    4. In the popup window, select Invoice:Open, and click Set.

  5. On the Recipients subtab, select which email address to use and the order in which the email fields are searched.

    For example, in the screenshot below NetSuite first searches for an email address in the transaction record. If none is found, NetSuite searches for an email address in the customer record. If none is found, the email address in the contact record is used.

    Recipients subtab

    Transaction Email refers to the email field that appears on the Communication subtab of a transaction such as a sales order.

    Customer Email refers to the email field on the main Customer record page.

    Contact Email refers to the email address related to the named contact within the company.

  6. On the Message subtab of the Mass Update form, select the scriptable template to use or enter the text for the message in the Message field. Templates can be up to 4 MB in size.

  7. Do one of the following:

    • Click Preview to view a list of transactions that match your search criteria.

    • Click Save to save this mass update to use later.

    When you click Preview, the Mass Update Preview Results page opens with a list of the transactions that match your criteria.

  8. In the Apply column check the transactions for which to send email.

  9. Click Perform Update.

    A status page opens that displays progress and completion information.

Creating a Sent Log for Transaction Email

You can keep track of what email has been sent to a particular entity by looking at the log found in the Communication > Messages subtab of that record. You can also view a log of all recently sent transaction email messages by creating a simple saved search. For example, you might want to check that a bulk mailing of invoices was successfully delivered to their recipients.

To create a sent log for bulk transaction email:

  1. Go to Lists > Search > Saved Searches > New.

  2. Select Message.

  3. Selecting items from the Filter dropdown list, add the following:

    1. Date – Specify the required date range for the search.

    2. Subject – Add any text which the transaction email is likely to contain in the subject header, for example “invoice”.

    3. Attachment Fields – Select File Type and specify what type of file was attached to the transaction mail, for example PDF.

  4. Click the Preview button to check the search returns the expected results.

  5. Add a Search Title and check the Public box if you want to make this search available to other users.

  6. Click Save.

Related Topics

Emailing Transactions
Preferred Transaction Delivery on Customer and Vendor Records
Printing Checks and Other Transactions

General Notices