Send Bulk E-Mails From Outlook Using Excel VBA

No video

Send Bulk E-Mails From Outlook Using Excel VBA | With Attachments, CC, BCC |

Рет қаралды 19,720

Күн бұрын

In this video, we will learn about how to Send Bulk E-Mails From Outlook Using Excel VBA | With Attachments, CC, BCC |
How to change the author name in Microsoft excel: • How to change author n...
Different types of sum functions in Microsoft Excel: • How to use Sum functio...
Create your own functions / formula: • USER DEFINED FUNCTION ...
How to create new formula in excel • USER DEFINED FUNCTION ...
How to pass excel interview • USER DEFINED FUNCTION ...
Custom Formula • USER DEFINED FUNCTION ...
Custom function • USER DEFINED FUNCTION ...
TAGS:
#excel #microsoft #microsoftexcel #office #word #o #powerpoint #business #cursodeexcel #data #msexcel #curso #cursoexcel #powerbi #exceltips #motivation #datascience #microsoftoffice #n #aprenderexcel #planilhas #dicasexcel #windows #dashboard #cursos #ado #exceltraining #like #excelbasico #dataanalytics
#youtubeislife #subscriber #youtubeguru #youtubecontent #newvideo #subscribers #youtubevideo #youtub #youtuber and #youtubevideos
#excel #microsoft #microsoftexcel #office #word #o #powerpoint #business #cursodeexcel #data #msexcel #curso #cursoexcel #powerbi #exceltips #motivation #datascience #microsoftoffice #n #aprenderexcel #planilhas #dicasexcel #windows #dashboard #cursos #ado #exceltraining #like #excelbasico #dataanalytics
#msexcel #excel #microsoftexcel #microsoft #exceltips #exceltraining #office #msword #msexceltraining #exceltricks #data #spreadsheet #msoffice #excelfunctions #microsoftoffice #business #learnexcel #spreadsheets #excelshortcuts #msexceltips #dataentry #excelformulas #accounting #exceltutorial #advancedexcel #excelskills #excelprofessional #vlookup #powerpoint #mspowerpoint #excelfunctions #microsoftexcel #exceltips #excel #excelformulas #msexcel #exceltraining #exceltricks #microsoft #microsoftoffice #excelshortcuts #excelspreadsheets #excelprofessional #learnexcel #advancedexcel #excelskills #onlinetrainingforeveryone #exceltutorial #vlookup #advancedexceltraining #officeproductivity #exceltutorials #spreadsheets #excelinterviewquestions #excelvba #excelmacros #msexceltraining #intermediateexcel #exceltestforjobinterview #howtoanalyzedata
#excelvlookup #excelforbusiness #msexceltips #exceltest #vadimmikhailenko #dataanalysis #sap #exceldashboard #pivottables #datavisualization #powerpivot #datamodeling #microsoftaccess #microsoftproject #microsoftpowerbi #microsoftexceltraining #microsoftword #powerpoint #match #index #formulas #exceltipsandtricks #functions #office #excelexpert #datamanagement #kursusprogramming #kursusdesign #follow #personaldevelopment

Пікірлер: 81

@doordie6640 7 ай бұрын

This video very useful to me ,thank you very much 1 hour work I did in 15 mins thank you

@automatedata5412 7 ай бұрын

Thankyou for the kind words

@mohamedtharik1120 Жыл бұрын

Hi, I am getting error as runtime error 440 but I have already put the correct pathname with filename. Still getting this error please advise...

@aquibpatel2311 Жыл бұрын

Very clear and detailed explanation, thank you very much, could you please tell if can we use the same code for dynamic data?

@automatedata5412 Жыл бұрын

Thankyou. By dynamic did you mean the number of rows? Then this code is already fit for that.😁

@shubhamrajpure3474 3 ай бұрын

Hello, I have one doubt that when I run this it works but whatever formatting for email Body I did in Excel sheet was not showing

@santoshparab562 Жыл бұрын

Very Nicely Explained. Can you please explain the part of code where you have put condition if attachment path is not available in excel. Also if i need to add one more column to change signature; what should be the code. Will this Code works if i want to use on behalf email id.

@automatedata5412 Жыл бұрын

Hi Santosh, In this code column F contains the attachment details. Here the if conditions states that if column F cell value is not blank .. means not equal to. So "" means not blank. So if that cell is not blank the macro will consider the value in that cell as the attachment path.

@drabodows 8 ай бұрын

Hello! Is there a way to change the default sender with this code. As is, it will choose the default sender in the Outlook application for the user who runs the code. What if I want to send form one of my other email addresses? Thanks for the good work here.

@automatedata5412 8 ай бұрын

Yes that is absolutely possible. Without code the way is to go to outlook and change the default sender. Then run this code.. (u can try some test values first to make sure it is working )

@mowgli536 Жыл бұрын

This is exactly what I was looking for in regards to adding Cc fields to my mail merge. However, I need this to work with a word template with a picture within the email. Can you help adjust?

@automatedata5412 Жыл бұрын

Hey if you are looking for a word template mail. You should check out mail merging in ms word. There you can use CC also. And no code required.

@mowgli536 Жыл бұрын

@@automatedata5412 Thank you for responding. But I have a huge excel list with custom messages and codes. Each email for To and Cc are different.

@automatedata5412 Жыл бұрын

@@mowgli536 yes you can use mail merge for that. Custom subject cc to body everything

@mayank_swami 11 ай бұрын

@@automatedata5412hi have same issue with mail merge with custom subject and CC I am unable to send with custom subject and CC

@smitpatel5180 Жыл бұрын

Thanks it's working.. But can I set time 30 second and after send second mail

@automatedata5412 Жыл бұрын

Yes you can. If VBA there is an option to use a line of code to make the application wait for certain amount of time until running the next line. So if u place that code line before the for loop ending, it will work. If you need that line of code, please refer to my video of a macro to not let your computer sleep when not in use. In that video I have used the time delaying method.

@jobygeorgev06 9 ай бұрын

Very nice information, it would be great help if you could attach the codes herewith.

@automatedata5412 9 ай бұрын

Thankyou.. Unfortunately i do not have the file with me now. But I suggest you use some image to text extension or take a screenshot of the code and use some image to text site for now

@jobygeorgev06 9 ай бұрын

Yes bro

@terry9914 Жыл бұрын

Great video, one question, how do I go about personalizing the body of each email with the person's name?

@automatedata5412 Жыл бұрын

In this video, column E is labelled as message. That is the body part. You can enter your customised body content there

@terry9914 Жыл бұрын

@@automatedata5412 sorry what I meant was is there a way to pull the name from a column and attach to the body so that I do not need to update my body content on each message to include the person name?

@automatedata5412 Жыл бұрын

@@terry9914 yes. Put another column and in that column add a formula like: = "Hi " & A2 & ", " & B2 Assuming column A has names and b has message. Fill the formula till end

@mariomakarawo 8 ай бұрын

hi, how to add default signature on outlook to send multiple email with signature ? without preview first with code msg.display

@automatedata5412 8 ай бұрын

If you dont want to preview then instead of .display use .send For default signature please refer to some utube videos on how to add default signature on outlook (its easy no coding required).. and try first with some sample data to test if its working

@fpvaq7378 7 ай бұрын

is it possible that outlook sends the email itself but instead of sending multiple emails at the same time, it sends at an interval of 5-10 minutes?

@automatedata5412 7 ай бұрын

Yes it is possible.. use (.send) instead of (.display) it will send automatically For the interval ass a line of code before ending the for loop which will make the system wait for certain time (please search google for this application.wait ..something is the syntax)

@ahtishamabbasi111 7 ай бұрын

Runtime error 440, Cannot add the attachment; no data source was provided, Have already checked the path and extension in the sheet it complete with root directort still the same error is appearing, Any solution?

@ahtishamabbasi111 7 ай бұрын

Debug is highlighting error in the code msg.attachment.Add.ws.Range ("L" & I).Value

@vijaykumar-nv2uz 2 ай бұрын

Script not running shows error " End if without block If" Please help here.

@abinjose1256 Жыл бұрын

How can I supress the Outlook warning while sending mail using macro in excel

@automatedata5412 Жыл бұрын

Application.displayevents = false '''Mail part of code here''' Application.displayevents = true

@shashiviranga9441 Жыл бұрын

hellow sir, I can not run this. ERROR CODE 440 can not add the attachments. No data source was provided. I have provided the path of respective files. Pls advice

@automatedata5412 Жыл бұрын

Path is not enough. U should end the path with specifying the file extenison. For example: path/foldername/filename.Pdf

@marfocontracts6400 Жыл бұрын

Hello can you please show how to insert file path? As i am getting error code 440: cannot add attachments no data source but i have the file path in my spreadsheet 😢

@FredBKevinn Жыл бұрын

Same here

@automatedata5412 Жыл бұрын

kzfaq.info/get/bejne/fZqhrN2U0c_cYWQ.html refer to videos like this. U need to get the file path like this and paste it in excel. Sometimes u will have many number of files. Make sure u have the extension mentioned as well. For eg=.Pdf or .Jpg

@erwin0423 8 ай бұрын

Please help. I tried the code but I encountered an error - "Run time error '429'. Active X component can't create object"

@automatedata5412 8 ай бұрын

Do you use an old version of excel?

@erwin0423 8 ай бұрын

@@automatedata5412 MS Excel Ver 16

@erwin0423 8 ай бұрын

@@automatedata5412 I used Version 16 in Mac

@money_earn_tamil 7 ай бұрын

Same problem ! Any solution please. I am using new version

@likhithlicky2947 Жыл бұрын

Can we add multiple adress in to adress?

@automatedata5412 Жыл бұрын

Yes , use comma seperator or semi colon seperator. One of this should work Example: “fake@gmail.com;fake2@gmail.com” I dont remember exactly whether we should use , or ; Try each of them

@duynhat4326 8 ай бұрын

how can i add a signature with title, website, X... on the body email

@automatedata5412 8 ай бұрын

Include that in the body part of the mail.. or try setting up a default signature in ur outlook

@AmitJediya Ай бұрын

Not getting the mail pop up when using msg.display , I want to send mails from different mail Id Rather than default mail Id

@AmitJediya Ай бұрын

Also please help i want send mail while keeping customers only in BCC and rest TO & CC will be blank, Could you please assist

@user-ki1kb4mx3c 7 ай бұрын

it give that can not add attachement no data source provided

@automatedata5412 7 ай бұрын

Yes u need to provide the attachment path in the column i mentioned in the video. U can add like folder/folder/myfile.pdf

@somom1100 3 күн бұрын

I see that Runtime error ‘9’. subcript out of range error message popping up

@automatedata5412 3 күн бұрын

@@somom1100 subscript out of range cones usually when the sheet name is wrong

@sagarsinghsolanki3546 Жыл бұрын

Gmail pe bulk me kaise send kare mail jisme CC me bhi e-mail kar ske

@automatedata5412 Жыл бұрын

Hi, instead of excel we can use Google Sheets. It is much easier than outlook. If you need us to develop a code for you, you can contact us at automatedata2022@gmail.com

@manishprasad2390 11 ай бұрын

I tested this code, everything is working fine except the last row and column is not automated( not sending email automatically). What should i do?

@automatedata5412 11 ай бұрын

I didnt understand the issue.Did u mean the last row mail is not being sent. Then try this.. after the line where u declare last row write one more line after it Lastrow = lastrow + 1 Try this and let me know

@manishprasad2390 11 ай бұрын

I've got it working, but I can't attach attachments in Outlook. Like in excel i have attached the document and the code is running fine but in outlook there is no attachment.

@manishprasad2390 11 ай бұрын

I’m expecting a reply

@automatedata5412 11 ай бұрын

@@manishprasad2390 can you type here the attachment details.. just one would be enough as an example

@manishprasad2390 11 ай бұрын

C:\Users\js903f\Desktop\work tracker.xlsx

@GiuseppeTramonta-wj7mn Жыл бұрын

Salve come faccio a mettere il percorso mi dà errore 440

@automatedata5412 Жыл бұрын

You need to put path like folder/filename.pdf That extension is required. U can put pdf or jpg or whichever extension u have

@GiuseppeTramonta-wj7mn Жыл бұрын

@@automatedata5412 pdf

@automatedata5412 Жыл бұрын

@@GiuseppeTramonta-wj7mn then put in the column that specifies the file name, put extension as well. Example --> c:/folder/filename.pdf

@jessbel196 9 ай бұрын

How do I add an excel file as an attachment?

@automatedata5412 9 ай бұрын

In the attachment path give the file path Example : c:/users/documents/myfolder/myexcelfile.xlsx Here check what file type u have it can me probably xlsx or xlsm

@jessbel196 9 ай бұрын

@automatedata5412 The recipient has to have access to the file folder in order to open the file. So if the person does not have access to the folder where the excel file is located, how do i attach the excel file then?

@automatedata5412 9 ай бұрын

@@jessbel196 recipient doesnt need access to the location since we are attaching it as a file and not the location

@jessbel196 9 ай бұрын

@automatedata5412 Getting an compile error Next without for

@automatedata5412 9 ай бұрын

@@jessbel196 please check the code if you have used “for”

@navinsrivastav8462 Жыл бұрын

I have put the extension as well but its not working

@automatedata5412 Жыл бұрын

There might be issues with the references

@mindfulnessbr2477 4 ай бұрын

People, I have fixed the error 440, Cannot add the attachment; in the "msg.attachments.Add.ws.Range("F" & i).Value" you should update the sentence to this: msg.attachments.Add ws.Range("F" & i).Value

@automatedata5412 4 ай бұрын

Thankyou for this.. This might help many

@Ashwanikumar-kt8my 2 ай бұрын

Great that is what I am looking Resolved issue. Now its working