Process Considerations:

• The query requires an Administrator  to enter Business Unit and Date.
• The "Query Result Set too Large" message will appear if query results are greater than 8,178.
• The full email message can be viewed on the Mail Retrieval Page.

Instructions

1.  Click Reporting Tools > Query > Query Viewer

2.  Enter  UW_BN_EMAIL into the search criteria and click Search.

3.  You are shown the Search Results below.  If you had done a partial search, multiple queries may appear in the list.  If you searched for the specific query you are looking for, you should only see that value below.  To view the query, click the link for Excel.

4.  A prompt window will open.  On that page, enter the Business Unit and Date Sent you want to run the report for.  You can also search for the Business Unit by clicking on the magnifying glass next to the field.  After you choose your business unit, click View Results.

5.  Open the query using Microsoft Excel and click OK or Open depending on your internet browser.

Below is an example of Mozilla Firefox.

Below is an example of Microsoft Edge.

Review the results.  Note:  An employee may appear on the report with multiple rows for separate email messages.

1. Empl ID = Employee's ID Number
2. Name = Employee's Name
3. Unit = Business Unit
4. Dept ID = Department ID Number
5. Date Sent = Date the email was sent
6. Email Address = Employee's email address
7. Email Subject = The email subject line

  The  following message will appear if query results are greater than 8,178.

Additional Resources

Related KBs:

• Mail Retrieval Page

Related Links:

• Annual Benefit Enrollment Communications
• Income Continuation Insurance Communications
• State Group Life Annual Update Communication
• Summer Prepay Communications