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

  Рет қаралды 1,326,689

Leila Gharani

Leila Gharani

Күн бұрын

Пікірлер: 1 600
@LeilaGharani
@LeilaGharani 11 ай бұрын
Grab the file I used in the video from here 👉 pages.xelplus.com/send-email-excel-file
@akshaymandavkar190
@akshaymandavkar190 8 ай бұрын
@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
@LeilaGharani
@LeilaGharani 5 жыл бұрын
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 ;
@ilhanaksu1903
@ilhanaksu1903 5 жыл бұрын
can we .ore people to to or cc ?
@SUDHIRKUMAR-cr9zs
@SUDHIRKUMAR-cr9zs 5 жыл бұрын
Thanks leila for reply
@roxiserban
@roxiserban 5 жыл бұрын
Can you do one how do you send the emails automatic not one by one. ? Is great but still you click individually Thanks
@ilhanaksu1903
@ilhanaksu1903 5 жыл бұрын
@@roxiserban what do you say i didnt ustand
@arslananwar6241
@arslananwar6241 5 жыл бұрын
Great Video. Appreciated. Can charts from excel be pasted (as pictures) in email body using hyperlink?
@gpalchik1
@gpalchik1 5 жыл бұрын
Just when I thought Excel couldn’t get more awesome, you took it to the next level. Leila, you are the Best!!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
I'm happy to hear that :)
@solidejison4500
@solidejison4500 3 жыл бұрын
@@LeilaGharani hi , how can i create mail .
@mohammadsalmanuddin6951
@mohammadsalmanuddin6951 Жыл бұрын
@leila How to add multiple recipients in "to"
@mohammadsalmanuddin6951
@mohammadsalmanuddin6951 Жыл бұрын
​@@LeilaGharani please answer
@wrdlbrumfd
@wrdlbrumfd 3 жыл бұрын
Danke!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thank you, Christian!
@fiazali-py8sn
@fiazali-py8sn Жыл бұрын
excelent formula
@lynyrdyanga
@lynyrdyanga 4 жыл бұрын
"%0A" is the gem in this video.
@thalesnemo2841
@thalesnemo2841 4 жыл бұрын
How would one find this out otherwise?
@matthewzarembski2063
@matthewzarembski2063 4 жыл бұрын
Great work Leila, thank you for the %OA!
@celestedavid7364
@celestedavid7364 2 жыл бұрын
Do it 2x (%0A%0A) to make it as a paragraph 😀 instead of just a sentence.
@harishsharma2675
@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
@deepakphadtare
@deepakphadtare 3 жыл бұрын
simply say love you leila the way you explain subject...great Leila, God bless you
@shadrackawunyo7786
@shadrackawunyo7786 5 жыл бұрын
My 1st impression was "Wow, so this exists in Excel?" Thank you very much Leila for making a video on this. Very impressive
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thank you Shadrack.
@syedferoz7443
@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
@Jestunes
@Jestunes 4 жыл бұрын
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
@LeilaGharani 4 жыл бұрын
Many thanks for the kind feedback, Jesse!
@pushpajchougule8316
@pushpajchougule8316 5 жыл бұрын
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. :)
@ayushsah67
@ayushsah67 5 жыл бұрын
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.
@amitharajdesamanjunath9985
@amitharajdesamanjunath9985 5 жыл бұрын
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
@ratgirl669
@ratgirl669 2 жыл бұрын
Holy cow, that was some advanced trick! Never knew this. Excel is so powerful, thanks for teaching!
@umehtoch
@umehtoch 5 жыл бұрын
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..
@lifeandmoney8073
@lifeandmoney8073 3 ай бұрын
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
@robertflynn7416
@robertflynn7416 5 жыл бұрын
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
@LeilaGharani 5 жыл бұрын
Glad you like it Robert. Yes, maybe I'll do a follow-up.
@anandtewani7591
@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
@LeilaGharani Жыл бұрын
Many thanks for the kind feedback, Anand!
@egiedipasupil5318
@egiedipasupil5318 2 жыл бұрын
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.
@geoffreyjones3832
@geoffreyjones3832 4 ай бұрын
Leila I love your presentations! I still haven't mastered Excel, let alone, VBA. Thanks to all of you!
@Troy-Echo
@Troy-Echo 4 жыл бұрын
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-b1i
@PayalBansal-b1i 3 ай бұрын
Loved this tutorial. So helpful and easy to follow. Thank you!
@maxpoole4945
@maxpoole4945 3 жыл бұрын
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?
@lewisward2029
@lewisward2029 2 жыл бұрын
Excellent tutorial as always Leila, thank you!!
@darshuaparekh
@darshuaparekh 4 жыл бұрын
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.
@kaviyarasu315
@kaviyarasu315 5 жыл бұрын
Superbbb Clear cut explanations
@sajjadhossainMusic
@sajjadhossainMusic 4 жыл бұрын
Amazing. Just love it. Is there is any way of adding attachment dynamically ? It will be a great help.
@waterresourcecivilengineeringa
@waterresourcecivilengineeringa 3 жыл бұрын
#Waterresourcecivilengineeringandresearch
@abeersallam6564
@abeersallam6564 2 жыл бұрын
@@waterresourcecivilengineeringa this is not helping what Sajjad asked!!
@benjaminkeyrose4294
@benjaminkeyrose4294 5 жыл бұрын
She did it again! Another video saved to the Excel arsenal.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
It's always good to have some tools available just in case :)
@CoachMattDoming
@CoachMattDoming 4 жыл бұрын
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
@wakelingchicken 4 жыл бұрын
Sounds like you need VBA for that and you will have to code SMTP send commands
@tariq912ahmed
@tariq912ahmed 4 жыл бұрын
Did you get this option, could you please send me if so
@thomasmeier8553
@thomasmeier8553 4 жыл бұрын
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
@JohnGagnepain 3 жыл бұрын
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.
@TitoChinitoPH
@TitoChinitoPH 4 жыл бұрын
Thanks, Ms. Leila... This is very useful for me.
@herherher925
@herherher925 5 жыл бұрын
Hi Leila, is it possible to expand this method into adding tables, or font formatting onto Outlook dynamically?
@alyonakurilina8880
@alyonakurilina8880 3 жыл бұрын
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
@nitinkhtri7936 2 жыл бұрын
Have you got this how can add table in mail automatically
@rahulahire1651
@rahulahire1651 Ай бұрын
Did anyone got the answer please inform me also
@SholaDsdg
@SholaDsdg 5 жыл бұрын
Thank you Leila! I'm gonna watch this over and over
@LeilaGharani
@LeilaGharani 5 жыл бұрын
My pleasure Shola :)
@ajithlewis4192
@ajithlewis4192 4 жыл бұрын
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
@alexfisse547 4 жыл бұрын
Ever figure anything out?
@vibhanshuarora3378
@vibhanshuarora3378 4 жыл бұрын
Did you find any workaround to fix (value) error in HyperLink?
@myyoutube3629
@myyoutube3629 3 жыл бұрын
Hi Leyla! Do you have solution for this?
@rahuladdanki
@rahuladdanki 3 жыл бұрын
255 is the max limit no workaround I believe, the only alternative I see is using a VBA.
@kasinkelly
@kasinkelly 9 ай бұрын
Same issue here. I came to this as a work around for VBA and now need a different work around again
@nitinkaranjkar1690
@nitinkaranjkar1690 5 жыл бұрын
Thanks Leila. It's really helpful.
@VivekSNarayan1
@VivekSNarayan1 5 жыл бұрын
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
@ryannoe86 5 жыл бұрын
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
@gareth6326 5 жыл бұрын
@@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
@ryannoe86 5 жыл бұрын
@@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
@gareth6326 5 жыл бұрын
@@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
@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.
@Carla369
@Carla369 Жыл бұрын
What a genious! It cannot perform all my task but at least a great porcentaje of it!! THANK YOUUU
@elmurdoc
@elmurdoc 5 жыл бұрын
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?
@danielteixeira4816
@danielteixeira4816 5 жыл бұрын
You are wonderful...with yours formulas in the Excel.
@samratmistry8448
@samratmistry8448 5 жыл бұрын
If the email body text needs multiple cell like B2:E12 will it work?
@mohamedelmoslmany
@mohamedelmoslmany 4 жыл бұрын
#VALUE
@Write2pranab
@Write2pranab 4 жыл бұрын
Up to three cells, use "&" or "concatenate" function
@zandranabo
@zandranabo 2 жыл бұрын
You are the best! Thank you for making this complicated excel functionality so easy...
@Lifeissimplebro
@Lifeissimplebro 3 жыл бұрын
Thanks, this was helpful, it doesn't want you to exceed the 255 character though. Is there a solution around it?
@bryanlacorte4978
@bryanlacorte4978 3 жыл бұрын
Same problem
@adinaotrocol6134
@adinaotrocol6134 3 жыл бұрын
Same problem, is there a solution?
@evanames5940
@evanames5940 4 жыл бұрын
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.
@michaelkelly7620
@michaelkelly7620 5 жыл бұрын
Is there a way I can attach a document to the email also.
@robertlevak
@robertlevak 5 жыл бұрын
Very simple solution. Thank you so much!
@vahidhashimov4463
@vahidhashimov4463 4 жыл бұрын
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
@nisemapi 2 жыл бұрын
You can combine them in a third cell and reference that instead, or you can add them both to the formula.
@fernsehdesign
@fernsehdesign 7 ай бұрын
@@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.
@entertainment24by78
@entertainment24by78 4 жыл бұрын
Great tutorial. Thank you lady
@blakeross2257
@blakeross2257 4 жыл бұрын
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!!
@mariafriend644
@mariafriend644 4 жыл бұрын
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...
@LeilaGharani
@LeilaGharani 4 жыл бұрын
That's great Maria. Glad to have you here :)
@surajdabhade9022
@surajdabhade9022 5 жыл бұрын
Can we add attachment
@surajdabhade9022
@surajdabhade9022 5 жыл бұрын
How we can add attachment
@golfdelta790
@golfdelta790 5 жыл бұрын
@@surajdabhade9022 agree how to add an attachment
@suzannegriswold7555
@suzannegriswold7555 5 жыл бұрын
Just guessing but I wonder test the syntax &attachment="fullfilepathnamewithfiletype" referencing the path in a cell like the other attributes...
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Please check the pinned comment above.
@maerskhm6701
@maerskhm6701 5 жыл бұрын
@@suzannegriswold7555 Pls write complete formula....
@richyyy8114
@richyyy8114 Жыл бұрын
First time seeing your videos, this is a great help thank you
@rossmail5924
@rossmail5924 5 жыл бұрын
Awesome! Implemented already. BUT how do I get my email signature to show in the email automatically?
@rldb
@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
@solidejison4500 3 жыл бұрын
pls who can tech me how to make email
@chandanlimma3443
@chandanlimma3443 5 жыл бұрын
awesome laila. Good explanation actually.
@RedDevilBlitz
@RedDevilBlitz 4 жыл бұрын
Hey, great tutorial. Is there a way where you can record a response when a user sends an email (or decides not to) ?
@benponderin
@benponderin 4 жыл бұрын
Outstanding work,LG
@markemilyshepherd7981
@markemilyshepherd7981 3 жыл бұрын
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
@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
@dreamwinner4253 2 жыл бұрын
Did you fix this issue?
@kuncharajesh6806
@kuncharajesh6806 2 жыл бұрын
even I faced the same. How to use longer sentences?
@uLu_MuLu
@uLu_MuLu 3 жыл бұрын
This is very useful for my current project at work... Thanks!
@mukuljainn
@mukuljainn 5 жыл бұрын
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
@LeilaGharani 5 жыл бұрын
Please see pinned comment.
@leedilmanian
@leedilmanian 5 жыл бұрын
@@LeilaGharani I am not seeing a pinned comment from you. Can you please share again?
@stephenboyce8100
@stephenboyce8100 5 жыл бұрын
@@LeilaGharani Hi, what pinned comment?
@MarcosReisPT
@MarcosReisPT 5 жыл бұрын
Stephen Boyce , the pinned comment in the beginning...
@stephenboyce8100
@stephenboyce8100 5 жыл бұрын
@@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.
@mohammednouf143
@mohammednouf143 5 жыл бұрын
All your videos are best nd understanding... Thank you
@LeilaGharani
@LeilaGharani 5 жыл бұрын
I'm glad to hear that Mohammed.
@georgepistikoudis
@georgepistikoudis 5 жыл бұрын
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
@PremKumar-ef9mm 4 жыл бұрын
Change the Default Browser to Outlook.
@aytanothman5456
@aytanothman5456 3 жыл бұрын
@@PremKumar-ef9mm i have the same problem Please more information
@mohammadsalmanuddin6951
@mohammadsalmanuddin6951 3 жыл бұрын
@@PremKumar-ef9mm how?
@aideemanzano4559
@aideemanzano4559 3 жыл бұрын
I have the same problem
@wintermorillo6567
@wintermorillo6567 Жыл бұрын
Very easy explanation!
@user-jb3hn2nr1l
@user-jb3hn2nr1l 5 жыл бұрын
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
@thiago713 5 жыл бұрын
Yesssssss!!!!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Please see pinned comment.
@DigiCloudWorkSpace
@DigiCloudWorkSpace 4 жыл бұрын
I was working with my way, but now I learn new way, Thank You @Leila
@LeilaGharani
@LeilaGharani 4 жыл бұрын
You’re welcome 😊
@TH-ov8ds
@TH-ov8ds 4 жыл бұрын
When the body text is long, i receive an error message...great video though!
@HKNAGPAL7
@HKNAGPAL7 4 жыл бұрын
Any solution for that?
@peruvjan
@peruvjan 4 жыл бұрын
@@HKNAGPAL7 There's a formula limit of 255 Characters. I guess you can only use this method for super short emails :/
@HKNAGPAL7
@HKNAGPAL7 4 жыл бұрын
Thanks
@bentalsahn1507
@bentalsahn1507 4 жыл бұрын
Leila, you are the best ... Thankyou
@superfreiheit1
@superfreiheit1 5 жыл бұрын
Great. Now tell us how to send all the emails at once without clicking ech of them.
@chiragkhuranaa
@chiragkhuranaa 5 жыл бұрын
Yes this is very important question.
@jackbgsd
@jackbgsd 4 жыл бұрын
You need to write up a macro for that
@PemboDave
@PemboDave 3 жыл бұрын
Great little tip Thanks for sharing
@jayhu6075
@jayhu6075 4 жыл бұрын
This is a dope tutor. Many thanks.
@KNLP23
@KNLP23 5 жыл бұрын
Awesome teaching!😀
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Glad you like it.
@Make_it_happen100
@Make_it_happen100 2 жыл бұрын
Thank you for good teaching
@VinodKumar-fm8wu
@VinodKumar-fm8wu 4 жыл бұрын
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
@LeilaGharani 4 жыл бұрын
Glad you like the teaching style :)
@awaiskhan9296
@awaiskhan9296 4 жыл бұрын
Leila, another excellent video. Keep us the great work
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Thank you! Will do!
@juliava6227
@juliava6227 4 жыл бұрын
Leila, you are fantastic! Thank you very much!🌸🦋👍👍👍
@lesliefreymann7710
@lesliefreymann7710 3 жыл бұрын
This video was sooooooo helpful. Thanks so much! Keep up the great work!!!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Glad it helped, Leslie!
@ursourabh01
@ursourabh01 3 жыл бұрын
Thanks for this tip ma'am ☺️
@tutorials--1234
@tutorials--1234 5 жыл бұрын
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
@LeilaGharani 5 жыл бұрын
My pleasure. Hope your workmates will like it too.
@helenasvensson6747
@helenasvensson6747 3 жыл бұрын
Wonderful trick!
@mattschoular8844
@mattschoular8844 5 жыл бұрын
Wow. Excel is so awesome. Thanks for sharing
@LeilaGharani
@LeilaGharani 5 жыл бұрын
It sure is Matt. Glad you like it.
@salimsheikh7458
@salimsheikh7458 5 жыл бұрын
You are awesome. It is very helping.
@OldSchoolDad
@OldSchoolDad 5 жыл бұрын
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.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Yes, it's Excel's formula 255 character limit. You can't use the Hyperlink formula for extra long emails.
@hirdayanandgupta5119
@hirdayanandgupta5119 2 жыл бұрын
@@LeilaGharani is there any option
@tinpotcooker
@tinpotcooker Жыл бұрын
The video is great and very useful! thank you so much!
@zakaurrehmankhan8185
@zakaurrehmankhan8185 3 жыл бұрын
It was really very helpful. Regards
@sarfarajkureshi6569
@sarfarajkureshi6569 5 жыл бұрын
Very helpful, love you mam...
@khizarhyatt
@khizarhyatt 3 жыл бұрын
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.
@MrOUTofDworld
@MrOUTofDworld 3 жыл бұрын
THANKS A TON, LEILA!!!
@lanfofana1973
@lanfofana1973 4 жыл бұрын
Thanks Leila. You are so helpful. I am learning a lot from you.
@mohanthanga999
@mohanthanga999 5 жыл бұрын
great details...thank you
@emarcos40
@emarcos40 4 жыл бұрын
Awesome Leila. Thank you.
@Tswaraj
@Tswaraj 3 жыл бұрын
You just saved me! Many thanks.
@pinoyguitartv
@pinoyguitartv 2 жыл бұрын
My life is complete, Thanks a bunch ❤️❤️❤️
@mirrrvelll5164
@mirrrvelll5164 5 жыл бұрын
Amazing video! Really helpful!
@varuninnz
@varuninnz 4 жыл бұрын
Brilliant. Thank you for sharing.
@godknowsmujinda790
@godknowsmujinda790 4 жыл бұрын
Powerful information Thank you so much
@winstonnavarro3819
@winstonnavarro3819 5 жыл бұрын
I’m an analyst and been watching your videos and find them really helpful ma’am! Thanks alot!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
My pleasure. Glad the tutorials are helpful.
@Mohitraj09
@Mohitraj09 5 жыл бұрын
Thanks a lot. This is super helpful.
@adriaanvantonder3599
@adriaanvantonder3599 2 жыл бұрын
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 .
@naqibullahwazir2162
@naqibullahwazir2162 3 жыл бұрын
Great explanation.
@francobarron6026
@francobarron6026 3 жыл бұрын
You just saved me a whole lot of time.
@shueybamin5244
@shueybamin5244 4 жыл бұрын
What a great video. And here I thought the only way was to use Macros and VBA. Thank you Leila!!
@HANSP2012
@HANSP2012 3 жыл бұрын
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.
@upittman1
@upittman1 3 жыл бұрын
props to you. that is really cool.
@avidaneliabrigana790
@avidaneliabrigana790 3 жыл бұрын
Amazing, thank you!
@karunkumar6577
@karunkumar6577 5 жыл бұрын
thanks a lot...you are simply amazing at excel
@LeilaGharani
@LeilaGharani 5 жыл бұрын
My pleasure Karun.
Excel 3D Formulas Explained (Sum Across Multiple Sheets)
9:12
Leila Gharani
Рет қаралды 380 М.
Гениальное изобретение из обычного стаканчика!
00:31
Лютая физика | Олимпиадная физика
Рет қаралды 4,8 МЛН
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН
You Won’t Believe What Excel’s Copilot Can Do! (new updates)
10:37
Try The DGET Function Instead of INDEXMATCH & XLOOKUP
12:29
Kenji Explains
Рет қаралды 121 М.
Send Emails from Excel That Capture Data From Your Worksheet
13:27
Officeinstructor
Рет қаралды 38 М.
How to Use VLOOKUP in Excel (free file included)
15:15
Leila Gharani
Рет қаралды 351 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 986 М.
Excel for Accounting - 10 Excel Functions You NEED to KNOW!
19:05
Leila Gharani
Рет қаралды 2,1 МЛН