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/...

[@KingTechCodingClinic]

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]

Thanks for your valuable feedback🙏

[@mikeogieriakhi3394]

Can you please help me with this template?

[@rg08581]

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]

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"

[@caruanagiacomo3322]

HELLO, the king of vba thank you for all these working vba's

[@PKAnExcelExpert]

Glad you like them!

[@MultiChanelo]

Exactly what I needed : attaching as many files as needed to each email

[@PKAnExcelExpert]

Glad it was helpful

[@RahulM276]

Thank you very much. This has saved a lot much of time.

[@PKAnExcelExpert]

Glad it helped!

[@vishal332]

You are the boss of VBA coding

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@tangchion477]

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

[@vinayakchowdhary9049]

Thank you so much!! I was able to create one all because of you

[@PKAnExcelExpert]

Wonderful!

[@wolfenstein6288]

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

[@icy3779]

Thank you so much for this tutorial. Your explanations are very clear, thank you

[@PKAnExcelExpert]

Most welcome

[@jlvfr]

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!

[@Gadg3t_01]

Brilliant - I tried doing PowerAutomate but the pdf's got corrupted which was pointless - this worked - thanks a bunch.

[@PKAnExcelExpert]

Most welcome

[@carylbascon6260]

Thank you very much for this code and tutorial. So helpful!

[@PKAnExcelExpert]

Glad it was helpful!

[@bpissolati]

Greetings from Brazil! It is so useful!!!!

[@PKAnExcelExpert]

Thanks🙏

[@michelefrauendorf5770]

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!

[@ajayrathod7777]

You are a hero

[@PKAnExcelExpert]

Thanks🙏

[@KevinCastillousac]

You are a genius. Thanks for share.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@ghaivirendesingh]

Thanks PK sir this video is very useful , Sir can you also add the send WhatsApp option in this video .

[@sadsudathp]

Tks Friend. May you be able to create even better!

[@devangthakkar6847]

Superb dear Sir....... Thanks for update.

[@PKAnExcelExpert]

Always welcome

[@abivargheset]

Thank you

[@PKAnExcelExpert]

You're welcome

[@pandharinathjoshi6565]

Superb sir, really

[@PKAnExcelExpert]

So nice of you

[@Hos9_Shahin]

Thanks a lot!

[@PKAnExcelExpert]

You're welcome!

[@SyedMuzammilMahasanShahi]

Thanks for share.

[@PKAnExcelExpert]

My pleasure

[@maheshbabus9803]

Your videos compare to others is very good

[@PKAnExcelExpert]

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.

[@devenderkumar1220]

excellent!💕

[@PKAnExcelExpert]

Glad you like it!

[@DaveMir]

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: kzbin.info/www/bejne/l3WQnaJuZq5oeZY

[@sandeshpadigela2079]

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?

[@sanilkumar3288]

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: kzbin.info/www/bejne/p2rOhZqKnM2BaMk

[@trik3002]

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

[@elvayrah7136]

Hi, thank you for thisvery helpful tutorial. May I know where can i find the vba coding for this? 😊

[@PKAnExcelExpert]

Download link is in the description box

[@AbdulkarimLahmouni]

THX

[@PKAnExcelExpert]

Most welcome

[@yogitajain229]

Hi PK thanks for video could you show me it through Macros rather than coding

[@norasulaiman5907]

Great!!! I have been looking for this solution. Is there a possibility to send a reminder to those emails ?

[@aniketgharge6026]

Hello PK, can you create a video on how to write a dynamic email in this sheet ?

[@ashrafulbari4431]

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: kzbin.info/www/bejne/p2rOhZqKnM2BaMk

[@a2zjobsinformation600]

Hi pk, how to edit this one Please find the Attached the Report. regards Pk

[@likhithlicky2947]

Sir can you please tell how to add two or more mail in "TO" And "CC"... So tht it will be more benifit

[@pankajjaswani9155]

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

[@chewjs977]

thank you so much your video i am learning alots, but how add email signature ?

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please watch the below video for email signature: kzbin.info/www/bejne/p2rOhZqKnM2BaMk

[@chewjs977]

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.

[@kartiksaini2464]

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: kzbin.info/www/bejne/l3WQnaJuZq5oeZY

[@MuhammadBilal-bc9sg]

Is there way to put break between each mail? Few seconds

[@shenvimangu]

This bulk emailer will work for any domain email addresses? apart from gmail? I mean recipient email

[@irenexu823]

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?

[@kehindeolajide6870]

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]

Yes, absolutely. We need to modify the code accordingly.

[@khushraaz19310]

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

[@jayvadodariya4074]

Thank you for this I need to send multiple emails like for FROM MY APPLE IPAD . IS IT POSSIBLE IN IPAD?

[@pavithras4085]

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

[@manassehkisame6286]

Thanks...but this is not working for Outlook 365 since outlook desktop might become deprecated in a few years

[@Swayog-satsang]

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]

I got your point. I will try to create a video on this topic.

[@Swayog-satsang]

@@PKAnExcelExpert Thank you so much sir for considering my point.

[@suvroroy5957]

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

[@nandabadsiwal9324]

Pls sir it's important and also I want to send summary on the mail body

[@4._.9]

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]

Great suggestion! I will try to create a video on this topic.

[@4._.9]

@@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.

[@mathematicsclasseasyway9250]

Sir ek video library management par banaye Book issue and book return Please sir 🙏

[@alikhaled8960]

I want you to explain to us this same workbook but using WhatsApp Thank you very much

[@wolfenstein6288]

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: kzbin.info/www/bejne/aqTIkmmIpbqmeJY

[@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?

[@HADI-UPDATE]

जो भी इस वक़्त मेरा कमैंट् देख रहा है हम सब एक दूसरे के लिए अनजान है फिर भी मैं ईश्वर से प्रार्थना करता हु की आप के लाइफ में अगर कोई टेंशन चल रही हो तो वो दूर हो जाये | और आप हमेशा खुश रहे |☺️✨❤️

[@Sandeesh_Srikantam]

I wonder if you can combine this with bulk WhatsApp msgs sheet, that too while replacing outlook with gmail. Please give it a thought.

[@debamitrabhowmik8647]

@PK Is there a way to save the OFTs automatically to a predetermined local path after they are generated? Would really appreciate the help.

[@muhammadakramassi1476]

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 kzbin.info/www/bejne/p2rOhZqKnM2BaMk

[@ladlavlogs783]

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?

[@Kishor7]

Hello PK, if I have to share payslips of employees. How can share using same macro

[@SK_ROUTES]

Can we edit this for windows live mail

[@user-vx3gv8eq2h]

what if i have to send from Gmail and not from outlook? what to add in VBA code instead of "outlook.application"

[@NareshKumar-hh8cp]

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.

[@VS-rh8rq]

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

[@irinkhan8114]

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??

[@sharminbhai4844]

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

[@user-yw4up9gy4r]

Sir it showing an Complie error : Wrong number of arguments or invalid property assignment

[@rrkatheer]

How to add sc.shots in the body of the email in this scenario ? Please help.

[@toufiqurrahmantoufique9538]

Hi, Could you please share the excel download link? I couldn't download from the source. Thanks in advance

[@junagena9159]

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

[@andreeacurtis8533]

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 ?

[@divyashivhare5510]

Not able to download practice file... Pls help

[@v4videozz230]

@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?

[@lijojose9104]

Hi, Thank you for this amazing video. Could you please assist me on how we can add the signature to this email?

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please watch the below given video to add the signature in the email- kzbin.info/www/bejne/p2rOhZqKnM2BaMk

[@lijojose9104]

@@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]

@@PKAnExcelExpert Thank you. It worked.

[@user-ff7bl8ou6j]

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.

[@MurtazaVideos]

Please give option to use Thunderbird or any mail client.. because outlook is giving problems due to Gmail security

[@soaibaktar7818]

Their is available subject options

[@muhammadakramassi1476]

Thanks how we can add the names in the message body please

[@PKAnExcelExpert]

Yes, we can add. watch the below videos: kzbin.info/www/bejne/h4etdYSnjrKBmrM kzbin.info/www/bejne/p2rOhZqKnM2BaMk

[@youi3396]

What if I want to only send multiple information to 1 recipient in a single email?

[@nandabadsiwal9324]

Facing compile error Variable not defined Can you help me

[@trader420OP]

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]

Just put the semicolon (;) sapareted email id in To column.

[@sarendrayadav8195]

How can we add sign in outlook

[@rickyshukla3746]

Sir, what about the end number of pdf required to attach from a folder. How to do that

[@salamakhan9447]

Plz download this file, Automated Multiple Emails with Multiple Attachments and "From" option

[@salamakhan9447]

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.

[@sanjaytiwari2740]

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

[@pamyown]

Hi sir, can I know what can be done if we get "Run time error429" while sending the emails?

[@rg08581]

Hi sir can we do some formatting in the email body.. like underline, bold, italic, font colour etc

[@PKAnExcelExpert]

Please watch the below video: kzbin.info/www/bejne/p2rOhZqKnM2BaMk

[@ashishsrivastava2363]

Hi, How I can add date in body of e-mail? can you quickly respond to my question

[@selvarasan.v7246]

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]

Great suggestion! I will try to create a video on this topic.

[@sushilverma8390]

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

[@sanjaydeshmukh5539]

Hello sir, Thank you for sharing. Can we send bulk email through web browser Gmail? not a outlook

[@PKAnExcelExpert]

Yes, you can. I will create a video on this topic

[@DhruvDua88]

@@PKAnExcelExpert Please do create a video on this topic using CDO to send emails without outlook.

[@sanjaytiwari2740]

Sir muze form16 bhejan hai pan base p kaise karu

[@chintuchin5824]

I want to reply different email id with different attachment in bulk method

[@ajinkyachavan4025]

Please Make a video how to send whatssup messages at a single click

[@mayurrajude]

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: kzbin.info/www/bejne/l3WQnaJuZq5oeZY kzbin.info/www/bejne/p2rOhZqKnM2BaMk

[@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

[@RNDInfoUpdate]

Why i can't send the email ??

[@GovindGaganSai]

Can you please show how to add signatures also in the mail 0:11

[@PKAnExcelExpert]

Please watch below video: kzbin.info/www/bejne/p2rOhZqKnM2BaMk

[@akki7336]

can you make same vba excel instead of Outlook i want for gmail??

[@PKAnExcelExpert]

Great suggestion! I will try to create a video on this topic.