Grab the file I used in the video from here 👉 pages.xelplus.com/send-email-excel-file
@akshaymandavkar1908 ай бұрын
@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
@LeilaGharani5 жыл бұрын
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 KZbin as well. Regarding multiple email addresses: You can add these to the same cell and separate them with a semicolon ;
@ilhanaksu19035 жыл бұрын
can we .ore people to to or cc ?
@SUDHIRKUMAR-cr9zs5 жыл бұрын
Thanks leila for reply
@roxiserban5 жыл бұрын
Can you do one how do you send the emails automatic not one by one. ? Is great but still you click individually Thanks
@ilhanaksu19035 жыл бұрын
@@roxiserban what do you say i didnt ustand
@arslananwar62415 жыл бұрын
Great Video. Appreciated. Can charts from excel be pasted (as pictures) in email body using hyperlink?
@gpalchik15 жыл бұрын
Just when I thought Excel couldn’t get more awesome, you took it to the next level. Leila, you are the Best!!
@LeilaGharani5 жыл бұрын
I'm happy to hear that :)
@solidejison45003 жыл бұрын
@@LeilaGharani hi , how can i create mail .
@mohammadsalmanuddin6951 Жыл бұрын
@leila How to add multiple recipients in "to"
@mohammadsalmanuddin6951 Жыл бұрын
@@LeilaGharani please answer
@wrdlbrumfd3 жыл бұрын
Danke!
@LeilaGharani3 жыл бұрын
Thank you, Christian!
@fiazali-py8sn Жыл бұрын
excelent formula
@lynyrdyanga4 жыл бұрын
"%0A" is the gem in this video.
@thalesnemo28414 жыл бұрын
How would one find this out otherwise?
@matthewzarembski20634 жыл бұрын
Great work Leila, thank you for the %OA!
@celestedavid73642 жыл бұрын
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
@deepakphadtare3 жыл бұрын
simply say love you leila the way you explain subject...great Leila, God bless you
@shadrackawunyo77865 жыл бұрын
My 1st impression was "Wow, so this exists in Excel?" Thank you very much Leila for making a video on this. Very impressive
@LeilaGharani5 жыл бұрын
Thank you Shadrack.
@syedferoz74433 жыл бұрын
@@LeilaGharani...it is mostly useful at my work..could you please help me in adding excel cells tooo...if you can do that
@Jestunes4 жыл бұрын
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...
@LeilaGharani4 жыл бұрын
Many thanks for the kind feedback, Jesse!
@pushpajchougule83165 жыл бұрын
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. :)
@ayushsah675 жыл бұрын
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.
@amitharajdesamanjunath99855 жыл бұрын
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
@ratgirl6692 жыл бұрын
Holy cow, that was some advanced trick! Never knew this. Excel is so powerful, thanks for teaching!
@umehtoch5 жыл бұрын
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..
@lifeandmoney80733 ай бұрын
Your work is much commendable, I realised how great career of teaching is, it saves a lot of time, no recreation of wheel More power to you
@robertflynn74165 жыл бұрын
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!
@LeilaGharani5 жыл бұрын
Glad you like it Robert. Yes, maybe I'll do a follow-up.
@anandtewani7591 Жыл бұрын
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 🙏🏻
@LeilaGharani Жыл бұрын
Many thanks for the kind feedback, Anand!
@egiedipasupil53182 жыл бұрын
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.
@geoffreyjones38324 ай бұрын
Leila I love your presentations! I still haven't mastered Excel, let alone, VBA. Thanks to all of you!
@Troy-Echo4 жыл бұрын
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!
@PayalBansal-b1i3 ай бұрын
Loved this tutorial. So helpful and easy to follow. Thank you!
@maxpoole49453 жыл бұрын
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?
@lewisward20292 жыл бұрын
Excellent tutorial as always Leila, thank you!!
@darshuaparekh4 жыл бұрын
Hi Leila, In a formula, everything worked well until I added body. While adding email body, an error appears and 'friendly name' got converted into '#VALUE'. I evaluated entire formula using debug function. Error appears only in 'friendly name'. Tried removing email body formula partially which works well again. Not able to understand what's missing. Also, when I click 'Send Email', it opens In-built Inbox app instead of my Outlook. I also want to select my 'From: '. Please if you could advise the same.
@kaviyarasu3155 жыл бұрын
Superbbb Clear cut explanations
@sajjadhossainMusic4 жыл бұрын
Amazing. Just love it. Is there is any way of adding attachment dynamically ? It will be a great help.
@waterresourcecivilengineeringa3 жыл бұрын
#Waterresourcecivilengineeringandresearch
@abeersallam65642 жыл бұрын
@@waterresourcecivilengineeringa this is not helping what Sajjad asked!!
@benjaminkeyrose42945 жыл бұрын
She did it again! Another video saved to the Excel arsenal.
@LeilaGharani5 жыл бұрын
It's always good to have some tools available just in case :)
@CoachMattDoming4 жыл бұрын
Love this! Is there a way to just click one button and then it sends all the emails instead of clicking "Send Email" individually?
@wakelingchicken4 жыл бұрын
Sounds like you need VBA for that and you will have to code SMTP send commands
@tariq912ahmed4 жыл бұрын
Did you get this option, could you please send me if so
@thomasmeier85534 жыл бұрын
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
@JohnGagnepain3 жыл бұрын
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.
@TitoChinitoPH4 жыл бұрын
Thanks, Ms. Leila... This is very useful for me.
@herherher9255 жыл бұрын
Hi Leila, is it possible to expand this method into adding tables, or font formatting onto Outlook dynamically?
@alyonakurilina88803 жыл бұрын
That was my qtn too. We are in excel so 90% chance would be a requirement to include table into the email. @Leila help😊
@nitinkhtri79362 жыл бұрын
Have you got this how can add table in mail automatically
@rahulahire1651Ай бұрын
Did anyone got the answer please inform me also
@SholaDsdg5 жыл бұрын
Thank you Leila! I'm gonna watch this over and over
@LeilaGharani5 жыл бұрын
My pleasure Shola :)
@ajithlewis41924 жыл бұрын
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.
@alexfisse5474 жыл бұрын
Ever figure anything out?
@vibhanshuarora33784 жыл бұрын
Did you find any workaround to fix (value) error in HyperLink?
@myyoutube36293 жыл бұрын
Hi Leyla! Do you have solution for this?
@rahuladdanki3 жыл бұрын
255 is the max limit no workaround I believe, the only alternative I see is using a VBA.
@kasinkelly9 ай бұрын
Same issue here. I came to this as a work around for VBA and now need a different work around again
@nitinkaranjkar16905 жыл бұрын
Thanks Leila. It's really helpful.
@VivekSNarayan15 жыл бұрын
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?
@ryannoe865 жыл бұрын
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?
@gareth63265 жыл бұрын
@@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.
@ryannoe865 жыл бұрын
@@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!
@gareth63265 жыл бұрын
@@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.
@BobbyBlue19054 жыл бұрын
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.
@Carla369 Жыл бұрын
What a genious! It cannot perform all my task but at least a great porcentaje of it!! THANK YOUUU
@elmurdoc5 жыл бұрын
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?
@danielteixeira48165 жыл бұрын
You are wonderful...with yours formulas in the Excel.
@samratmistry84485 жыл бұрын
If the email body text needs multiple cell like B2:E12 will it work?
@mohamedelmoslmany4 жыл бұрын
#VALUE
@Write2pranab4 жыл бұрын
Up to three cells, use "&" or "concatenate" function
@zandranabo2 жыл бұрын
You are the best! Thank you for making this complicated excel functionality so easy...
@Lifeissimplebro3 жыл бұрын
Thanks, this was helpful, it doesn't want you to exceed the 255 character though. Is there a solution around it?
@bryanlacorte49783 жыл бұрын
Same problem
@adinaotrocol61343 жыл бұрын
Same problem, is there a solution?
@evanames59404 жыл бұрын
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.
@michaelkelly76205 жыл бұрын
Is there a way I can attach a document to the email also.
@robertlevak5 жыл бұрын
Very simple solution. Thank you so much!
@vahidhashimov44634 жыл бұрын
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?
@nisemapi2 жыл бұрын
You can combine them in a third cell and reference that instead, or you can add them both to the formula.
@fernsehdesign7 ай бұрын
@@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.
@entertainment24by784 жыл бұрын
Great tutorial. Thank you lady
@blakeross22574 жыл бұрын
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!!
@mariafriend6444 жыл бұрын
I created the Send Motivation and Send Email formula you include cc. Can’t wait to use it on a report!! Thank you!! I’m a Subscriber...
@LeilaGharani4 жыл бұрын
That's great Maria. Glad to have you here :)
@surajdabhade90225 жыл бұрын
Can we add attachment
@surajdabhade90225 жыл бұрын
How we can add attachment
@golfdelta7905 жыл бұрын
@@surajdabhade9022 agree how to add an attachment
@suzannegriswold75555 жыл бұрын
Just guessing but I wonder test the syntax &attachment="fullfilepathnamewithfiletype" referencing the path in a cell like the other attributes...
First time seeing your videos, this is a great help thank you
@rossmail59245 жыл бұрын
Awesome! Implemented already. BUT how do I get my email signature to show in the email automatically?
@rldb4 жыл бұрын
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.
@solidejison45003 жыл бұрын
pls who can tech me how to make email
@chandanlimma34435 жыл бұрын
awesome laila. Good explanation actually.
@RedDevilBlitz4 жыл бұрын
Hey, great tutorial. Is there a way where you can record a response when a user sends an email (or decides not to) ?
@benponderin4 жыл бұрын
Outstanding work,LG
@markemilyshepherd79813 жыл бұрын
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?
@santaro19862 жыл бұрын
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 ?
@dreamwinner42532 жыл бұрын
Did you fix this issue?
@kuncharajesh68062 жыл бұрын
even I faced the same. How to use longer sentences?
@uLu_MuLu3 жыл бұрын
This is very useful for my current project at work... Thanks!
@mukuljainn5 жыл бұрын
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 ?
@LeilaGharani5 жыл бұрын
Please see pinned comment.
@leedilmanian5 жыл бұрын
@@LeilaGharani I am not seeing a pinned comment from you. Can you please share again?
@stephenboyce81005 жыл бұрын
@@LeilaGharani Hi, what pinned comment?
@MarcosReisPT5 жыл бұрын
Stephen Boyce , the pinned comment in the beginning...
@stephenboyce81005 жыл бұрын
@@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.
@mohammednouf1435 жыл бұрын
All your videos are best nd understanding... Thank you
@LeilaGharani5 жыл бұрын
I'm glad to hear that Mohammed.
@georgepistikoudis5 жыл бұрын
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-ef9mm4 жыл бұрын
Change the Default Browser to Outlook.
@aytanothman54563 жыл бұрын
@@PremKumar-ef9mm i have the same problem Please more information
@mohammadsalmanuddin69513 жыл бұрын
@@PremKumar-ef9mm how?
@aideemanzano45593 жыл бұрын
I have the same problem
@wintermorillo6567 Жыл бұрын
Very easy explanation!
@user-jb3hn2nr1l5 жыл бұрын
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
@thiago7135 жыл бұрын
Yesssssss!!!!
@LeilaGharani5 жыл бұрын
Please see pinned comment.
@DigiCloudWorkSpace4 жыл бұрын
I was working with my way, but now I learn new way, Thank You @Leila
@LeilaGharani4 жыл бұрын
You’re welcome 😊
@TH-ov8ds4 жыл бұрын
When the body text is long, i receive an error message...great video though!
@HKNAGPAL74 жыл бұрын
Any solution for that?
@peruvjan4 жыл бұрын
@@HKNAGPAL7 There's a formula limit of 255 Characters. I guess you can only use this method for super short emails :/
@HKNAGPAL74 жыл бұрын
Thanks
@bentalsahn15074 жыл бұрын
Leila, you are the best ... Thankyou
@superfreiheit15 жыл бұрын
Great. Now tell us how to send all the emails at once without clicking ech of them.
@chiragkhuranaa5 жыл бұрын
Yes this is very important question.
@jackbgsd4 жыл бұрын
You need to write up a macro for that
@PemboDave3 жыл бұрын
Great little tip Thanks for sharing
@jayhu60754 жыл бұрын
This is a dope tutor. Many thanks.
@KNLP235 жыл бұрын
Awesome teaching!😀
@LeilaGharani5 жыл бұрын
Glad you like it.
@Make_it_happen1002 жыл бұрын
Thank you for good teaching
@VinodKumar-fm8wu4 жыл бұрын
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 😊
@LeilaGharani4 жыл бұрын
Glad you like the teaching style :)
@awaiskhan92964 жыл бұрын
Leila, another excellent video. Keep us the great work
@LeilaGharani4 жыл бұрын
Thank you! Will do!
@juliava62274 жыл бұрын
Leila, you are fantastic! Thank you very much!🌸🦋👍👍👍
@lesliefreymann77103 жыл бұрын
This video was sooooooo helpful. Thanks so much! Keep up the great work!!!
@LeilaGharani3 жыл бұрын
Glad it helped, Leslie!
@ursourabh013 жыл бұрын
Thanks for this tip ma'am ☺️
@tutorials--12345 жыл бұрын
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!
@LeilaGharani5 жыл бұрын
My pleasure. Hope your workmates will like it too.
@helenasvensson67473 жыл бұрын
Wonderful trick!
@mattschoular88445 жыл бұрын
Wow. Excel is so awesome. Thanks for sharing
@LeilaGharani5 жыл бұрын
It sure is Matt. Glad you like it.
@salimsheikh74585 жыл бұрын
You are awesome. It is very helping.
@OldSchoolDad5 жыл бұрын
This is really useful! I tried it for one application and it worked great. On the next application, I had a much longer body for the email and it displayed VALUE#. I tried several different things, and finally found that there seems to be some character limit with this function. After shortening the wording, it worked fine as before.
@LeilaGharani5 жыл бұрын
Yes, it's Excel's formula 255 character limit. You can't use the Hyperlink formula for extra long emails.
@hirdayanandgupta51192 жыл бұрын
@@LeilaGharani is there any option
@tinpotcooker Жыл бұрын
The video is great and very useful! thank you so much!
@zakaurrehmankhan81853 жыл бұрын
It was really very helpful. Regards
@sarfarajkureshi65695 жыл бұрын
Very helpful, love you mam...
@khizarhyatt3 жыл бұрын
thank you so much, ma'am! I am a python developer I was finding ways to automate my work. it gonna help me in my coding.
@MrOUTofDworld3 жыл бұрын
THANKS A TON, LEILA!!!
@lanfofana19734 жыл бұрын
Thanks Leila. You are so helpful. I am learning a lot from you.
@mohanthanga9995 жыл бұрын
great details...thank you
@emarcos404 жыл бұрын
Awesome Leila. Thank you.
@Tswaraj3 жыл бұрын
You just saved me! Many thanks.
@pinoyguitartv2 жыл бұрын
My life is complete, Thanks a bunch ❤️❤️❤️
@mirrrvelll51645 жыл бұрын
Amazing video! Really helpful!
@varuninnz4 жыл бұрын
Brilliant. Thank you for sharing.
@godknowsmujinda7904 жыл бұрын
Powerful information Thank you so much
@winstonnavarro38195 жыл бұрын
I’m an analyst and been watching your videos and find them really helpful ma’am! Thanks alot!
@LeilaGharani5 жыл бұрын
My pleasure. Glad the tutorials are helpful.
@Mohitraj095 жыл бұрын
Thanks a lot. This is super helpful.
@adriaanvantonder35992 жыл бұрын
Thank you for the great lesson.. i only recently really got an interest sparked in the full potential of excel.. before just the dead basic. However this lessin resolved a hurdle i faced, i attempted at my work desktop with 2016 and getting a formula error all the time even if followed to the T. On my personal pc with 2013 version its a success. Pondering the reason as should 2016 not be more advanced and giving lesser headaches. Same thing happens when converting to text 2016 gives few conversions while 2013 gives all.. subbed the channel as my thirst for knowledge cup runnith over .
@naqibullahwazir21623 жыл бұрын
Great explanation.
@francobarron60263 жыл бұрын
You just saved me a whole lot of time.
@shueybamin52444 жыл бұрын
What a great video. And here I thought the only way was to use Macros and VBA. Thank you Leila!!
@HANSP20123 жыл бұрын
Hello Leyla, such a great help here. Thanks so much. However, whenever I hit send email, it takes me to windows 10 email, not outlook account, any help to get it fixed? Thanks in advance.