Automated Multiple Emails with Multiple Attachments and "From" option
Вставка
- Опубліковано 29 вер 2024
- #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/...
This is the best bulk sending email vba excel ever created, kudos 👏
Glad you think so!
@@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
@@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
Hi pk, how to edit this one Please find the Attached the Report. regards Pk
Thanks PK! I really enjoy the way you explain the stuff. Is it possible to add an image at the email's body?
Yes, absolutely. Please watch the below video:
ua-cam.com/video/aD-lo81I5C4/v-deo.html
Thanks a lot!
You're welcome!
Hi PK thanks for video could you show me it through Macros rather than coding
what if i have to send from Gmail and not from outlook? what to add in VBA code instead of "outlook.application"
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?
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
Thanks...but this is not working for Outlook 365 since outlook desktop might become deprecated in a few years
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
Just put the semicolon (;) sapareted email id in To column.
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.
How ?
I want to reverse it, i want to add multiple file paths in single column
@@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.
Do you know how we can make body more creative coz there is no option
Hi,
Thank you for this amazing video. Could you please assist me on how we can add the signature to this email?
Thanks for your valuable feedback. Please watch the below given video to add the signature in the email-
ua-cam.com/video/q9kTgTghN2g/v-deo.html
@@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.
@@PKAnExcelExpert Thank you. It worked.
Not able to download practice file... Pls help
Hello sir,
Thank you for sharing.
Can we send bulk email through web browser Gmail? not a outlook
Yes, you can. I will create a video on this topic
@@PKAnExcelExpert Please do create a video on this topic using CDO to send emails without outlook.
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
Sir please help us to share the vba code and micro enable workbook as above example shared
Thanks
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
Their is available subject options
Not even a single file is getting downloaded-- there is no download option, the page is full of advertisement
Sir if any like this to send Whats app message sir
Great suggestion! I will try to create a video on this topic.
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
Hi, thank you for thisvery helpful tutorial. May I know where can i find the vba coding for this? 😊
Download link is in the description box
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
Thanks for your valuable feedback🙏
Can you please help me with this template?
Thanks PK sir this video is very useful , Sir can you also add the send WhatsApp option in this video .
Hi, Could you please share the excel download link? I couldn't download from the source. Thanks in advance
Sir can you please tell how to add two or more mail in "TO" And "CC"... So tht it will be more benifit
Sir this is very very helpful... U not only explained but also shared the entire file for practice..... God bless you and your team 👍
Thanks for your valuable feedback🙏
@@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"
thank you so much your video i am learning alots, but how add email signature ?
Thanks for your valuable feedback. Please watch the below video for email signature:
ua-cam.com/video/q9kTgTghN2g/v-deo.html
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.
This bulk emailer will work for any domain email addresses? apart from gmail? I mean recipient email
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.
Glad it helped
Hi, How I can add date in body of e-mail? can you quickly respond to my question
Hello PK, if I have to share payslips of employees. How can share using same macro
Sir it showing an Complie error : Wrong number of arguments or invalid property assignment
Hello PK, can you create a video on how to write a dynamic email in this sheet ?
I want to replay same email every week with old trail mail is it possible
Sir ek video library management par banaye
Book issue and book return
Please sir 🙏
Plz download this file, Automated Multiple Emails with Multiple Attachments and "From" option
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.
Facing compile error
Variable not defined
Can you help me
Pls sir it's important and also I want to send summary on the mail body
HELLO, the king of vba thank you for all these working vba's
Glad you like them!
Is there way to put break between each mail? Few seconds
Very useful template. I am using this almost everyday. How i can use outlook signature on this vba? please help.
Please watch the below video:
ua-cam.com/video/q9kTgTghN2g/v-deo.html
please sent the excel file with source code in free of cost
Is it paid now??
Yes
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.
Sir muze form16 bhejan hai pan base p kaise karu
Hello Sir,
I am unable to make payment please send me the help.
Please email me at info@PK-AnExcelExpert.com
Thank you for this
I need to send multiple emails like for FROM MY APPLE IPAD .
IS IT POSSIBLE IN IPAD?
@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?
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!
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
@@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?
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.
I wonder if you can combine this with bulk WhatsApp msgs sheet, that too while replacing outlook with gmail. Please give it a thought.
how we add mail body data like when paste outlook mail body paste Option Is HTML Formate Bitmap Option We want select bitmap
Please watch below given videos:
ua-cam.com/video/aD-lo81I5C4/v-deo.html
ua-cam.com/video/q9kTgTghN2g/v-deo.html
@@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
Hye are u there or r u stuck
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??
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 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
Please share the download link for free
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
Can we edit this for windows live mail
Thank you so much for this tutorial. Your explanations are very clear, thank you
Most welcome
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.
Great suggestion! I will try to create a video on this topic.
@@PKAnExcelExpert Dear PK: Thank you so much. Looking forward to the video. Greatly appreciated.
Dear PK: I’m wondering if I have missed the video demo using Power Automate. Please help. Thank you so much.
Hi sir, can I know what can be done if we get "Run time error429" while sending the emails?
Thank you very much for this code and tutorial. So helpful!
Glad it was helpful!
Please give option to use Thunderbird or any mail client.. because outlook is giving problems due to Gmail security
I want you to explain to us this same workbook but using WhatsApp
Thank you very much
Great!!! I have been looking for this solution.
Is there a possibility to send a reminder to those emails ?
Thanks how we can add the names in the message body please
Yes, we can add. watch the below videos:
ua-cam.com/video/QVJDQqYMNdQ/v-deo.html
ua-cam.com/video/q9kTgTghN2g/v-deo.html
Thank you so much!! I was able to create one all because of you
Wonderful!
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?
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
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 ?
Why i can't send the email ??
What if I want to only send multiple information to 1 recipient in a single email?
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?
Can add date time column to schedule auto email on a specific date and time?
Yes, you can. Please watch the relative below video:
ua-cam.com/video/4sea6RpUsB4/v-deo.html
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?
I want to reply different email id with different attachment in bulk method
How can we add sign in outlook
Sir, what about the end number of pdf required to attach from a folder. How to do that
How to add sc.shots in the body of the email in this scenario ? Please help.
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
Great suggestion! I will try to create a video on this topic.
Does this work with web outlook?
No
Is it possible for me to have vba code of this video? 😢
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
@@PKAnExcelExpert I found it finally, appreciate it. I become a big fan of your videos already ☺️
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
Please watch below given video:
ua-cam.com/video/q9kTgTghN2g/v-deo.html
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!!!!
Thanks🙏
Please Make a video how to send whatssup messages at a single click
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
I got your point. I will try to create a video on this topic.
@@PKAnExcelExpert Thank you so much sir for considering my point.
You are a genius. Thanks for share.
Thanks for your valuable feedback🙏
Sir, can I get the macro coding pls
This would be of much help
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?
Will upload soon
You are the boss of VBA coding
Thanks for your valuable feedback🙏
Superb dear Sir....... Thanks for update.
Always welcome
This video is really helpful. Kindly help me with How to add a table in the body of this Email?
Please watch the below video:
ua-cam.com/video/aD-lo81I5C4/v-deo.html
Hi sir can we do some formatting in the email body.. like underline, bold, italic, font colour etc
Please watch the below video:
ua-cam.com/video/q9kTgTghN2g/v-deo.html
Brilliant - I tried doing PowerAutomate but the pdf's got corrupted which was pointless - this worked - thanks a bunch.
Most welcome
Hi, Nice,
Can you send me this file?
Tks Friend. May you be able to create even better!
hello Sir, is the website down
it is not opening up and i cannot download the file for practice
It is working. Please check it now
www.pk-anexcelexpert.com/automated-multiple-emails-with-multiple-attachments-and-from-option/
From address code not working please share code
Can you please show how to add signatures also in the mail 0:11
Please watch below video:
ua-cam.com/video/q9kTgTghN2g/v-deo.html
can you make same vba excel instead of Outlook i want for gmail??
Great suggestion! I will try to create a video on this topic.
If you can make or guide how to make the text body dynamic that will be great please
Please watch below video will help you
ua-cam.com/video/q9kTgTghN2g/v-deo.html