What is your goal?
Send emails to multiple addresses based on Google Sheets multiple email address columns, some of which may be blank
What is the problem & what have you tried?
When the MS365 Send email runs, it works unless there are blank fields. If any column is blank, the entire module fails.
I’ve tried using an aggregator to create an Email Address array, but this kills my access to the google sheets Search Rows module to be able to write the email.
I need either a way to use the outlook module and be able to have it ignore blank emails, or i need a way to have the Search Rows data survive downstream after the aggregator runs.
Seems like it should be simple, but I’ve tried EVERYTHING i can imagine and everything always hits a brick wall.
Hello,
Welcome to the community!
Please share what your workflow looks like - the first idea that comes to my mind is simple- add a filter.
If the length of the email is <1, do not pass this bundle to the send email module.
Sample:
Welcome to the Make community!
Have you seen these previous discussions?
Your question may already have answers here:
You can search this forum for existing answers and the documentation in the Help Centre to get to a solution faster.
Still require assistance?
If the previous/related discussions are not similar to your question, please reply providing additional details to demonstrate the difference(s) between your question and the ones above.
If you require help understanding or implementing workarounds/solutions in the related discussions, please reply with more details of what you have tried, including screenshots.
— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
Thank you for your reply.
I have found the solution, so I am posting here for anyone else’s benefit.
For clarification, each record will have several email addresses in it, but some will have more than others. I needed a way to send the email to only addresses that are in the data, and when an email is blank, do not include in the send.
The solution is to start with an iterator, using the split function, then an aggregator array to create the array, then then is mapped into the outlook to field.
1 Like
