Automatic EMAIL From Excel - How to Send Email From Excel

Поділитися
Вставка
  • Опубліковано 11 жов 2024
  • Automatic EMAIL From Excel - How to Send Email From Excel
    #emailfromexcel #sendemail #deepakeduworld
    Dosto is video me maine btaya hai ki aap excel se e-mail kaise kar saktey ho wo bhi bina VBA ke. Hyperlink Formula ka use karke. Agar aap soch rahe hain ki excel se email remainder kaise send kare to ye video apke bahut kaam ka hai. Aasha hai ye video apko jarur pasand aayega
    In this video you will learn How To Send Emails From Excel Sheet in Hindi. i will show you How to create an Outlook email from Excel without using VBA? You can create it with an Excel Hyperlink formula using cell references for mailto, subject and cc? The Excel Single Hyperlink formula gives you the ability to create dynamic emails without using any macro and VBA.
    Download Training File : bit.ly/3aEkU3H
    My New Channel : bit.ly/3qFrbl5
    Xlookup Complete Tutorial : • What Xlookup Can Do Fo...
    Vlookup Complete Tutorial : bit.ly/2K0C1Sb
    Complete Microsoft Word Tutorial : • How To Do Office Work ...
    Subscribe and Become Family Mamber of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
    Deepak EduWorld Playlist's:
    POWERPOINT COURSE ►
    • MS Power Point Tutoria...
    ADVANCED EXCEL ►
    goo.gl/A6LdZA
    ADVANCED EXCEL FORMULAS ►
    goo.gl/bbHYu2
    EXCEL TIPS & TRICKS ►
    goo.gl/wAj1jh
    MS WORD ►
    goo.gl/B4TeSA
    HTML5 & CSS3 ►
    goo.gl/2PFgs8
    COMPUTER TECHNICAL videos ►
    goo.gl/paZmpn
    AUTOMATIC INVOICE IN EXCEL ►
    goo.gl/dFhg54
    PHOTOSHOP ►
    • How To Make Passport S...
    Subscribe Deepak EduWorld ► / deepakeduworld
    Instagram ► / deepakeduworld
    Facebook page ► / deepakeduworld
    LinkedIn ► / deepakeduworld
    Facebook Group ► / cse92
    We Always Provide Useful & Helpful Content On The Deepak Eduworld UA-cam Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
    Tags: deepak eduworld,send email from excel,email from excel,excel,send email using vba,excel automation,excel 2016,vba,outlook,excel email formula,excel hyperlink email,microsoft office,send,gmail,bulk email,hyperlink,email using excel,hyperlink in excel,email,mail,excel online course,excel tips and tricks,excel for analysts,excel 2013,excel 2019,excel hyperlink,excel hyperlink formula,excel to mail,subject,mailto,cc,hindi

КОМЕНТАРІ • 463

  • @DeepakEduWorld
    @DeepakEduWorld  3 роки тому +11

    Dosto is video ko complete dekho.. fir btana kaisa laga 👍
    *My New Channel :* bit.ly/3qFrbl5
    *Complete Microsoft Word Tutorial :* ua-cam.com/video/Xkq0-xXAj48/v-deo.html
    *Complete Powerpoint Tutorial :* ua-cam.com/video/OekrBhNybP0/v-deo.html
    *Xlookup Complete Tutorial :* ua-cam.com/video/0LjfRVD7srU/v-deo.html
    *Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
    *Excel All Formulas :* ua-cam.com/video/C9y53fedo04/v-deo.html

  • @romeshkadam3927
    @romeshkadam3927 3 роки тому +12

    thank you very much this video, if i want to attached file automatically, then what to do

  • @arindamghosh4613
    @arindamghosh4613 3 роки тому +3

    It's really helpful. Because I'm searching over one week this type video but finally.

    • @SunilKumar-uv6zu
      @SunilKumar-uv6zu 3 роки тому

      Learn vba tutorials basic to advance - ua-cam.com/video/kKM85_FkC74/v-deo.html

  • @naman881
    @naman881 2 роки тому +1

    aapki aisi bahut sari video dekhkar maine kafi kuch sikh liya hai. log mujhe compuer expert kahne lage hai

    • @DeepakEduWorld
      @DeepakEduWorld  2 роки тому +1

      To aap smart excel user ban gaye 👍👍👍

    • @naman881
      @naman881 2 роки тому

      @@DeepakEduWorld sir mujhe outlook sikhna hai mera gmail account nahi set ho raha hai, aapka procedure use kiya but nahi hua, kya trika use kiya aapko mail kar k bolu kya

  • @gautamshethb4614
    @gautamshethb4614 3 роки тому +1

    I got to know sending msges in whatsApp by vba but email was a very wonderful idea 💡Thank you so much. That will help in automation. Bhai aap sach hi mai Excel ke mai baap ho🙏

  • @ghurahuprasadyadav3798
    @ghurahuprasadyadav3798 3 роки тому +1

    आदरणीय् दीपक सर जी ,
    बहुत ही लाजवाब लगा।

  • @9419895783
    @9419895783 3 роки тому

    Bhut bdiya excel pdate ho sir, hats off to you

  • @ishantkumar3949
    @ishantkumar3949 3 роки тому +1

    So useful and innovative ideas thanks Deepak it is very helpful

    • @SunilKumar-uv6zu
      @SunilKumar-uv6zu 3 роки тому

      Learn vba tutorials basic to advance - ua-cam.com/video/kKM85_FkC74/v-deo.html

  • @Amitkumar-un1rk
    @Amitkumar-un1rk 3 роки тому +7

    Hello Deepak
    Kindly make 2nd part of this topic that how send bulk mail through excel
    Thanks

    • @SunilKumar-uv6zu
      @SunilKumar-uv6zu 3 роки тому

      Learn vba tutorials basic to advance - ua-cam.com/video/kKM85_FkC74/v-deo.html

    • @SunilKumar-uv6zu
      @SunilKumar-uv6zu 3 роки тому

      Learn vba tutorials basic to advance - ua-cam.com/video/kKM85_FkC74/v-deo.html

    • @fragrenceful
      @fragrenceful 3 роки тому +1

      How to attach file and folder in this Excel worksheet automatically to send recipient please guide ASAP thanks

  • @anujkumar-hm6ry
    @anujkumar-hm6ry Рік тому

    Well defined, concise and useful video for bulk mails sending

  • @sangarsh.5339
    @sangarsh.5339 2 роки тому +1

    Awesome sir, it's very helpfull to me..thanks..

  • @acousticmelody5299
    @acousticmelody5299 Рік тому +1

    Great video bro...
    It's showing error if the body of mail is slightly lengthy. Please tell me if you can solve the issue.

  • @jasimskjasimuddin8422
    @jasimskjasimuddin8422 3 роки тому +2

    Vry good!!
    Istara SMS keysee send karu.pls ek video de jiye.

    • @SunilKumar-uv6zu
      @SunilKumar-uv6zu 3 роки тому

      Learn vba tutorials basic to advance - ua-cam.com/video/kKM85_FkC74/v-deo.html

  • @subhashismajumdar7413
    @subhashismajumdar7413 3 роки тому +2

    You are just genius. Fantastic explanation process. I have benefited a lot. Thanks a lot.

  • @shafikmiah
    @shafikmiah 8 місяців тому +1

    One of the best videos, thank you

  • @aryan1mushafir
    @aryan1mushafir 3 роки тому

    Thanks Deepak bro
    Video bahut acha h
    Thanks again for sharing.

    • @SunilKumar-uv6zu
      @SunilKumar-uv6zu 3 роки тому

      Learn vba tutorials basic to advance - ua-cam.com/video/kKM85_FkC74/v-deo.html

  • @sherbahadursingh8260
    @sherbahadursingh8260 2 роки тому +1

    Hi, Thanks for this tutorial. Can u please help if i have to send multiple rows in one mail id at one time only

  • @sahiyagalat172
    @sahiyagalat172 3 роки тому

    Best video.sir Isme file attachment karne ka batayena.ya body pe dusra kuch bhej sake to.

  • @suzukidadyalmotors7652
    @suzukidadyalmotors7652 2 роки тому

    You are great teacher in real

  • @chandnijaiswal9029
    @chandnijaiswal9029 3 роки тому +1

    Thankyou sir
    Really helpfull video
    Good job 👍👍👍👍
    Luv u 🤗🤗🤗🤗🤗

  • @syedferoz7443
    @syedferoz7443 3 роки тому

    Kamal kardiya apne...muje mail me table bhi paste Karna hai from same sheet how we can do

  • @strinty79
    @strinty79 3 роки тому +1

    Thanks for sharing this information

  • @Gamogin
    @Gamogin Рік тому

    Very nice ... Excellent guidance.....Great

  • @ashokmirasi9550
    @ashokmirasi9550 Рік тому +1

    Thanks for this new knowledge

  • @moiddinmetro
    @moiddinmetro 2 роки тому +1

    Thanks sir very useful video. 🙏

  • @SanthoshKumar-hk6hv
    @SanthoshKumar-hk6hv 3 роки тому +6

    Informative, can you start teaching VBA from the basics

    • @SunilKumar-uv6zu
      @SunilKumar-uv6zu 3 роки тому

      Learn vba tutorials basic to advance - ua-cam.com/video/kKM85_FkC74/v-deo.html

  • @shahnawazshaikh9430
    @shahnawazshaikh9430 3 роки тому +3

    Hi Deepak. Thanks for ur video. I would like to know if there are multiple email id from which we need to send email. Than how could be add same in formula.

    • @TrekVenture1408
      @TrekVenture1408 Рік тому

      to see how to send multiple emails, see video in this channel ua-cam.com/channels/uXLZCUz0QoAFja7FaIKFWA.html

  • @ashokaher3914
    @ashokaher3914 3 роки тому +1

    Excellent.. Deepak Ji

    • @SunilKumar-uv6zu
      @SunilKumar-uv6zu 3 роки тому

      Learn vba tutorials basic to advance - ua-cam.com/video/kKM85_FkC74/v-deo.html

  • @pankulbaijal7542
    @pankulbaijal7542 3 роки тому +5

    Very nice and creative, I like it it very much keep making such valuable video like this. Also make videos on appointments and inventory management. Very great full if you could make both of these. Thanks Happy Learning 😊 😊

  • @abhishekvishwakarma650
    @abhishekvishwakarma650 2 роки тому +1

    Hi, ye bohot hi helpful video hai. Lekin mujhe janna hai ki agar main IBM Lotus note use kar rha hu to kya Krna hoga....

  • @VisualKreation
    @VisualKreation 3 роки тому +1

    Very nice Sir, Kya asie ker saket hao ki Send hone ke baad automatically windows close ho our ek message aye ki Message Successfully send. or Date or Time bhi aana chahiye excel me..TQ

  • @muhammadraza9432
    @muhammadraza9432 3 роки тому +1

    Wow magic in excel.
    Deepak sir kamaal ho gaya

  • @harishsharma2675
    @harishsharma2675 Рік тому +1

    Excellent Vid...I have a question...how can I show Table from excel without insert image option...need to kow formula or code

  • @uttamkumarsoni7077
    @uttamkumarsoni7077 Рік тому +2

    Sir if I am adding more than one email ID in to and more than two I'd in cc error is coming can you suggest solution.

  • @avijitmajumder5573
    @avijitmajumder5573 3 роки тому +1

    Nice Deepak Bhaiya

  • @AkbarAli-sx8jc
    @AkbarAli-sx8jc 3 роки тому +1

    Thanks for this. We need to send attachment too.

  • @AnilKumar-gj5xj
    @AnilKumar-gj5xj 3 роки тому +1

    Sir very nice vedio 👌👌👌👏.
    Sir agr ek click mai sabhi ko mail krni ho to kaise karege ?
    Koi file attachment bhi ho skti hai kya??
    Please.....
    Thanks

  • @RaviKumar-vr4yf
    @RaviKumar-vr4yf 3 роки тому

    I really liked this. Please make video for automatic mail send based on a condition being met.

  • @rajeevchikane8511
    @rajeevchikane8511 3 роки тому +1

    Very nice information sir . Very useful in daily work. Thanks

  • @Sparked_Visions
    @Sparked_Visions 2 роки тому +1

    good but i want fully automated system for sending emails from excel. thanks you sir

  • @tums7559
    @tums7559 2 роки тому

    Wow. this video just safe my life!

  • @prakashthakur6527
    @prakashthakur6527 3 роки тому +1

    Hi Deepak .... It's excellent... 👍

  • @vatanmehrotra8222
    @vatanmehrotra8222 3 роки тому +1

    Great thank you so much deepak ji.

  • @siddikjaangda2963
    @siddikjaangda2963 3 роки тому +1

    Excellent even for experienced

  • @vikashmourya8964
    @vikashmourya8964 3 роки тому +1

    Bhai maja aa gaya....😊😊😊

    • @SunilKumar-uv6zu
      @SunilKumar-uv6zu 3 роки тому

      Learn vba tutorials basic to advance - ua-cam.com/video/kKM85_FkC74/v-deo.html

  • @vinayak5637
    @vinayak5637 3 роки тому +1

    Superb
    Thank you Sir👍

  • @sureshmeena-ri6dd
    @sureshmeena-ri6dd 3 роки тому +1

    Very very nice one👍👍👍

  • @hareshengserviceworks2287
    @hareshengserviceworks2287 2 роки тому +2

    Deepak ji - Is there a limit to the number of words in body?

  • @microsoftsarker
    @microsoftsarker Рік тому

    Thanks brother great work

  • @praveenkakani2916
    @praveenkakani2916 2 роки тому

    Super explain karahoo bhai

  • @aajtakbhakti3823
    @aajtakbhakti3823 3 роки тому

    Excellent, हरे कृष्णा 🙏

  • @sammychishti-dropshipperaf2177
    @sammychishti-dropshipperaf2177 10 місяців тому +1

    Great Stuff Deepak. Is there anyway to connect this to gmail instead of Outlook? I tried everything but unable to figure this out. Also, we don't use outlook. It's opening a browser window but not opening the compose window for gmail. Is there anyway to resolve this? Please advise. Thanks.

  • @rajansv1
    @rajansv1 Рік тому

    Thanks sir, great presentation....

  • @harish.baghel
    @harish.baghel 3 роки тому +3

    Excellent tutorial. Is it possible to send data in table or attachment with this method?

  • @mohan8887
    @mohan8887 3 роки тому +1

    Amazing vedio

  • @ayeshabi5162
    @ayeshabi5162 3 місяці тому

    Great explanation sir

  • @environmentprotectionorgba5183
    @environmentprotectionorgba5183 11 місяців тому +1

    Mere pass ek combined Excel file hai vendor wise main usko alag alag vendor wise Excel sheet karna chahata hoo like 20 vendor 20 Excel sheet alag se unke data according

  • @muhammedsabirjahangir9155
    @muhammedsabirjahangir9155 3 роки тому +1

    Good video
    How can I use on lotus notes email application
    We've only lotus notes application.
    Thanks 😊

  • @shivamsoni3614
    @shivamsoni3614 3 роки тому +1

    Sir agar kisi party ka ledger tally erp9 se detail wise whatsapp kar sakte h excel se aur ledger excel me update hota rahe jo bhi entry tally me ho

  • @gargimitra2010
    @gargimitra2010 Рік тому +1

    Great lesson, very simple but useful. Thanks a lot 🤝 Can we schedule that email so that mails automatically sent from Outlook?

  • @harshitbheda4227
    @harshitbheda4227 3 роки тому +2

    Very nice vdo, sir but can we send attachments also

  • @akhileshvishwakarma7053
    @akhileshvishwakarma7053 3 роки тому

    You are amazing sir

  • @deepamanmappy
    @deepamanmappy 3 роки тому +2

    Wow that's awesome thanks for your wonderful concerns boss

  • @mehedihasan-kf4uy
    @mehedihasan-kf4uy Рік тому +1

    Many many thanks

  • @faheemrehmani167
    @faheemrehmani167 3 роки тому

    Yes this vedio is perfect to improve my knownledge

  • @Arsal1616
    @Arsal1616 3 роки тому +2

    Dear deepak if we need to attache clients ledger as an attachment or on email body then how can we do it. Pls help

  • @saralandlabhdayak4400
    @saralandlabhdayak4400 Місяць тому +1

    hi
    I have a problem: when I click 'Send Email,' it doesn't go to Outlook. Please solve the problem.

  • @GowithGopal
    @GowithGopal 3 роки тому +1

    Inhe send karne ke liye hr hyperlink pr click karna hoga... Lekin agar ye 1000 Rows ho ek sath kaise bheje

  • @muhammadazam9650
    @muhammadazam9650 2 місяці тому

    very informative

  • @manjunathkhajurkar9187
    @manjunathkhajurkar9187 Рік тому +1

    @DeepakEduWorld Please teach us Power automate

  • @AmitShaw
    @AmitShaw Рік тому +2

    Aisa koi option hai? Bahut sare dates hai random dates and random dates me mera Drafted Subject and Body automatically mentioned date me sent hota rahe given email address me? Like agar A2 me 1-5-20 ha ur A3 me 5-5-20 so 1 ko first wala email and 5th ko next email?

  • @manojbeniwal6501
    @manojbeniwal6501 2 роки тому

    nice information sir your nice job

  • @pkshah2606
    @pkshah2606 3 роки тому +1

    Very nice video

  • @GDe85
    @GDe85 Рік тому +1

    Can we add coloum pricipal and interest into this formula ?

  • @shafiqueulhassanchaudhry7048
    @shafiqueulhassanchaudhry7048 3 роки тому +1

    Good job friend

  • @crazyayush6682
    @crazyayush6682 3 роки тому +1

    Thank You so much sir

  • @tamang0077
    @tamang0077 3 роки тому +2

    Hi Deepak, thank you very much for what you are doing, and the way you explain. There is a problem in this sheet. I'm wanna use this for my official mail id. Which is not working with this formula kindly suggest me how I can use it with my office mail id. Thank you once again and Happy New Year

    • @DeepakEduWorld
      @DeepakEduWorld  3 роки тому

      Plz save excel workbook before applying formula

  • @mohammadfaisalirani3899
    @mohammadfaisalirani3899 3 роки тому +1

    Firstly thanks for your nice presentation. We learned from the video how to mail at a time one person along with one cc. If we want to send more then one , what Will be the formula.
    Waiting for your response.
    Mohammad Faisal Irani

  • @gyanapipasuasmyaham2966
    @gyanapipasuasmyaham2966 2 роки тому

    Excellent sir

  • @mrrajpoot9937
    @mrrajpoot9937 3 роки тому +1

    Thank you so much

  • @mayanabachhar9584
    @mayanabachhar9584 3 роки тому +1

    Excellent

  • @asadmasood3399
    @asadmasood3399 3 роки тому +1

    Excel attendance sheet mein aik month ke leave or dosary month ke leaves ko link kirny k leay ( k balance leaves kitni hyn) kiya kiryen gey

  • @gajendrasingh9486
    @gajendrasingh9486 Рік тому

    Very helpful..can we send attachments..kindly share with hyperlink

  • @maneeshanandigam4088
    @maneeshanandigam4088 2 роки тому

    It has good information, I am trying to add word document as mail body. Can you please help ?

  • @arunssairam
    @arunssairam 2 роки тому

    Hats off to you Sir, really great you are, please keep rocking 👍👍👍👍👍

  • @technical_zone
    @technical_zone 3 роки тому +1

    It's a very fantastic 😊 logic👍

  • @bestindianstreetfood8061
    @bestindianstreetfood8061 3 роки тому +1

    Love you sir

  • @archamp5420
    @archamp5420 3 роки тому

    Thank you! But hum chahte h ki jitna range hum excel pe select Kare wo Mera data mail body me bhi paste ho jaye ..
    Is pe ek video Bana so
    Thanks in Advance

  • @ayeshabi5162
    @ayeshabi5162 3 місяці тому

    Thank you so much...... 😊

  • @chandrasekarparamanandham5155
    @chandrasekarparamanandham5155 2 роки тому +1

    Hello sir my Excel sheet mail inbox window not opening after completing all formula.
    Please clarify whether your method work in excell 2007 or any add on required. ?

  • @sanjaychawda9749
    @sanjaychawda9749 Рік тому

    Hi , Very impressive idea... Pls try if we can upload 4-5 line items in 1 automatic mail link with mail body pasting.. That will help us

  • @asifsadheer5152
    @asifsadheer5152 3 роки тому +1

    Thanks sir,
    But if I also want to attach a specific excel file in a printable format to send email, than what to do?

  • @karthikrajgopal8627
    @karthikrajgopal8627 3 роки тому +1

    Nice video ji

  • @ashishshiriskar123
    @ashishshiriskar123 3 роки тому +1

    Superb 🙏👍

  • @Noumanjavedshamsi
    @Noumanjavedshamsi 3 роки тому +1

    Nice video

  • @tarunaluria3957
    @tarunaluria3957 3 роки тому +2

    realy helpfull..

  • @vmarkscreening4106
    @vmarkscreening4106 3 роки тому

    Thank u so much Deepak sir but I need one more help like attachment same in this entitled

  • @sandipkhanapure455
    @sandipkhanapure455 2 роки тому +1

    हँलो सर,
    आपका यह व्हिडीओ अच्छा लगा.
    लेकीन यह आँफिस-2007 में काम नही कर रहा है

  • @sstiruwa
    @sstiruwa 3 роки тому +1

    Amazing video. The trick is useful.
    Can we create a macro to send all emails on just one click.?
    If possible, please reply.

    • @DeepakEduWorld
      @DeepakEduWorld  3 роки тому

      Yes its possible... I ll publish video shortly 👍

  • @bjohnrajesh
    @bjohnrajesh 2 роки тому

    Perfect tammudu..well done..no doubts 👌