How can I send a mail to a person with multiple addresses in a cell

[Victory_Tasktide]

What is your goal?

I want it to send mails to all email addresses provided in a cell

What is the problem & what have you tried?

When I run the scenario, it works perfectly but skips the cells with more than one email address. I’ve tried to use the split function as I split the mails in the spreadsheet using “,” and “/“ still to no avail

Screenshots (scenario flow, module settings, errors)

[Karmic]

Please upload a screenshot of your Gmail module. Thanks!

[Victory_Tasktide]

[Karmic]

Toogle Map “ON” (the opposite side of To*). Then delete 10. Value in the field.
Insert this expression: {{ split({{10.Value}}; “,”) }}

It’d be helpful if you can show me how your sheet looks like as well.

[Victory_Tasktide]

Okay, let me try that and show you as well

Here’s a sample of the sheet

[Victory_Tasktide]

I can’t save it, I’ve been clicking save but it doesn’t want to

What could be wrong

[Victory_Tasktide]

It’s saved now and I ran the scenario still same error

It was an indentation error or space

[Karmic]

Remove {{ }} outside split. No {{ }} in 10.Value as well.
Only split({{10.Value}}; “,”)

[Victory_Tasktide]

Hello, is this what you mean?

[Karmic]

Yes. You’re good to go! Let me know how it goes.

[Victory_Tasktide]

Hello, still same error message and if I ignore it would skip all the ones with multiple addresses and just continue running the single ones

[Karmic]

You’re mapping the email addresses from where again? Show me the output where your emails come from.

[Donald_Mitchell]

In your To: field, remove the double quotes around the comma and remove any spaces before or after the comma. Make treats quotes as literal and doesn’t automatically trim spaces in this case.

[samliew]

How to Take Proper Screenshots

Please do not use your phone to take a photograph of your screen, as it makes it harder to read!

• Microsoft Windows: Take screenshots using the “Windows Snipping Tool”, by pressing either PrtSc or WinShiftS keys on your keyboard.
• MacOS: Take screenshots by pressing CommandShift4 keys on your keyboard.

Thanks!

[Victory_Tasktide]

[Victory_Tasktide]

Like this?

[Victory_Tasktide]

still same error

[samliew]

Using only the split function directly in this field is incorrect advice.

Also, you are using functions incorrectly in the Set Variable module. Looks like you pasted something from AI, which will not work in Make. Delete this.

Also, you do NOT need an iterator module, as the Sheets Module already outputs one bundle per result. Delete this.

Do this instead:

{{split(replace(1.`4`; "/\s*[,;\n\r]+\s*/g"; newline); newline)}}

^{(copy-paste the entire line above into the field exactly as shown)}

Hope this helps! If you are still having trouble, please provide more details.

I’d recommend going through the Make Academy if you haven’t yet!

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Learn Make

• Help Centre | Tutorials – Make’s “manual” - search for help here first
• Make Academy – Basics 101: Learn Make properly to get your money’s worth
• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

How-Tos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Aggregate an array for mapping complex fields
• Getting started with OpenAI - How to setup and use OpenAI in Make
• Text Parser module - Use pattern matching to extract the text you want
• Webhooks – Make Academy - tutorial on how to use Webhooks

— @samliew