Excellent video , i want to know, i have to keep the default mail body which is pre set as signature on my outlook and rest of the things should be done via this excel and can we add more file name columns if i have to send 2 or 3 invoices on same ID
Amazing contents! Can I please ask a further question? I want to reply on top of a specific email, reply it with customized content like what you did here, while still keeping the previous email thread… somehow I can’t keep both at the same time? Much appreciated if you could provide help on this! Thanks in advance
Hello - I wish to add multiple attachments to the email send, up to 4. How would I identify the different columns and references to ensure the files are attached correctly? I did not see this option on your blog. Thank you,
Great video! What would the code be if we were to use simple macro code with no Microsoft Outlook 16.0 object library? I understand it would be more flexible as it can work on all computer without activating an additional library. thanks
Very good. I was doing the same in a more complex way, ur way is so much better. Thanks for this. Could u please show how to add default signature? Thank u.
This really helped alot. Need one more help though. I have access to multiple mailbox, this code sends mails from default email, however, i want to send mail from other id. Please let me know the line of code required.
Thank you so much!! This has saved me hours of work!! Is there a way to add my email signature also to send it from a joint or alternate email address?
Help me to make a VBA code to send 20 files. Just like you did it need to add up a little bit more. Let me give details a little bit. Each mail has a different attachment and mail body. Like if I am sending my 1st mail. I will open that excel file, go to a particular sheet, copy data, paste it to the email body, and attach that same file as an attachment. Once the mail is ready then that file gets closed. And then with 2nd mail and it will go on for 19 times.
Hi! Thank you so much for this video it will be such a huge time saver for me! I'm currently trying to get this set up but i get an error with the "attachments.add strfolder & "\" & strfile" line. When I run the code I get an error saying "the drive is not ready. Verify that the desk is in the drive and that the door is closed" Do you know how to amend this? Sincerely,
I've added the folder to my desktop and repasted the path into the folder line and i still get an error for the attachment line saying " file name or directory name is not valid."
@@user-jg1gw8hq5cbe certain you’re specifying the correct drive letter and path -> “C:\DATA\REPORTS”, for example. Notice my example did not end with a backslash as the code provides one.
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?
Hi sir, appreciate your video. Very helpful. However i have two questions which is 1. How to indicate company logo under signature? 2.How to indicate multiple email address?
Hi there, I got the same problem.. when I insert multiple emails on Excel cell, it doesn't seem to be able to detect when the email is generated and i need to click them one by one. Have you found a way yet?
Hello! appreciate your video, just asking why my result is only sent to top of receiver, not the same with your result sent to all receiver (6) and I have an error to whole line (With objEmail upto End With). please help me to resolve this problem. Thank you
I have a mac, and been on mac because of my pro audio interest... Mac is not so Microsoft friendly. Alot of the features that could make my system more efficient are on Windows! I have to DL ODBC Drivers to connect to the SQL MicrosoftServer to be able to do this. And thats where I get stuck. Im on a mission. Any Mac users out there trying to accomplish this task?
Hello. Useful presentation. I have a query. When i am entering the data which has alphabets, numbers and special characters it is popping error. Please help me.
Hello sir, Your VBA programming was outstanding. I have one query. suppose on the third row there is no attachments so how can i make programming for those client id only who has attachments and no mail sent for those who has no attachments?? I am waiting for your reply. Thank you
u can insert an if condition before the code which sends email. Syntax given below Assume filepath is at cell D20 filepath = ThisWorkbook.Sheets("SheetName").Range("D20").text if filepath "" then 'code to send email End if
Thank you sir For your reply. I have One another question. I have applied this programming for sending multiple files to individual recipients and I was succeeded but when some persons doesn't have multiple files say only one file and other have more than one files then what should i do in programming. I have tried but didn't succeeded in this. I have been eagerly waiting for your reply@@AutomationMadeEasy
@@vipulprajapati2797 - Well it depends how your data is formatted. the sloution needs to be customized based on data. If you need consultation/training write into info@automationandagile.com
Just few questions about this is that i have written the code as per the video however mail is being sent repeatedly n number of times and in my data multiple records are tagged to one single client id request you to kindly how to send the one consolidated email basis the client id instead of sending multiple emails basis the number of rows
I have two mails in my outlook one is personal and business so when I click send email button it goes from personal mail so can you please me to change my sender email address
try adding below line of code just befor .send .SentOnBehalfOfName = "Email ID" Replace email id with actual email id with which you wish to send the emails
I created new file, when i click send message is coming as Done but email is not going out of Outlook, i enabled Microsoft Outlook object library but still it is not running in outlook
@@AutomationMadeEasy The code DimObjOutlook As Object is getting highlighted and the error message is Complile error. Statement invalid outside type block.
Sir apki google forms vali coading fail ho gayi coz form shuffle mode pe hai apka video dekh ke same try kiya but getRange not defined show ho raha hai
getRange fail hone ka reason hain you are trying to read data from incorrect cell of the sheet. Script will wotk fine on open forms provided it is correctly designed and developed. Maine ek example diya hain but every form is different and will need customization based on the form
Thanks for the video. How to save the outlook email draft into local folder?
Excellent video , i want to know, i have to keep the default mail body which is pre set as signature on my outlook and rest of the things should be done via this excel and can we add more file name columns if i have to send 2 or 3 invoices on same ID
Thank you very much...This was very informative and easy to understand.....😊
Glad it was helpful!
I'm so grateful for this video. It's going to save me a lot of time, thanks!
Glad it was helpful!
Amazing contents! Can I please ask a further question? I want to reply on top of a specific email, reply it with customized content like what you did here, while still keeping the previous email thread… somehow I can’t keep both at the same time? Much appreciated if you could provide help on this! Thanks in advance
This was soooo helpful. Thank you!
Glad it was helpful!
Hello - I wish to add multiple attachments to the email send, up to 4. How would I identify the different columns and references to ensure the files are attached correctly? I did not see this option on your blog.
Thank you,
Great and amazing insights!
Glad you enjoyed it
Great video! What would the code be if we were to use simple macro code with no Microsoft Outlook 16.0 object library? I understand it would be more flexible as it can work on all computer without activating an additional library. thanks
Thank you for your guidance. It's worked
Glad it helped
This is amazing! Thank you!
thank u
You are amazing my friend! Thanx allot
Glad it helped!
Amazing content. Thanks a lot
My pleasure!
Hello, if i want to choose email id for TO: and CC: how to customize it?
This is very helpful. Can you also please share the code for sending these emails using outlook web application.
Wow 👌 👏, you explained so perfectly. ❤
Glad it was helpful!
@@AutomationMadeEasycan u share vba code
Very good. I was doing the same in a more complex way, ur way is so much better. Thanks for this. Could u please show how to add default signature? Thank u.
let me check and get back
@@AutomationMadeEasy did you find out?
This really helped alot. Need one more help though. I have access to multiple mailbox, this code sends mails from default email, however, i want to send mail from other id. Please let me know the line of code required.
Sir, how about email will not be sent (pop up as new email) & can still be updated manually to add tables & pictures? Thanks in advance
Best, Thank you so much.
Welcome!
Thanks! Very well done. What is the code to delay the sending of the emails to a specific date/time?
You can set up a scheduller job in windows to have this macro execute at a specific time
Sir you're great thanks
So nice of you
superb.. sir how we can send pay slip without outlook via. SMTP
Thank you so much!! This has saved me hours of work!! Is there a way to add my email signature also to send it from a joint or alternate email address?
Glad you found it helpful.
Will try to find a solution for it. Dont have it right now
how to send a message with images like in signature since excel does not accept images in sheets
Could you provide a link to your blog with the code?
Is there away to add CC's
Help me to make a VBA code to send 20 files. Just like you did it need to add up a little bit more. Let me give details a little bit. Each mail has a different attachment and mail body. Like if I am sending my 1st mail. I will open that excel file, go to a particular sheet, copy data, paste it to the email body, and attach that same file as an attachment. Once the mail is ready then that file gets closed. And then with 2nd mail and it will go on for 19 times.
Hello Sir, Excellent tutorial it is perfectly working.
I have query, if I need to add my outlook signature in email, then how the code will work?
Let me check
Hello, great video, thanks.
1 question, please: if I want to set the Amount in blue color, how can I do? Thank you!
let me check
How to add cc and Bcc.can you plz add that
It was so helpful, Would you please let me know how we can modify "Email Address" of Sender too? Thanks
for that you will need to have rights of the mailbox from whose email id you wish to send the emails
Hi! Thank you so much for this video it will be such a huge time saver for me!
I'm currently trying to get this set up but i get an error with the "attachments.add strfolder & "\" & strfile" line.
When I run the code I get an error saying "the drive is not ready. Verify that the desk is in the drive and that the door is closed" Do you know how to amend this?
Sincerely,
I've added the folder to my desktop and repasted the path into the folder line and i still get an error for the attachment line saying " file name or directory name is not valid."
@@user-jg1gw8hq5cbe certain you’re specifying the correct drive letter and path -> “C:\DATA\REPORTS”, for example. Notice my example did not end with a backslash as the code provides one.
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?
Well seems feasible but will need lots of customization.
amazing video, is there a way to have it send emails based on an if statement. for example If a date is coming up?
certainly it can be customized but it all depends on structure of data and conditions
I want to send follow up emails from the same email threads that they were send from last time, how can I do that?
Thanks
Welcome
Hi sir, appreciate your video. Very helpful. However i have two questions which is 1. How to indicate company logo under signature? 2.How to indicate multiple email address?
Hi there, I got the same problem.. when I insert multiple emails on Excel cell, it doesn't seem to be able to detect when the email is generated and i need to click them one by one. Have you found a way yet?
Hi, can you share the VBA code so I can copy paste. Thank you.
Great video! Can I setting to send that email automatically everyday at specific time?
you will have to use windows scheduller for the same
Hello! appreciate your video, just asking why my result is only sent to top of receiver, not the same with your result sent to all receiver (6) and I have an error to whole line (With objEmail upto End With). please help me to resolve this problem. Thank you
need to see your code and spreadhseet to understand the error
hi the code not working me
it's asking for error 424 Object required
Sir could you please guide how to delay the mail sending 60 seconds for each mail 🙏
This is really helpful. But how can I add an image in this email? could you advise on this please.
You can attach the image. Attachment example is explained in the tutorial.
@@AutomationMadeEasyI do not want to attach it. The image will be in the mail body
Hello Sir, can we do this with the recording feature in Macro?
no
I have a mac, and been on mac because of my pro audio interest... Mac is not so Microsoft friendly. Alot of the features that could make my system more efficient are on Windows!
I have to DL ODBC Drivers to connect to the SQL MicrosoftServer to be able to do this. And thats where I get stuck. Im on a mission.
Any Mac users out there trying to accomplish this task?
Hi, first of all, thank you very much for sharing this. I have a question, is it possible to do the same with Gmail account without Outlook?
yes, refer below tutorial:
ruclips.net/video/c7S0-3x9hFw/видео.html
I wish to add body table in this
Hello. Useful presentation. I have a query. When i am entering the data which has alphabets, numbers and special characters it is popping error. Please help me.
whats the error?
I get error 438 and error in attachment code line. How to debug it
If 'To' email Id cell is blank then Email shouldn't go what code we need to enter ?
Hello! Can you please share with me a copy of the macro so I can customise it. Thanks
where shall i send
Hello sir, Your VBA programming was outstanding. I have one query. suppose on the third row there is no attachments so how can i make programming for those client id only who has attachments and no mail sent for those who has no attachments??
I am waiting for your reply.
Thank you
u can insert an if condition before the code which sends email. Syntax given below
Assume filepath is at cell D20
filepath = ThisWorkbook.Sheets("SheetName").Range("D20").text
if filepath "" then
'code to send email
End if
Thank you sir For your reply. I have One another question. I have applied this programming for sending multiple files to individual recipients and I was succeeded but when some persons doesn't have multiple files say only one file and other have more than one files then what should i do in programming. I have tried but didn't succeeded in this. I have been eagerly waiting for your reply@@AutomationMadeEasy
@@vipulprajapati2797 - Well it depends how your data is formatted. the sloution needs to be customized based on data. If you need consultation/training write into info@automationandagile.com
Great video. Bro I want to create automation in excel to auto send Birthday wishes email. Could you please help me on this. I got the project
for trainings/consultation write into info@automationandagile.com
Can I do this on Mac?
not sure if mac supports vba
Hi, how can we add weblinks in the mail body ? please reply
will create a tutorial on it soon
Just few questions about this is that i have written the code as per the video however mail is being sent repeatedly n number of times and in my data multiple records are tagged to one single client id request you to kindly how to send the one consolidated email basis the client id instead of sending multiple emails basis the number of rows
need to see how your data is structured.
@@AutomationMadeEasy please assist how can I share the data samples for your reference.
for training/consultation write into info@automationandagile.com
I have two mails in my outlook one is personal and business so when I click send email button it goes from personal mail so can you please me to change my sender email address
try adding below line of code just befor .send
.SentOnBehalfOfName = "Email ID"
Replace email id with actual email id with which you wish to send the emails
Same can we used in mac???
not sure about mac.
Can this be modified to work with Gmail? How? Thanks in advance.
Thanks, but the reason why I want to use Gmail is, that I don't have Outlook.
I am getting an error on line 424 error when setting strMailBody...
whats the error description
I created new file, when i click send message is coming as Done but email is not going out of Outlook, i enabled Microsoft Outlook object library but still it is not running in outlook
any error message?
@@AutomationMadeEasy No error message sir getting message as email sent but emails not going from outlook
Microsoft Outlook object library is not shown in my list
which os are you using?
Window 11
I am getting some error. Can you please guide me... I can mail you the code I have written based on your tutorial...
what is the error description?
@@AutomationMadeEasy The code DimObjOutlook As Object is getting highlighted and the error message is Complile error. Statement invalid outside type block.
Would it be possible for you to review my requirement and make the necessary modifications in my file? Naturally for a fee...
share your requirements at info@automationandagile.com
@@AutomationMadeEasy Sent...
Please share your excel file with us
Sir name part is not working its coming ws how to make it to auto fetch correct name from Customer Name coloum
Please guide
check spelling, it will work the same way as other fields
Thank you sir 🙏
It's working
Sir apki google forms vali coading fail ho gayi coz form shuffle mode pe hai apka video dekh ke same try kiya but getRange not defined show ho raha hai
getRange fail hone ka reason hain you are trying to read data from incorrect cell of the sheet. Script will wotk fine on open forms provided it is correctly designed and developed. Maine ek example diya hain but every form is different and will need customization based on the form
Can you share coding
it available on the blog automationandagile
Please how do I add the option to Copy someone in the email
If only we could send it from gmail too
yes its certainly possible. Refer below tutorial:
ruclips.net/video/c7S0-3x9hFw/видео.html