Send Fully Dynamic Emails from Excel with a SINGLE FORMULA | No VBA Required!

Hello the session is just awesome,

Had one qts , what if I want to add many more name in cc the formula is not catching the data

Could you please help that how can I add more name in cc and also attachment

Thank you for helping me retrieve data from Excel, but it's a shame that the body has character limitations.

Hi Leila,

When selecting a cell that contains a date. it turns into numbers in the email. how can I fix it?? to show is a date in the email

Once I create the hyperlink, how do I add an automatic alert and send it via email?

Thanks for the tutorial
Is it possible to send the same email (subject & body) to multiple recipients (in a column) at once?

What a genious! It cannot perform all my task but at least a great porcentaje of it!! THANK YOUUU

Too bad this dont work on mac...

Is it possible to sena an Table as the Body of the email?

Hi leila, there is a limit of 255. What is the alternate or solution or this problem

Hi Can you tell how add the Signature along with Mail

How to add bold letters in the mail body ? Is there anything we can add it to formulae

"Try harder next month." is motivational?

Is there a limitation to number of characters we can put in the body cell.. I am trying to compose a little long email and it works fine however at one point Send email button turns into error when I exceed typing in the body cell

How to add Table in email through this formulae

After an order I want to send 3 mails, and want to mark if is is sent or need to send. With your function it calculate which email do you send. Maybe I need to use 3 different email sending colums, and 3 other to mark if is sent?

Hi Leila, I've been a long time follower, first time responder - I'm love this option, but seem to be running into a character limit, for both the subject and body fields. is there away around this? Thank you!

Amazing context - thank you for breaking this down - is there a way to auto send email templates from excel - like on a bi-weekly cadence?

This is great I didn’t know about this thanks.

Excellent!!! Good Job!!! That helps a lot, but how can I send the message automatically without pressing the cells?

With this function, the body of my email is limited to just a few lines. Is this something I can change?

how to send email for long text in the body ?

How can I set it up to where I can automatically send ALL those emails at once with a touch of one button?

The email body doesn't support long texts, but works fine for one-liners. Can you suggest a solution?

Just wow since yesterday i was having hard time to send multi email one by one, i wanna know how i can select the column first name of each cells and send one email then each contact gonna receive their first name at the email

Wish I had found this video this morning, after spending hours first doing it manually and then using power automate (which is a slick option too (does everything with one button press but lasts longer to set up))

Hi, When the body text is added the default signature disappears. How to solve that problem?

Trying same for multiple recipients and lengthy email body but its not supporting.

Hello,

I have a question. I am trying to utilize this formula to automate emails for contact issues for my company. One problem that is roadblocking me is I can't get my excel to link to my outlook to utilize when I click on the hyperlink. Any advise?

this is very good, yet I have issue, I think its not working on a bigger Body

Is it possible to send auto.atic email based off of a particular cell condition ? For instance whenever a value in cell is true or false.

Hi Mam, please help me for automatically email send with attachment through hyperlinks

i m having issues when i click hyperlink it opens chore. not outlook

Thanks for this wonderful tut. How to do it if you have multiple CC?

The video is great and very useful! thank you so much!

I think you should fire Gary

I get an error because of the 255 characters limit 😢

Salve come faccio a mettere un allegato nell email

Leila ... I guess I have to give my entire knowledge of Excel and MS Office applications credits to you only
Thank you so much for your efforts ...you have no idea how valuable this video is for me ...the task i am doing is so manual and tedious that I most probably procrastinate it until I am on fire
Really really thank you so so much Leila
May God bless you 🙏🏻

If I am inserting multiple cells of the XLS sheet in the body text it is showing error. Is there any limitations for the body text.

Is it possible to apply a timer to the Emails ? Say every 7 months for exemple it sends an Email. What would be the formula ?

How to write in body mail max 650 characters, when i am trying formula it's taking only 135 characters are taking .... if any one knows plz let me know the formula

When click on send email it takes me to internet site and not opening new outlook email 😔

Hello Leila, Thanks for this, it was really helpful :) is it possible to send it automatically when you click on the hyperlink, rather pressing send on the outlook app as well.

Is it possible to automatically send contents of a sheet to dynamic email when a criteria a satisfied?

How to mail Excel cells in table format

Hi Leila,

Would you have an idea on how to encrypt the email?

Thanks

Information is useful . How to add the specific cell value into the body.