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
Great video! However would appreciate if you could send the Macros file as the link provided no longer exists. Thank you
Great thanks! Have you tried to attach this excel data to a POWER AUTOMATE?
The Item is not available to download.. please upload it..
Fantastic work bro.....!
Most loved video by me❤....tnx
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.
unable to download your excel file its removed from drive
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?
Great job! Could you please re-upload the excel file in the link
Can you share how you built the macro. I couldnt download the macro sheet
@TechyTonics Hello, I tried downloading the excel but it says "This item might not exist or is no longer available". Please help
Can you please re-upload the document, it can't be downloaded as of now
Very interesting. Can you share how you built the macro. I couldnt download the macro sheet
Can you reshare the Excel? Its not available anymore.
hi mate can you send two attachments in one recipient?
Can you do sir for multiple recipient/email address? Thank youuu this may help me.
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.
Hey Dude...!! it is osmm..!! can you share a macro code or Template . Thanks...!!
I'm getting runtime error 91 in . to = cell. Value...... Why? Pls help
Hi thanks its a great tutorial. Can I attach 2 attachments with single email if yes can you help me with it.
@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"
I’m unable to download the excel
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
Жыл бұрын
I will create another file that can be able to grab your saved signature and append it to the email
Sir, may i ask. Is it possible send mail merge mass email with bcc?
@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
Жыл бұрын
@@techytonics can you make it sir? I need now huhu. Im using macbook pro
Great effort man How can i remove the file attachment/file path? I just want to send emails without attachments Thanks brother
@techytonics
Жыл бұрын
Just leave the file path column empty or you can just modify the macros
@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
@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***
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
Жыл бұрын
Go to VBA and make sure the code is not broken
Can I get the code...???
can i get the code?
waiting the codes for macros
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
Жыл бұрын
You can modify the macros such that instead of calling the popup, it references a particular column or cell
@databrainery9676
Жыл бұрын
@@techytonics How please
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
2 жыл бұрын
Hi, it's actually possible though this will require scripting.
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
Жыл бұрын
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
Жыл бұрын
@@techytonics may I have your email address pls?
Hi how can i modify each mail subject?
@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
Hello how about a multiple email address in 1 email. I have error doing this my friend. :(
@presetcollection456
Жыл бұрын
It says outlook does not recognize one or more names
Can you please send macro variable
@techytonics
Жыл бұрын
There is a link in the description, download the excel and change it
@user-bb6mi3zp5g
11 ай бұрын
@@techytonicslink not work ..
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
Жыл бұрын
Yes, you only need to change the email body in the macros code
@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
Жыл бұрын
@@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
Hai I tried this but file is not attaching 😭
@techytonics
Жыл бұрын
Hi, have you pasted the file paths exactly as demonstrated? if yes, check the macros
hi brother. Can i send unlimited number of email for a day without a problem?
@techytonics
Жыл бұрын
Yes