Grab the file I used in the video from here 👉 pages.xelplus.com/send-email-excel-file

@akshaymandavkar190

3 ай бұрын

@LeilaGharani Can you help me with on doubt? In my formula description value is displaying very limited in email...for eg. If description in column is 250 words then in email it only limit to certain range like 50 or 100 or 150 and if it goes beyond it then it gives #value! Error...then i need add a formula to restrict upto 50 words to avoid erroe with below formula : &body="substitute($AH$309730&Left(H2,50).... So above formula is not avoid value error to keeping H2,50, if i type H2,51 then it will throw error..😮so with this formula i giving command to only display 50charater to display so i wont get error

My best Excel tutor. Thanks for all the videos you have made on Excel, following your tios and examples has made me better at work. I love your works..

Just when I thought Excel couldn’t get more awesome, you took it to the next level. Leila, you are the Best!!

@LeilaGharani

4 жыл бұрын

I'm happy to hear that :)

@solidejison4500

3 жыл бұрын

@@LeilaGharani hi , how can i create mail .

@mohammadsalmanuddin6951

Жыл бұрын

@leila How to add multiple recipients in "to"

@mohammadsalmanuddin6951

Жыл бұрын

​@@LeilaGharani please answer

I have went through few videos of information on using formulas in Excel and it was really excellent, you cover each and every point and you start from the scratch so that everyone can easily understand. I learnt many things watching those videos and it is helping alot in my day to day work. Hope we get more information on Excel and accounting topics from you. Thanks alot Leila 😊

@LeilaGharani

4 жыл бұрын

Glad you like the teaching style :)

Wow! This is fantastic. I am working on excel everyday in office but never realised that there is possobility for this. Thanks a million for sharing this wonderful way of using excel.

This is really informative. It will be much more beneficial if you can show other variations like adding a table, formatting text and sending email from a specific account

Oh God - and all these years i was using hyperlink just to switch in between worksheets. Excel is cool but only when the teacher is Leila. Thanks much for this. :)

simply say love you leila the way you explain subject...great Leila, God bless you

Hi Leila, thank you so much for this video. It offers so many new possibilities for my daily work.

Leila, you really hit a home run with this one - you could probably do a follow-up video on all the possible applications of the technique. Thank you once again!

@LeilaGharani

4 жыл бұрын

Glad you like it Robert. Yes, maybe I'll do a follow-up.

Regarding attachments: You can add the link to the file in your body text. To be able to add the actual file as an attachment you can use VBA. If you're in my VBA course, check out sections 15 & 18 (to attach any PDF document). I'll add this topic to my list of future videos for KZread as well. Regarding multiple email addresses: You can add these to the same cell and separate them with a semicolon ;

@ilhanaksu1903

4 жыл бұрын

can we .ore people to to or cc ?

@SUDHIRKUMAR-cr9zs

4 жыл бұрын

Thanks leila for reply

@roxiserban

4 жыл бұрын

Can you do one how do you send the emails automatic not one by one. ? Is great but still you click individually Thanks

@ilhanaksu1903

4 жыл бұрын

@@roxiserban what do you say i didnt ustand

@arslananwar6241

4 жыл бұрын

Great Video. Appreciated. Can charts from excel be pasted (as pictures) in email body using hyperlink?

Again a great video Ms. Leila. I was looking for something for a long time. Thank you so much

This has blown my mind Leila...you are awesome

My 1st impression was "Wow, so this exists in Excel?" Thank you very much Leila for making a video on this. Very impressive

@LeilaGharani

4 жыл бұрын

Thank you Shadrack.

@syedferoz7443

3 жыл бұрын

@@LeilaGharani...it is mostly useful at my work..could you please help me in adding excel cells tooo...if you can do that

"%0A" is the gem in this video.

@thalesnemo2841

3 жыл бұрын

How would one find this out otherwise?

@matthewzarembski2063

3 жыл бұрын

Great work Leila, thank you for the %OA!

@celestedavid7364

2 жыл бұрын

Do it 2x (%0A%0A) to make it as a paragraph 😀 instead of just a sentence.

@harishsharma2675

Жыл бұрын

Hi Everyone....I want to add 5 lines in the body but unable to and 5 line ..when I am addinf amall data its wirking but not for much data...can anyone help me

You are the best! Thank you for making this complicated excel functionality so easy...

Excellent tutorial as always Leila, thank you!!

Great tutorial as always, Leila! I worked at a company that had a "click to email" cell like this and I'm sure it used a lot of what you mentioned. However, it also included graphs as part of the email. Is there a VBA-less way of doing that?

Hi Leila, great video ! is it possible to include an email signature when using this technique? as in you set up the email to include a signature you have on outlook - or would you need to use VBA to do this?

Leila, you are fantastic! Thank you very much!🌸🦋👍👍👍

Holy cow, that was some advanced trick! Never knew this. Excel is so powerful, thanks for teaching!

Hello Leila. This is a wonderful video. Very helpful indeed. I would just like to ask. Is there a limit on the number of email addresses in the "To" and "CC" fields. Seems as if I'm getting an error (#value) if i'm adding multiple email addresses (more than 3 or 4 email addresses). More power to you and I hope you continue sharing such wonderful tutorials.

Amazing. Just love it. Is there is any way of adding attachment dynamically ? It will be a great help.

@waterresourcecivilengineeringa

3 жыл бұрын

#Waterresourcecivilengineeringandresearch

@abeersallam6564

2 жыл бұрын

@@waterresourcecivilengineeringa this is not helping what Sajjad asked!!

Been watching your videos for a while, even new tasks I can find a video. Thanks!

This is super duper awesome Leila.. just love it!!

Hey, great tutorial. Is there a way where you can record a response when a user sends an email (or decides not to) ?

This is AWESOME! Question - how do I automatically add my e-mail signature to this e-mail? Short of a lengthy explanation, this will make may day to day life so much easier, with or without the e-mail signature!

As one of the Mac Guru's in the 80's I was given beta copies of all of Excel software since Excel 1 so I have a very thorough knowledge since the very beginning. I sent my recommendations of all the beta's I received and some of them even got into the finished production of many of the Excel software updates. I enjoyed your video. It was very thorough and precise and moved at a good pace. Kudos for a fine job. Hoping to see more of these...

@LeilaGharani

3 жыл бұрын

Many thanks for the kind feedback, Jesse!

just started learning excel, what a great reference material! thank you very much.

The character code %0A use in the subject, is there a list where i can find every single character code that i can use in subject?

Is there a way I can attach a document to the email also.

You are too amazing. Thank you very much for sharing your knowledge to the world and especially me. You made me feel more values about the knowledge of education

Really I was a great video and absolutely helpful. Requesting you to make more videos which are such helpful.

Love this! Is there a way to just click one button and then it sends all the emails instead of clicking "Send Email" individually?

@wakelingchicken

4 жыл бұрын

Sounds like you need VBA for that and you will have to code SMTP send commands

@tariq912ahmed

4 жыл бұрын

Did you get this option, could you please send me if so

@thomasmeier8553

3 жыл бұрын

I'm also after a similar solution. We have a listing of shipping dates and these do change. The ideal solution sends out an email with dynamic content of product, old shipping date and new shipping date to an email address in the background

@JohnGagnepain

2 жыл бұрын

I'm guessing you found a solution to this by now, but I'd use the Mail Merge feature in Word to send all those emails rather than the process described in the video. We use Mail Merge to send emails to larger groups of people. Set it all up in Excel and then use Word to send everything. This also avoids the character limit you run into in Excel.

Hi and thanks for amazing video! Is there any option of including the data from 2 different cells into subject? For example: I have data in cells A1 and B1 and i want to see both of them in the subject?

@nisemapi

Жыл бұрын

You can combine them in a third cell and reference that instead, or you can add them both to the formula.

@fernsehdesign

2 ай бұрын

@@nisemapi late but stilll valid (just tested) =HYPERLINK("mailto:" &C2 & "?subject=" &F2 &G2 &H2," send email ") C2 being the emailaddress, F2 and G2 the parts that you want to combine. No need to combine them into another cell first.

Outstanding work,LG

Appreciate, sharing knowledge with people, who struggle with their daily work.

Awesome! Implemented already. BUT how do I get my email signature to show in the email automatically?

@rldb

4 жыл бұрын

If you want the signature in the mail, don't use any body in the formula. I think whatever is passed through the *body* parameter supersedes the Outlook setup and hence the signature is not included. It would be a trade-off between insert the signature manually or type the body manually.

@solidejison4500

3 жыл бұрын

pls who can tech me how to make email

Can we also automate sending each of these customised emails? Clicking each cell would become cumbersome and we'll have to go for mail merge then?

@ryannoe86

4 жыл бұрын

Vivek S. Narayan I see no one responded yet but have you found a solution on your own that you’d be willing to share?

@gareth6326

4 жыл бұрын

@@ryannoe86 The common way is to create the email and the use hot keys to simulate pressing send (when I have tried this it failed a lot) Another method that I came up with, was instead of excel trying to send the email, it just saves it in Outlooks draft box with a subject line that starts with a string that you would never use for anything else e.g "XYZ123" Then you have a second macro, in Outlook, that is triggered when a new email is saved - and this macro searches the draft box for emails with subjects beginning with "XYZ123" and sends them.

@ryannoe86

4 жыл бұрын

@@gareth6326 That's interesting that you use hot keys. I use AutoHotKeys to send out emails now but I know it isn't the best way of getting it done. I'd like to get it sorted in VBA and Excel if possible. Thanks for the reply!

@gareth6326

4 жыл бұрын

@@ryannoe86 I don't use hot keys, I was just saying that is the common method. When sending emails in excel in use the second method. The easiest way to automate sending an email is to use .NET instead of excel.

@BobbyBlue1905

4 жыл бұрын

I recommend Mail Merge feature of MS Office. Works like a charm, every time. MS Word, MS Excel and MS Outlook come together in harmony to send emails. If you combine the excel possibilities, you can only imagine how good this feature is.

Of Course!... it makes so much sense, but even I had never thought of this ... always done it with a tonne of code! Thanks Leila, instant fave and I am sharing this with my two Excel Guru workmates!

@LeilaGharani

4 жыл бұрын

My pleasure. Hope your workmates will like it too.

Thank you Leila! I'm gonna watch this over and over

@LeilaGharani

4 жыл бұрын

My pleasure Shola :)

Whenever I add the body text my signature disappears from the email. Is there a way to add the signature through the hyperlink function, or should I just manually add it each time? Additionally, is there a way to mark the email as "High Importance" through the hyperlink function? Thank you for these videos, I thought I was good at excel but watching your videos I have learned a lot!!

Hi Leila, is it possible to expand this method into adding tables, or font formatting onto Outlook dynamically?

@alyonakurilina8880

2 жыл бұрын

That was my qtn too. We are in excel so 90% chance would be a requirement to include table into the email. @Leila help😊

@nitinkhtri7936

2 жыл бұрын

Have you got this how can add table in mail automatically

WOW! This is amazing. I never even knew this could be done in Excel. Thanks Leila.

@LeilaGharani

4 жыл бұрын

My pleasure. Glad you like it.

Thank you so~ much. Your video is the top as usual.

If the email body text needs multiple cell like B2:E12 will it work?

@mohamedelmoslmany

4 жыл бұрын

#VALUE

@Write2pranab

3 жыл бұрын

Up to three cells, use "&" or "concatenate" function

How do we overcome the character limit (value)error in hyperlink. It’s when we create for a email and the body is more than 256 characters in length. Can you please suggest a solution. Thanks.

@alexfisse547

4 жыл бұрын

Ever figure anything out?

@vibhanshuarora3378

3 жыл бұрын

Did you find any workaround to fix (value) error in HyperLink?

@myyoutube3629

3 жыл бұрын

Hi Leyla! Do you have solution for this?

@rahuladdanki

3 жыл бұрын

255 is the max limit no workaround I believe, the only alternative I see is using a VBA.

@kasinkelly

4 ай бұрын

Same issue here. I came to this as a work around for VBA and now need a different work around again

Thanks Leila. You are so helpful. I am learning a lot from you.

You are wonderful...with yours formulas in the Excel.

Nice excel tips! I am using excel 2019 and somehow it acts funny. I used the simple form of hyperlink function just to send email =Hyperlink("mailto:"&B4,"send email) the first time i used it it has opened outlook but the second time and on it just opens a empty web page. Any ideas?

@PremKumar-ef9mm

4 жыл бұрын

Change the Default Browser to Outlook.

@aytanothman5456

3 жыл бұрын

@@PremKumar-ef9mm i have the same problem Please more information

@mohammadsalmanuddin6951

2 жыл бұрын

@@PremKumar-ef9mm how?

@aideemanzano4559

2 жыл бұрын

I have the same problem

Thanks, this was helpful, it doesn't want you to exceed the 255 character though. Is there a solution around it?

@bryanlacorte4978

2 жыл бұрын

Same problem

@adinaotrocol6134

2 жыл бұрын

Same problem, is there a solution?

Amazing! Thank you so much for this helpful tip :-)

Very simple solution. Thank you so much!

Great :-) How to add a range of cells in body text (say from range l6:m15)? It wd be gr8 if you make a complete video on adding attachment, picture etc... Kumar V

@thiago713

4 жыл бұрын

Yesssssss!!!!

@LeilaGharani

4 жыл бұрын

Please see pinned comment.

Can we add attachment

@surajdabhade9022

4 жыл бұрын

How we can add attachment

@golfdelta790

4 жыл бұрын

@@surajdabhade9022 agree how to add an attachment

@suzannegriswold7555

4 жыл бұрын

Just guessing but I wonder test the syntax &attachment="fullfilepathnamewithfiletype" referencing the path in a cell like the other attributes...

@LeilaGharani

4 жыл бұрын

Please check the pinned comment above.

@maerskhm6701

4 жыл бұрын

@@suzannegriswold7555 Pls write complete formula....

Awesome Leila. Thank you.

Brilliantly explained! Step-by-step and in logical sequence! Thanks!

@LeilaGharani

4 жыл бұрын

Glad you like it.

Hi Leila, is there a character limit on the hyperlink function? I notice when I use it for a longer sentence the function returns #VALUE. Any tips or workarounds for more lengthy email text?

@santaro1986

2 жыл бұрын

Same happened to me too, it looks like there is a limit up to 255 characters, @Leila Gharani any advice please ? Also, how do I fetch multi-cells from excel into body text ?

@dreamwinner4253

2 жыл бұрын

Did you fix this issue?

@kuncharajesh6806

Жыл бұрын

even I faced the same. How to use longer sentences?

How to add different attachment to different recipients, If to keep it simple- Name of file will be the Name of Recipient within one of the folder. How to add ?

@LeilaGharani

4 жыл бұрын

Please see pinned comment.

@leedilmanian

4 жыл бұрын

@@LeilaGharani I am not seeing a pinned comment from you. Can you please share again?

@stephenboyce8100

4 жыл бұрын

@@LeilaGharani Hi, what pinned comment?

@MarcosReisPT

4 жыл бұрын

Stephen Boyce , the pinned comment in the beginning...

@stephenboyce8100

4 жыл бұрын

@@MarcosReisPT Am i missing something here, where in all of those links does it show you how to add in an attachment in the hyperlink formula? Its not possible is it, unless you do it in VBA.

Thank you for sharing 👍😊

I have went through few videos of Power Query and Macros and it was really excellent, you cover each and every point and you start from the scratch so that everyone can easily understand. I learnt many things watching those videos and it is helping alot in my day to day work. I would like you to plz make a video on how to add table in body of email if possible. It will be really helpful. Is there any way to do this? Hope we get more information on Excel and accounting topics from you. Thanks alot Leila

When the body text is long, i receive an error message...great video though!

@HKNAGPAL7

3 жыл бұрын

Any solution for that?

@peruvjan

3 жыл бұрын

@@HKNAGPAL7 There's a formula limit of 255 Characters. I guess you can only use this method for super short emails :/

@HKNAGPAL7

3 жыл бұрын

Thanks

Great. Now tell us how to send all the emails at once without clicking ech of them.

@chiragkhuranaa

4 жыл бұрын

Yes this is very important question.

@jackbgsd

4 жыл бұрын

You need to write up a macro for that

Leila, you are the best ... Thankyou

Exactly what I was looking for, thanks! :)

Thanks #Leila for this learning. I really appreciate. Your style of teaching is so amazing. :)

You are awesome. It is very helping.

Brilliant. Thank you for sharing.

Great tutorial. Thank you lady

Thanks, Ms. Leila... This is very useful for me.

props to you. that is really cool.

Great idea, thank you.

Great explanation.

thanks for your sharing. It's useful

Again really cool Video. I am on a Help Desk staff and this is what I did. For my boss I made a rapid email response email workbook. The first section consisted of a listing of everyone's first name and Email accounts. Te following columns contained what would create a email directed to each individual of routine emails he sends like, Remember You Have Tasks Today, or Review your open. I also wanted to set up a series of Blast messages which go out to the group. The trouble is I ran into a problem when I tried to add more than 10 email addresses. We have a group distribution list in Exchange. So I used the Distribution list name with @our domain. It worked. My boss most likely will not use this as it is not his style. Still I enjoyed the time spent on it between calls.

Great help!!!

Ok that was AWESOME many thanks

I just love the way you simply. I have subscribed to your bundle course on Udemy. Thank you🙏🙏🙏

Powerful information Thank you so much

Thanks Leila. It's really helpful.

Love your content. I wish I had this vid 2 years ago!! Thanks! Next vid should be about sending yourself text messages from excel!

very helpful! i am going to binge watch more!

You always come up with new things I didn't know Excel could do. There is SO much to Excel. Thanks for sharing.

@LeilaGharani

4 жыл бұрын

True, there is always something new to learn. For everyone.

Wonderful trick!

awesome, this made my life easy. thanks much!

First time seeing your videos, this is a great help thank you

I teach computer classes at a elementary school and this is super amazing! Thanks for posting. And your delivery is very well done! Greetings from San Juan, Puerto Rico! Luis

@LeilaGharani

3 жыл бұрын

You're very welcome, Luis!

Thank you, Leila!

Thank you very much Leila.

I’m an analyst and been watching your videos and find them really helpful ma’am! Thanks alot!

@LeilaGharani

4 жыл бұрын

My pleasure. Glad the tutorials are helpful.

I am following you since 3 to 4 months, you are giving so clear message to your viewers, in fact I love the way you explain. Simply I could say I love the whole. I just want to know the code for attaching a file and how to show the path.

You just saved me! Many thanks.

Thanks for your video

Thanks Liela ... This is really great

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

This is super helpful...👍

Amazing video! Really helpful!

You are freaking awesome Leila! keep it up, i've learned a lot. I will subscribe to learn more.

@LeilaGharani

4 жыл бұрын

Awesome! Thank you!

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

Hi Leila, it is an intteresting approach of excel to be able to integrate harmonically with such formula, and your ability to tweak the function. With this, we can update the excel dynamically, especially with Excel Online 365 with its limited function.