Get List of Emails from Excel and Send Email to List
  • 12 Mar 2021
  • 1 Minute to read
  • Dark
    Light

Get List of Emails from Excel and Send Email to List

  • Dark
    Light

Article summary

Example Lab Article
While Example Lab projects are resources for public use, articles and assets are not actively maintained. Screenshots and features are from the specified version below. These references may become dated as new versions are released.


Overview

Example Lab Details

Version6.9.0
Root FolderExample Lab - Sending An Email To A List
Modules None
DependenciesNone

This Example Lab project provides and example of how to implement a mailing list from data stored in an Excel file.


Explanation

This Example Lab project has one Flow. This Flow takes in an Excel file in the format of XLSX. It adds the items in the email column to a list. This list has null items removed from it, in the event the Excel file has been edited and rows with no data are still are still included in the list. This list is then used with a Send Email Step on the BCC Input, allowing the email to be sent to multiple people without showing their email addresses to each other. Simulation behavior is used on Unit Tests, allowing the flow to be tested even if a mail server isn't present on the network. The Unit Tests also have files attached to them that can be downloaded and used to create new test files.

Reference Articles



Project Download

The examples attached were developed to be instructional and were not developed as officially supported components. For more information or to engage our service team to develop fully supported, production quality solutions, please contact services@decisions.com. Import the project below to a Decisions environment on version 6.9.0 or later using our Importing/Exporting article.





Was this article helpful?