No video

How To Batch-Email Automatically with Attachments Using Excel and Outlook only

At times, you have so many emails to send, they will have to be accompanied by their corresponding attachments, you don't have the resources to automate that, What would you do? Follow the tutorial as it takes you step-by-step into how you can automate that process by just using excel and outlook app.
Make sure developer option is enabled
Ensure macros are enables too - Trust center.
Subscribe to the channel
/ @techytonics
Download the excel here and follow along
1drv.ms/x/s!An...
=====================================================================
Chapters
00:00 - Intro
00:58 - Overview
02:11 - Prepare the excel template
02:30 - Copy file paths
03:08 - Extract names
04:28 - Vlookup
06:28 - Enable developer options and macros
06:59 - Create macros for Automail
09:53 - Let's create a button for the macro
10:51 - Move data into the template
14:24 - Autro
=========================================================
For business inquiries get in touch.
techy.tonics01@gmail.com.
Links included in the description might be affiliate links. If you purchase a product with the links that I provide, I might receive a small commission. There is no additional charge to you. Thank you for supporting my channel so I can continue to provide you with free content every so often.

Пікірлер: 59

  • @AliHussein-oy6fw
    @AliHussein-oy6fwАй бұрын

    Great video! However would appreciate if you could send the Macros file as the link provided no longer exists. Thank you

  • @JLangomez
    @JLangomez5 ай бұрын

    Great thanks! Have you tried to attach this excel data to a POWER AUTOMATE?

  • @techlabtamil
    @techlabtamil9 ай бұрын

    The Item is not available to download.. please upload it..

  • @manotamil4219
    @manotamil42198 ай бұрын

    Fantastic work bro.....!

  • @vishaljindal6307
    @vishaljindal63078 ай бұрын

    Most loved video by me❤....tnx

  • @anggekim7610
    @anggekim7610 Жыл бұрын

    Hello! May I have a copy of your excel? It says "This item might not exist or is no longer available" when I clicked the link.

  • @Srikanth-lb3gl
    @Srikanth-lb3gl2 ай бұрын

    unable to download your excel file its removed from drive

  • @JLangomez
    @JLangomez9 ай бұрын

    Hi This video was very helpful for us. Thank you for sharing ideas. I got the excel file ready, but I cannot have the formula you have, it says "This item might not exist or is no longer available". Can you I have macros code?

  • @sasaleh4
    @sasaleh48 ай бұрын

    Great job! Could you please re-upload the excel file in the link

  • @Stranger_photography
    @Stranger_photography7 ай бұрын

    Can you share how you built the macro. I couldnt download the macro sheet

  • @BenHutchinson544
    @BenHutchinson54411 ай бұрын

    @TechyTonics Hello, I tried downloading the excel but it says "This item might not exist or is no longer available". Please help

  • @mariecarganilla4043
    @mariecarganilla40437 ай бұрын

    Can you please re-upload the document, it can't be downloaded as of now

  • @lennyrasq5681
    @lennyrasq56818 ай бұрын

    Very interesting. Can you share how you built the macro. I couldnt download the macro sheet

  • @user-ej5qo5pj2f
    @user-ej5qo5pj2f3 ай бұрын

    Can you reshare the Excel? Its not available anymore.

  • @Feels777
    @Feels7778 ай бұрын

    hi mate can you send two attachments in one recipient?

  • @presetcollection456
    @presetcollection456 Жыл бұрын

    Can you do sir for multiple recipient/email address? Thank youuu this may help me.

  • @engtareq9279
    @engtareq92798 ай бұрын

    Hi Can you help in this? the link leaded me to page with this message " This item might have been deleted, expired, or you might not have permission to view it. Contact the owner of this item for more information.

  • @user-yd7lk1ou9k
    @user-yd7lk1ou9k8 ай бұрын

    Hey Dude...!! it is osmm..!! can you share a macro code or Template . Thanks...!!

  • @ishaaggarwal2665
    @ishaaggarwal26656 ай бұрын

    I'm getting runtime error 91 in . to = cell. Value...... Why? Pls help

  • @MuhammadArslan-dz9fi
    @MuhammadArslan-dz9fi Жыл бұрын

    Hi thanks its a great tutorial. Can I attach 2 attachments with single email if yes can you help me with it.

  • @techytonics

    @techytonics

    Жыл бұрын

    Yes you can actually send more than 2 documents, you just paste their file paths on the columns to the right of the File "Path folder"

  • @raeesaqazi
    @raeesaqazi Жыл бұрын

    I’m unable to download the excel

  • @daigooribunoki560
    @daigooribunoki560 Жыл бұрын

    Hey, thanks for your video It helps a lot. But I am trying to put an image (my signature) at the end of the text in the body of the mail and I cannot find how. Could you help ?

  • @techytonics

    @techytonics

    Жыл бұрын

    I will create another file that can be able to grab your saved signature and append it to the email

  • @Dmfwrld420
    @Dmfwrld420 Жыл бұрын

    Sir, may i ask. Is it possible send mail merge mass email with bcc?

  • @techytonics

    @techytonics

    Жыл бұрын

    Yes, very possible. You just add a code for bcc in the macro. I will do a video on that in the future.

  • @Dmfwrld420

    @Dmfwrld420

    Жыл бұрын

    @@techytonics can you make it sir? I need now huhu. Im using macbook pro

  • @thesomeonegerm
    @thesomeonegerm Жыл бұрын

    Great effort man How can i remove the file attachment/file path? I just want to send emails without attachments Thanks brother

  • @techytonics

    @techytonics

    Жыл бұрын

    Just leave the file path column empty or you can just modify the macros

  • @thesomeonegerm

    @thesomeonegerm

    Жыл бұрын

    @@techytonics whenever i leave it empty it doesn't send the email Please tell me how to edit the code man Just for this it would be a great help

  • @christopherliarakos2848
    @christopherliarakos2848 Жыл бұрын

    @techytonics is it possible to enter the email I want the emails to be sent from? or is it whatever is logged in on the outlook app? please help***

  • @jayemwong8649
    @jayemwong8649 Жыл бұрын

    Hi need help, just downloaded. your file and replace it with my data unfortunately it's not sending and I can't see anything in my Outbox, Appreciate your help with this.

  • @techytonics

    @techytonics

    Жыл бұрын

    Go to VBA and make sure the code is not broken

  • @user-im6cl7py4b
    @user-im6cl7py4b6 ай бұрын

    Can I get the code...???

  • @vashyanthdubbala5501
    @vashyanthdubbala550110 ай бұрын

    can i get the code?

  • @markjohnsoncatigtig1924
    @markjohnsoncatigtig19246 ай бұрын

    waiting the codes for macros

  • @databrainery9676
    @databrainery9676 Жыл бұрын

    Hello thanks for a useful video. how we can modify the code so that the subject matter is in Word file, so that we can have FONT of our own choice.

  • @techytonics

    @techytonics

    Жыл бұрын

    You can modify the macros such that instead of calling the popup, it references a particular column or cell

  • @databrainery9676

    @databrainery9676

    Жыл бұрын

    @@techytonics How please

  • @janakiraman486
    @janakiraman4862 жыл бұрын

    Is it possible to send recurring email like this ? I need to send remainder email with file attached for more than 500 ppl monthly. How can i do that ? If possible please make video.

  • @techytonics

    @techytonics

    2 жыл бұрын

    Hi, it's actually possible though this will require scripting.

  • @reehasheniapkunasekaran9772
    @reehasheniapkunasekaran9772 Жыл бұрын

    Hi, having some issues. I tried sending 10 emails but only 5 of my recipients received their emails. some are missing.May I know how to solve this?

  • @techytonics

    @techytonics

    Жыл бұрын

    Well, that shouldn't happen at all. Remove your data in the excel, send it to me and I will try to troubleshoot the code

  • @reehasheniapkunasekaran9772

    @reehasheniapkunasekaran9772

    Жыл бұрын

    @@techytonics may I have your email address pls?

  • @KimberlySalazar-ug4tt
    @KimberlySalazar-ug4tt Жыл бұрын

    Hi how can i modify each mail subject?

  • @techytonics

    @techytonics

    Жыл бұрын

    If you want to have a different subject for each email, then edit the Macro to refer the subject from a column in the sheet. Let me make the template, I will share

  • @presetcollection456
    @presetcollection456 Жыл бұрын

    Hello how about a multiple email address in 1 email. I have error doing this my friend. :(

  • @presetcollection456

    @presetcollection456

    Жыл бұрын

    It says outlook does not recognize one or more names

  • @sherifsayed3886
    @sherifsayed3886 Жыл бұрын

    Can you please send macro variable

  • @techytonics

    @techytonics

    Жыл бұрын

    There is a link in the description, download the excel and change it

  • @user-bb6mi3zp5g

    @user-bb6mi3zp5g

    11 ай бұрын

    ​@@techytonicslink not work ..

  • @jankutac9753
    @jankutac9753 Жыл бұрын

    Damn I don't understand it. Too complicated :-D But basically if I download your sample excel, I just need to put in my content and it will work right?

  • @techytonics

    @techytonics

    Жыл бұрын

    Yes, you only need to change the email body in the macros code

  • @jankutac9753

    @jankutac9753

    Жыл бұрын

    @@techytonics it was still way too complicated for me, but I gave the video to a more tech-minded friend and he got it. Basically enable developer options, and then in the upper left corner click "visual basic".

  • @jankutac9753

    @jankutac9753

    Жыл бұрын

    @@techytonics just one more thing: How do we create a second variable field? There's sth with (0,-1) that defines the field. But when we copy it to have a second variable field, the whole thing doesn't work anymore

  • @msccs3298
    @msccs3298 Жыл бұрын

    Hai I tried this but file is not attaching 😭

  • @techytonics

    @techytonics

    Жыл бұрын

    Hi, have you pasted the file paths exactly as demonstrated? if yes, check the macros

  • @francobriones5276
    @francobriones5276 Жыл бұрын

    hi brother. Can i send unlimited number of email for a day without a problem?

  • @techytonics

    @techytonics

    Жыл бұрын

    Yes