Skip to main content

Customer Quick Report Email - Knowledgebase / Automation Agent / Miscellaneous - Cavallo Technical Support

Customer Quick Report Email

Authors list

Overview

This documentation goes over the configuration of the Customer Quick Report Email platform in Automation Agent.


To create a new Customer Quick Report Email automation, select the Automations tab on the ribbon and then Automation Lookup. Click the New Automation button, enter the name of the automation, and select the Customer Quick Report Email platform. Click the OK button to create the automation.


IcKApdS3U00DMErHExGvdbUZbRjYbyWY.png?access_token=snx3r3-jmfegpmwwo-55b5cb7e8d111ecb8a2463d16710f1e297e27284


For more information on how to create automations, please refer to the Automation Agent documentation.


Settings

Once the Customer Quick Report Email automation has been created, select the Settings tab to view available settings.


XY9FwqGYPlVxnLZINgX4uvb2aNmPLRSZ.png?access_token=snx3r5-etfnymfswt-1fca11b423819bbd6ea02ad91e4a395292f49919

Required Settings


Email Field - Customer address email field that contains the email address to which the email will be sent. Defaults to ‘Email’.


Email Template - The email template that will be used for the email subject and body.


From Email - Required Email Address to send email through the Email Server. The Email Server User must have access to this email.


Quick Report - The quick report that will be sent when the automation is run.

Email Options


Email Attachment Name - Optional name to specify for the name of the attached Excel (.xlsx) report. If left blank, this will default to the name of the quick report.


Email BCC Field - Customer address email field that contains the email address to which the blind carbon copy (BCC) email will be sent.


Email CC Field - Customer address email field that contains the email address to which the carbon copy (CC) email will be sent.


From Name - Optional display name. If left blank, the mail server will use the default stored on the server itself.

Body Options


Send As HTML - If enabled, the email body will be formatted in HTML. Defaults to false.

Filters


Contact Email Address Type - Specifies the contact address type to be used when the automation runs. Defaults to ‘Primary’.


Contact Matching - Specifies the customer address matching logic to be used when the automation runs.


SMTP Setup

You can use the SMTP Setup screen to configure email for each system user. To access the SMTP Setup screen, go to Modules -> Setup / Utilities -> SMTP Setup. Make sure each field is populated and click OK to save your changes.


xyEM4awfrXZ4gkER4fznStOP6zikunKu.png?access_token=snx3r1-mvzakevwez-b4d9d17af33741f8d6121e9ff69c6387c2ff2edc


For more information on the SMTP Setup screen, please refer to the SMTP Setup documentation.


Contact Filters

Customer addresses to which an email will be sent can be filtered using the contact email address type or more advanced contact matching.


Contact Email Address Type


You can select which customer addresses an email will be sent by specifying the address type. For example, to only send email to the primary billing address, you would select the ‘PrimaryBilling’ option.


Available options are:

  • None

  • Primary

  • PrimaryShipping

  • PrimaryBilling

  • PrimaryStatement


Note: Selecting the ‘None’ option will send email to all available customer addresses.


Contact Matching


The more advanced way to filter customer addresses is with contact matching. Contact matching provides a powerful editor that allows you to specify the exact filtering parameters.


Important points to keep in mind when using contact matching:

  • Contact matching works in conjunction with the contact email address type (if set).

  • Contact matching editor allows only one priority tier. Changing the priority has no effect on how the search clause is built.

  • The Expression column value must be wrapped in single quotation marks to prevent undesired behavior. For example, if the expression for customer number is set to 0001 instead of ‘0001’, it will be evaluated as 1 and produce no results.

  • If there are single quotation marks as part of the expression, they will need to be escaped by using double single quotation marks. For example, the correct expression for O’Reilly would be ‘O’’Reilly’.

Example 1


Use case: Send email to Aaron Fitz Electrical (AARONFIT0001) customer addresses only.


Solution:


5vuepaaAxX9DaFCVbitlT6JCQW3LdHIW.png?access_token=snx3r4-tzbsnmiryw-b664412ccff30427ac24e70d3172443c40b4000d


Example 2


Use case: Send email to Aaron Fitz Electrical (AARONFIT0001) and Adam Park Resort (ADAMPARK0001) customer addresses only.


Solution 1:


itBVgcLbkzrYb42ld0vXplte91Smst0f.png?access_token=snx3ra-ypwrnzrpkk-aee7cba5017fa2eab61db4765f5dea7a605e407b


Solution 2:


zg6MHRUAWJ9st2ScVTOnBLGWoRY3u3aV.png?access_token=snx3r5-etbuwwibdy-38e9739ff5c27d3f4506ce3d899330f5984ed2f2


Example 3


Use case: Send email for all customer addresses where the Email field is not blank.


Solution:


rMeVM4a6vPanaGE2fzONTaWVecPvfbDJ.png?access_token=snx3r4-vkwtkqxdqa-1af39613e6fe4adc9f6536f7fc20e15587a14a29



Email Templates

The Email Template Editor screen can be used to create email templates that will be used when generating emails. To access the Email Template Editor, go to Modules -> Setup / Utilities -> Email Template Editor.


Supported template types are:

  • CUSTOMER

  • CUSTOMER_ADDRESS


lgp6FwYGn7xo98eaFauK0uDCqo5IPEHq.png?access_token=snx3r3-pgtdhrmrxt-9376b266ebb7d1b6b48b808cc965aadf979393c8


For more information on how to create an email template, please refer to the Emailing and Email Templates documentation.


Quick Reports

In order to email a quick report, the report must have a customer number search field. To create a new quick report using the Quick Report Editor, go to Modules -> Reporting -> Quick Reports, select the Reports tab, and click the New button.


Valid customer number search fields are:

  • Customer_Num

  • CUSTNMBR

  • Customer_Number



MKLKWjQG0aLvGgJFsHH2xjkoilhDNA3U.png?access_token=snx3r7-xkqnjbooof-01677a8e4f11747b7879fb0c826064f67f033ef7


If a quick report is configured as a printed report, it will be sent as a PDF document instead of an Excel spreadsheet. To configure a quick report as a printed report in the Quick Report Editor, set the Report ID and Report Name fields to an existing printed report.


ePN37D6XkvsYisBcWGt4oNI6P4qZ9MHv.png?access_token=snx3r4-uxfeiljcmw-ebde1163845d10f528c5db25bfcfe5f968d3604a


For more information on how to create quick reports, please refer to the Quick Report Editor documentation.


Helpful Unhelpful