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

  Рет қаралды 10,292

TechyTonics

TechyTonics

Күн бұрын

Пікірлер: 59
@techlabtamil
@techlabtamil 10 ай бұрын
The Item is not available to download.. please upload it..
@manotamil4219
@manotamil4219 8 ай бұрын
Fantastic work bro.....!
@vishaljindal6307
@vishaljindal6307 9 ай бұрын
Most loved video by me❤....tnx
@JLangomez
@JLangomez 6 ай бұрын
Great thanks! Have you tried to attach this excel data to a POWER AUTOMATE?
@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
@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.
@JLangomez
@JLangomez 10 ай бұрын
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
@sasaleh4 9 ай бұрын
Great job! Could you please re-upload the excel file in the link
@lennyrasq5681
@lennyrasq5681 9 ай бұрын
Very interesting. Can you share how you built the macro. I couldnt download the macro sheet
@BenHutchinson544
@BenHutchinson544 Жыл бұрын
@TechyTonics Hello, I tried downloading the excel but it says "This item might not exist or is no longer available". Please help
@Feels777
@Feels777 9 ай бұрын
hi mate can you send two attachments in one recipient?
@Stranger_photography
@Stranger_photography 7 ай бұрын
Can you share how you built the macro. I couldnt download the macro sheet
@Srikanth-lb3gl
@Srikanth-lb3gl 2 ай бұрын
unable to download your excel file its removed from drive
@user-ej5qo5pj2f
@user-ej5qo5pj2f 4 ай бұрын
Can you reshare the Excel? Its not available anymore.
@mariecarganilla4043
@mariecarganilla4043 8 ай бұрын
Can you please re-upload the document, it can't be downloaded as of now
@engtareq9279
@engtareq9279 8 ай бұрын
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.
@ishaaggarwal2665
@ishaaggarwal2665 7 ай бұрын
I'm getting runtime error 91 in . to = cell. Value...... Why? Pls help
@presetcollection456
@presetcollection456 Жыл бұрын
Can you do sir for multiple recipient/email address? Thank youuu this may help me.
@user-yd7lk1ou9k
@user-yd7lk1ou9k 8 ай бұрын
Hey Dude...!! it is osmm..!! can you share a macro code or Template . Thanks...!!
@raeesaqazi
@raeesaqazi Жыл бұрын
I’m unable to download the excel
@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"
@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
@Dmfwrld420
@Dmfwrld420 2 жыл бұрын
Sir, may i ask. Is it possible send mail merge mass email with bcc?
@techytonics
@techytonics 2 жыл бұрын
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 2 жыл бұрын
@@techytonics can you make it sir? I need now huhu. Im using macbook pro
@user-im6cl7py4b
@user-im6cl7py4b 7 ай бұрын
Can I get the code...???
@markjohnsoncatigtig1924
@markjohnsoncatigtig1924 7 ай бұрын
waiting the codes for macros
@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
@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
@vashyanthdubbala5501
@vashyanthdubbala5501 11 ай бұрын
can i get the code?
@janakiraman486
@janakiraman486 2 жыл бұрын
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.
@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
@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?
@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
@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
@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 2 жыл бұрын
Hai I tried this but file is not attaching 😭
@techytonics
@techytonics 2 жыл бұрын
Hi, have you pasted the file paths exactly as demonstrated? if yes, check the macros
@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 Жыл бұрын
​@@techytonicslink not work ..
@francobriones5276
@francobriones5276 Жыл бұрын
hi brother. Can i send unlimited number of email for a day without a problem?
@techytonics
@techytonics Жыл бұрын
Yes
How To Automatically Send Customized Emails With Attachments Using Excel Macros
19:40
Fake watermelon by Secret Vlog
00:16
Secret Vlog
Рет қаралды 14 МЛН
Bulk Emails | Word template as Outlook Body | Excel macro(vba)
16:30
Extreme Automation - Kamal Girdher
Рет қаралды 27 М.
Extract Emails from Outlook to Excel using Power Query
6:28
Chris Menard
Рет қаралды 10 М.
Send Personalized BULK Emails in Gmail (for FREE)!
6:50
Jeff Su
Рет қаралды 568 М.
Send Emails from Excel That Capture Data From Your Worksheet
13:27
Officeinstructor
Рет қаралды 36 М.
Automation: Send bulk emails using VBA and Outlook
13:35
PK: An Excel Expert
Рет қаралды 238 М.
Automated Multiple Emails with Multiple Attachments and "From" option
11:20
PK: An Excel Expert
Рет қаралды 72 М.