I am trying to build a flow where it checks for Inactive opportunities over seven days through Last Modified Date. The Get Record Element is followed by a Loop Element and then a E Mail is sent out for notifying the Inactive Opportunities. However when I choose the "After Last Item " in Loop connector to Email Action ,it doesn't send out any email although flow runs without error. It works if I choose "For Each item" but ends up sending many emails which I want to avoid . How do I create a flow to send out only one Email at the end of process with cumulative information and not 40+ emails!screenshot of the flow below

  • 1
    If you only want to send one email you will need to either iterate over all of your records, grab relevant information from each, and store them in a collection variable to be used in your email. Flows are, IMO, not a great tool for this because this approach is cumbersome and the email action is very limited. You may consider using a Visualforce email template instead where you have a lot more control over the formatting.
    – nbrown
    Apr 5, 2021 at 14:33
  • Thanks @nbrown! Will try that route out.
    – Bubbles
    Apr 7, 2021 at 3:36

1 Answer 1


I used to use an unofficial email component that gives you a lot of flexibility. You are able to send emails to a csv string or a collection of email addresses. You can still use this component, but it is not the only solution out there. Send rich text email action does the same trick. Check here: https://help.salesforce.com/articleView?id=release-notes.rn_forcecom_flow_fbuilder_send_rich_emails.htm&release=230&type=5

Either collect all the email addresses by adding them to a collection or append them to a string adding a comma before every value.

P.S. No, you don't need to do Visualforce.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.