This video very useful to me ,thank you very much 1 hour work I did in 15 mins thank you
@automatedata54128 ай бұрын
Thankyou for the kind words
@TritonConsultancy-iz1gf7 күн бұрын
@@automatedata5412 Your way of explaining is superb. This video very useful. But a suggestion kindly add the link in the description for finding the VBA code to copy paste. It will be more easier for us
@automatedata54124 күн бұрын
@@TritonConsultancy-iz1gf to be really honest why most of the tutorial wont have the code is because then people will just copy paste it and not watch the video. When I put the video like this viewers will have to sit through the entire video to get the complete code. I know it is cruel but thats the only way I can get benefitted from this video😭
@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.😁
@shubhamrajpure34744 ай бұрын
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
@drabodows9 ай бұрын
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.
@automatedata54129 ай бұрын
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 )
@AmitJediya3 ай бұрын
Not getting the mail pop up when using msg.display , I want to send mails from different mail Id Rather than default mail Id
@AmitJediya3 ай бұрын
Also please help i want send mail while keeping customers only in BCC and rest TO & CC will be blank, Could you please assist
@erwin04239 ай бұрын
Please help. I tried the code but I encountered an error - "Run time error '429'. Active X component can't create object"
@automatedata54129 ай бұрын
Do you use an old version of excel?
@erwin04239 ай бұрын
@@automatedata5412 MS Excel Ver 16
@erwin04239 ай бұрын
@@automatedata5412 I used Version 16 in Mac
@money_earn_tamil9 ай бұрын
Same problem ! Any solution please. I am using new version
@mindfulnessbr24775 ай бұрын
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
@automatedata54125 ай бұрын
Thankyou for this.. This might help many
@Ashwanikumar-kt8my3 ай бұрын
Great that is what I am looking Resolved issue. Now its working
@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...
@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 Жыл бұрын
@@automatedata5412hi have same issue with mail merge with custom subject and CC I am unable to send with custom subject and CC
@jobygeorgev0610 ай бұрын
Very nice information, it would be great help if you could attach the codes herewith.
@automatedata541210 ай бұрын
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
@jobygeorgev0610 ай бұрын
Yes bro
@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.
@somom1100Ай бұрын
I see that Runtime error ‘9’. subcript out of range error message popping up
@automatedata5412Ай бұрын
@@somom1100 subscript out of range cones usually when the sheet name is wrong
@mariomakarawo9 ай бұрын
hi, how to add default signature on outlook to send multiple email with signature ? without preview first with code msg.display
@automatedata54129 ай бұрын
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
@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.
@fpvaq73788 ай бұрын
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?
@automatedata54128 ай бұрын
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)
@vijaykumar-nv2uz3 ай бұрын
Script not running shows error " End if without block If" Please help here.
@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
@ahtishamabbasi1118 ай бұрын
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?
@ahtishamabbasi1118 ай бұрын
Debug is highlighting error in the code msg.attachment.Add.ws.Range ("L" & I).Value
@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
@duynhat43269 ай бұрын
how can i add a signature with title, website, X... on the body email
@automatedata54129 ай бұрын
Include that in the body part of the mail.. or try setting up a default signature in ur outlook
@manishprasad2390 Жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
I’m expecting a reply
@automatedata5412 Жыл бұрын
@@manishprasad2390 can you type here the attachment details.. just one would be enough as an example
@manishprasad2390 Жыл бұрын
C:\Users\js903f\Desktop\work tracker.xlsx
@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
@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
@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 Жыл бұрын
kzbin.info/www/bejne/fWXUqq2Zoc6rZ5I 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
@user-ki1kb4mx3c8 ай бұрын
it give that can not add attachement no data source provided
@automatedata54128 ай бұрын
Yes u need to provide the attachment path in the column i mentioned in the video. U can add like folder/folder/myfile.pdf
@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
@jessbel19610 ай бұрын
How do I add an excel file as an attachment?
@automatedata541210 ай бұрын
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
@jessbel19610 ай бұрын
@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?
@automatedata541210 ай бұрын
@@jessbel196 recipient doesnt need access to the location since we are attaching it as a file and not the location
@jessbel19610 ай бұрын
@automatedata5412 Getting an compile error Next without for
@automatedata541210 ай бұрын
@@jessbel196 please check the code if you have used “for”
@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
@navinsrivastav8462 Жыл бұрын
I have put the extension as well but its not working