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.