Skip to main content
Solved

Send email based on a list of email addresses in a spreadsheet?

  • November 13, 2023
  • 1 reply
  • 133 views
vxn43
Supporter
Forum|alt.badge.img+18

I have a workspace where I am using the Emailer Transformer.

 

What is the best way to send a single email based on reading a list of 5 email addresses in an Excel Spreadsheet? Would I still use the Emailer Transformer?

 

I am thinking there are parameters I need to change in the Emailer?

Best answer by david_r

You can use the Emailer and pass the list of recipients as a comma-separated list of email addresses (no spaces). You can e.g. use the Aggregator to join all the email addresses into a single, comma-separated string to pass onto the Emailer.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • Best Answer
  • November 13, 2023

You can use the Emailer and pass the list of recipients as a comma-separated list of email addresses (no spaces). You can e.g. use the Aggregator to join all the email addresses into a single, comma-separated string to pass onto the Emailer.

Community Stats

32,102
Posts
121,896
Replies
39,749
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.