Automated Multiple Emails with Multiple Attachments and "From" option
#BulkEmail #VBAAutomation
Hello Friends,
In this video, you will learn how to create an Automated Bulk Emailer with Multiple Attachments and the "From" option. You can choose the Send or display option buttons. We have given a Skip column wherein you can put "Yes" if you want to skip the email for a particular line.
We have given the "From" option also. In column C of the template. If you are using multiple mailboxes in your outlook then you can decide from which mailbox you want to send the email.
Download the practice files from the below link:
www.pk-anexcel...
See how to send bulk email part 1 of this video:
• Automation: Send bulk ...
See our more Power BI videos:
• Power BI Tutorial
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Free Project Management Dashboard
www.pk-anexcel...
Download the Calendar Control in VBA from below link
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...
Пікірлер: 204
My mentor with another amazing tutorial again. You have made VBA tutorials so easy for me and I'm now enjoying every bit of it. My channel too is growing rapidly because of you. I can't thank you enough
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback🙏
@mikeogieriakhi3394
3 ай бұрын
Can you please help me with this template?
Sir this is very very helpful... U not only explained but also shared the entire file for practice..... God bless you and your team 👍
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback🙏
@druberry6998
Жыл бұрын
@@PKAnExcelExpert Hi, i am using your Excel file right now but I am having issues attaching multiple files... error message: run time error. "cannot find this file. verify the path and file name are correct"
HELLO, the king of vba thank you for all these working vba's
@PKAnExcelExpert
Жыл бұрын
Glad you like them!
thank you for yr video, I have stuck at a point where the attachment process stopped when running on empty cell. I figured it out after watching yr video. Thank you again. it definitely helps a lot.
@PKAnExcelExpert
Жыл бұрын
Glad it helped
Exactly what I needed : attaching as many files as needed to each email
@PKAnExcelExpert
Жыл бұрын
Glad it was helpful
You are the boss of VBA coding
@PKAnExcelExpert
Жыл бұрын
Thanks for your valuable feedback🙏
Thank you very much. This has saved a lot much of time.
@PKAnExcelExpert
Ай бұрын
Glad it helped!
Thank you so much!! I was able to create one all because of you
@PKAnExcelExpert
7 ай бұрын
Wonderful!
This is the best bulk sending email vba excel ever created, kudos 👏
@PKAnExcelExpert
Жыл бұрын
Glad you think so!
@wolfenstein6288
Жыл бұрын
@@PKAnExcelExpert this actually helping me a lot, I have to send 500+ invoices with multiple attachments to clients , which usually takes almost 3 days but now with this excel it takes only minutes
@user-ff7bl8ou6j
Жыл бұрын
@@wolfenstein6288 How do you send 500 emails in outlook. I have a problem sending 200 on outlook or gmail. I want to send more on outlook
Thank you so much for this tutorial. Your explanations are very clear, thank you
@PKAnExcelExpert
Жыл бұрын
Most welcome
An excelent solution and idiot-proof to use. Thank you very much! I tried to download the zip file, but it seems to be corrupted, so I used your other, more basic file. Life saver!
Greetings from Brazil! It is so useful!!!!
@PKAnExcelExpert
Жыл бұрын
Thanks🙏
Thanks PK sir this video is very useful , Sir can you also add the send WhatsApp option in this video .
Brilliant - I tried doing PowerAutomate but the pdf's got corrupted which was pointless - this worked - thanks a bunch.
@PKAnExcelExpert
Жыл бұрын
Most welcome
Thank you very much for this code and tutorial. So helpful!
@PKAnExcelExpert
Жыл бұрын
Glad it was helpful!
hello sir I tried to download the file attached in the description, but it can't be downloaded (either virus or corrupt). Kindly share another link to download the file. Regards
You are a genius. Thanks for share.
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback🙏
Superb dear Sir....... Thanks for update.
@PKAnExcelExpert
2 жыл бұрын
Always welcome
You are a hero
@PKAnExcelExpert
Жыл бұрын
Thanks🙏
Hi, thank you for thisvery helpful tutorial. May I know where can i find the vba coding for this? 😊
@PKAnExcelExpert
2 ай бұрын
Download link is in the description box
Tks Friend. May you be able to create even better!
Thanks PK! I really enjoy the way you explain the stuff. Is it possible to add an image at the email's body?
@PKAnExcelExpert
Жыл бұрын
Yes, absolutely. Please watch the below video: kzread.info/dash/bejne/k3hhztFxYaybc5c.html
Superb sir, really
@PKAnExcelExpert
2 жыл бұрын
So nice of you
Great!!! I have been looking for this solution. Is there a possibility to send a reminder to those emails ?
This is a really good trick, thanks for taking the time to share knowledge, I do have a question extent of this. 1) We have employee performance data with multiple details, 2) we get this data week basis 2) We select each employee's data from the validation list 3) We take this screenshot 4) Copy the screenshot in an email 5) Send that to employee - I see challenge to select 20 employees from data validation list and copying screenshot, is there any way we can work on this?
Thanks a lot!
@PKAnExcelExpert
2 жыл бұрын
You're welcome!
Sir can you please tell how to add two or more mail in "TO" And "CC"... So tht it will be more benifit
Thanks PK, I have done a few email macro's and I love the simplicity, explanations and sharing the code. Great!
@PKAnExcelExpert
Жыл бұрын
Glad it was helpful!
Thank you
@PKAnExcelExpert
Жыл бұрын
You're welcome
This bulk emailer will work for any domain email addresses? apart from gmail? I mean recipient email
Thanks for share.
@PKAnExcelExpert
2 жыл бұрын
My pleasure
Your videos compare to others is very good
@PKAnExcelExpert
2 жыл бұрын
Thank you so much 😀
@user-ff7bl8ou6j
Жыл бұрын
@@PKAnExcelExpert Actually it is the best but want to change code for yahoo mail. How do I do that.
Hello PK, can you create a video on how to write a dynamic email in this sheet ?
Hi pk, how to edit this one Please find the Attached the Report. regards Pk
Very useful template. I am using this almost everyday. How i can use outlook signature on this vba? please help.
@PKAnExcelExpert
Жыл бұрын
Please watch the below video: kzread.info/dash/bejne/o22ftsmNl8u0Yso.html
Thank you sir for this video, it's working fine but from coloum i used multiple emails but going to from one email which is set as default on outlook, I want to send email from different email, plz suggest
thank you so much your video i am learning alots, but how add email signature ?
@PKAnExcelExpert
6 ай бұрын
Thanks for your valuable feedback. Please watch the below video for email signature: kzread.info/dash/bejne/o22ftsmNl8u0Yso.html
@chewjs977
6 ай бұрын
Hello , thank you much the video ,after i added the email signature yes able to display , but only 1email come out if got 10 email to send ..not sure where gone wrong the coding , appriciate if you able to teach me ? .thank you so much.
Thank u so much for this vedio.This is very helpful fo me.i have one request make one vedio the same mail format how to add signature in outlook .Thanks
@PKAnExcelExpert
Жыл бұрын
Please watch below given video: kzread.info/dash/bejne/o22ftsmNl8u0Yso.html
Is there way to put break between each mail? Few seconds
Hi PK thanks for video could you show me it through Macros rather than coding
excellent!💕
@PKAnExcelExpert
Жыл бұрын
Glad you like it!
Thank you, this is very helpful. However how did you create the "Send Email" and "Get File Path" button? Can you please share, thank you!
@PKAnExcelExpert
Жыл бұрын
Please watch the complete video. You can download the template file also to see the code. Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
@irenexu823
Жыл бұрын
@@PKAnExcelExpert Thank you so much! Sorry I have another question, do you know if we can "bold" and "add link" to part of the text in the "body" column?
Thank you very much for your tutorial. I just want to ask how i can rename the regards part? here shows regards Rk. i want to add something more here. Thank you
Thank you for this I need to send multiple emails like for FROM MY APPLE IPAD . IS IT POSSIBLE IN IPAD?
This is an excellent video. Thank you so much for simplifying VBA coding for me. I really appreciate this. Quick que, is it possible to replace the attachments with a dynamic url (hyperlink)? thanks
@PKAnExcelExpert
2 жыл бұрын
Yes, absolutely. We need to modify the code accordingly.
Can we turn the practice file into our own file? Like changing the attachment location with a little modification and inserting our own emails that we want to send without changing the macros?
This video is really helpful. Kindly help me with How to add a table in the body of this Email?
@PKAnExcelExpert
Жыл бұрын
Please watch the below video: kzread.info/dash/bejne/k3hhztFxYaybc5c.html
Hello PK, if I have to share payslips of employees. How can share using same macro
Thnaks PK, lifesaver tool. i want to ask is there a limitation in terms of how many mails we can send i.e how many rows we can use? Also , most important how can I maintain my mail formatting such as bold, italics, colored font since after making changes in the Body cell, I am still getting mail without any formating. Please help.
Thanks...but this is not working for Outlook 365 since outlook desktop might become deprecated in a few years
Dear PK: Can you help to demonstrate with Power Automate using the same examples? My office restricts the use of macros. Would greatly appreciate your help. Thank you very much.
@PKAnExcelExpert
2 жыл бұрын
Great suggestion! I will try to create a video on this topic.
@4._.9
2 жыл бұрын
@@PKAnExcelExpert Dear PK: Thank you so much. Looking forward to the video. Greatly appreciated.
@4._.9
Жыл бұрын
Dear PK: I’m wondering if I have missed the video demo using Power Automate. Please help. Thank you so much.
Thank you very much for this code and video Very helpful and detailed explanation Can you please let me know how to show msgbox as "Email already sent" If the status is done?
@PKAnExcelExpert
Жыл бұрын
Will upload soon
I wonder if you can combine this with bulk WhatsApp msgs sheet, that too while replacing outlook with gmail. Please give it a thought.
Instead of using multiple columns for multiple attachments, you can use a single column where the user can quickly select the attachment and the path will appear in the column cell.
@wolfenstein6288
Жыл бұрын
How ?
@wolfenstein6288
Жыл бұрын
I want to reverse it, i want to add multiple file paths in single column
@pankajjaswani9155
Жыл бұрын
@@wolfenstein6288 I had also replied the same please read once again. I clearly suggested to use a single column to select the multiple attachment's path by selecting multiple files at the same time in a single cell.
@ketansharma9114
Жыл бұрын
Do you know how we can make body more creative coz there is no option
Pls sir it's important and also I want to send summary on the mail body
what if i have to send from Gmail and not from outlook? what to add in VBA code instead of "outlook.application"
When my email id is wrong (i.e, not found in mail address book),the macro stops running. What can be done to prevent thia as this prevents from sending my others mails to users in the same column??
@PK Is there a way to save the OFTs automatically to a predetermined local path after they are generated? Would really appreciate the help.
Can we edit this for windows live mail
Hi, Could you please share the excel download link? I couldn't download from the source. Thanks in advance
Hi PK. Firstly, i cannot thank you enough for your video. The macro works as long as i have my emails displayed. However, when i change msg.Display to msg.Send, it gives me an error message: "Object variable or With block variable not set." Can you please help ?
Plz download this file, Automated Multiple Emails with Multiple Attachments and "From" option
@salamakhan9447
27 күн бұрын
Please make it clear whether the file is available for download or not. Also, provide a straightforward method to download the file without any confusion or misleading information.
i dont want to add attachment but i have some dynamic content that i want to directly paste in body. How can it be done
@PK is there any way to multiselect attachments...i means in cell 1 for attachment 1, if i select 2 different files, then the file paths shoud be copied to attachment 1 and to attachment 2 automatically and so on....is there a way to do that..if so can u tell me?
Thanks PK, this is great! Need help for enhancing this with my signature but struggle to do. I'm trying to integrate your other tutorial of with signature but keep on getting issue. If possible to provide me a copy of VBA script for that?
@junagena9159
Жыл бұрын
This is not working... Sub Send_Email_with_Signature() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("Bulk Email") Dim i As Integer Dim OA As Object Dim msg As Object Dim sign As String Set OA = CreateObject("outlook.application") Dim last_row As Integer last_row = sh.Range("D" & Application.Rows.Count).End(xlUp).Row For i = 6 To last_row If UCase(sh.Range("A" & i).Value) "YES" Then Set msg = OA.createitem(0) With msg .display End With sign = msg.htmlbody If sh.Range("C" & i).Value "" Then msg.SentOnBehalfOfName = sh.Range("C" & i).Value msg.To = sh.Range("D" & i).Value msg.cc = sh.Range("E" & i).Value msg.Subject = sh.Range("F" & i).Value msg.body = sh.Range("G" & i).Value If sh.Range("M" & i).Value "" Then msg.attachments.Add sh.Range("M" & i).Value End If If sh.Range("N" & i).Value "" Then msg.attachments.Add sh.Range("N" & i).Value End If If sh.Range("O" & i).Value "" Then msg.attachments.Add sh.Range("O" & i).Value End If If sh.Range("A1").Value = 1 Then msg.send Else msg.display End If sh.Range("B" & i).Value = "Done" End If Next i MsgBox "Process Completed!!!", vbInformation End Sub Sub Get_File_Path() Dim file_path As String file_path = Application.GetOpenFilename(MultiSelect:=False) If file_path "False" Then Selection.Value = file_path End If End Sub
Great videos. I got a security warning 'Another application trying to gain access Deny.. Allow' From excel to outlook How do i get rid of it to send bulk mails
Not able to download practice file... Pls help
Can add date time column to schedule auto email on a specific date and time?
@PKAnExcelExpert
Жыл бұрын
Yes, you can. Please watch the relative below video: kzread.info/dash/bejne/ZqeZw5iLoLjZcpc.html
@wolfenstein6288
Жыл бұрын
Thanks for the link, just want to ask you is it possible to add date/year column in this automatic bulk email sheet also so that each email can be sent on desired date and time?
How do I send using VBA " Automated Multiple Emails with Multiple Attachments and "From" option" not through Gmail or outlook but yahoo or other mail that does not cut you off.
Superb, Tons of Thanks, I had followed your older video of Project Issue Tracker and working accordingly my requirement, Sir can you guide how to find out difference of two large size database with multiple column by Vlookup using VBA. AS I need to compare two column from different workbook and find out Pending Records to send reminder email. If you can share your email ID or WA contact I will share my datafiles to explain properly. Thank you so much
@PKAnExcelExpert
2 жыл бұрын
I got your point. I will try to create a video on this topic.
@Swayog-satsang
2 жыл бұрын
@@PKAnExcelExpert Thank you so much sir for considering my point.
Sir it showing an Complie error : Wrong number of arguments or invalid property assignment
How to add sc.shots in the body of the email in this scenario ? Please help.
Please give option to use Thunderbird or any mail client.. because outlook is giving problems due to Gmail security
If you can make or guide how to make the text body dynamic that will be great please
@PKAnExcelExpert
Жыл бұрын
Please watch below video will help you kzread.info/dash/bejne/o22ftsmNl8u0Yso.html
Is it possible to add multiple email in TO section of outlook instead of send separate email to each individuals? If yes please create a video on it. Thank You
@PKAnExcelExpert
2 жыл бұрын
Just put the semicolon (;) sapareted email id in To column.
THX
@PKAnExcelExpert
Жыл бұрын
Most welcome
Sir, what about the end number of pdf required to attach from a folder. How to do that
Sir i want to send form 16 tds through mail to 1000 employee but problem is all data is on pan base how i can mail on one click
How can we add sign in outlook
Thanks how we can add the names in the message body please
@PKAnExcelExpert
Жыл бұрын
Yes, we can add. watch the below videos: kzread.info/dash/bejne/g4p-prOqibC0lLQ.html kzread.info/dash/bejne/o22ftsmNl8u0Yso.html
जो भी इस वक़्त मेरा कमैंट् देख रहा है हम सब एक दूसरे के लिए अनजान है फिर भी मैं ईश्वर से प्रार्थना करता हु की आप के लाइफ में अगर कोई टेंशन चल रही हो तो वो दूर हो जाये | और आप हमेशा खुश रहे |☺️✨❤️
Facing compile error Variable not defined Can you help me
Hi, How I can add date in body of e-mail? can you quickly respond to my question
What if I want to only send multiple information to 1 recipient in a single email?
Hi sir, can I know what can be done if we get "Run time error429" while sending the emails?
Hi, Thank you for this amazing video. Could you please assist me on how we can add the signature to this email?
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback. Please watch the below given video to add the signature in the email- kzread.info/dash/bejne/o22ftsmNl8u0Yso.html
@lijojose9104
2 жыл бұрын
@@PKAnExcelExpert Thank you. I tried to add the sign variable and the code to this one but it's showing html code instead of the signature. Please help me to add the signature to this code. Thanks a ton.
@lijojose9104
2 жыл бұрын
@@PKAnExcelExpert Thank you. It worked.
Sir ek video library management par banaye Book issue and book return Please sir 🙏
Hi sir can we do some formatting in the email body.. like underline, bold, italic, font colour etc
@PKAnExcelExpert
Жыл бұрын
Please watch the below video: kzread.info/dash/bejne/o22ftsmNl8u0Yso.html
Sir please help us to share the vba code and micro enable workbook as above example shared Thanks
@PKAnExcelExpert
Жыл бұрын
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
Most usefull but I need lot group pdf file automatically zip file covered based on condition how to writing VBA code I am starting stage in VBA programming languages please can help , please put on one video class
@PKAnExcelExpert
2 жыл бұрын
Great suggestion! I will try to create a video on this topic.
I want you to explain to us this same workbook but using WhatsApp Thank you very much
Their is available subject options
Hello sir, Thank you for sharing. Can we send bulk email through web browser Gmail? not a outlook
@PKAnExcelExpert
2 жыл бұрын
Yes, you can. I will create a video on this topic
@DhruvDua88
2 жыл бұрын
@@PKAnExcelExpert Please do create a video on this topic using CDO to send emails without outlook.
I want to reply different email id with different attachment in bulk method
Sir muze form16 bhejan hai pan base p kaise karu
Why i can't send the email ??
Can you please show how to add signatures also in the mail 0:11
@PKAnExcelExpert
Жыл бұрын
Please watch below video: kzread.info/dash/bejne/o22ftsmNl8u0Yso.html
hello Sir, is the website down it is not opening up and i cannot download the file for practice
@PKAnExcelExpert
Жыл бұрын
It is working. Please check it now www.pk-anexcelexpert.com/automated-multiple-emails-with-multiple-attachments-and-from-option/
how we add mail body data like when paste outlook mail body paste Option Is HTML Formate Bitmap Option We want select bitmap
@PKAnExcelExpert
Жыл бұрын
Please watch below given videos: kzread.info/dash/bejne/k3hhztFxYaybc5c.html kzread.info/dash/bejne/o22ftsmNl8u0Yso.html
@mayurrajude
Жыл бұрын
@@PKAnExcelExpert it's helpful..some region data like MP UP AP KRN BNG when we select one region copy the data range nd to paste it with a new sheet and save sheet also Range Data paste on it outlook bitmap data
@mayurrajude
Жыл бұрын
Hye are u there or r u stuck
can you make same vba excel instead of Outlook i want for gmail??
@PKAnExcelExpert
2 жыл бұрын
Great suggestion! I will try to create a video on this topic.