How To Automatically Send Customized Emails With Attachments Using Excel Macros

In this tutorial we would learn:
1. How to send Emails Using Excel Macros
2. How to Attach files in an Email using Excel Macros

[@leroymentor9932]

I'm so grateful for this video. It's going to save me a lot of time, thanks!

[@AutomationMadeEasy]

Glad it was helpful!

[@mehdibakhtiari300]

You made it really easy to understand!

[@AutomationMadeEasy]

Thank you

[@mehdibakhtiari300]

I have still problem with the attachments. My VBA deletes first the pervious emails then attaches the PDF to the new one. At the end an email remains with 10 attachments.@@AutomationMadeEasy

[@alyaalaksmigodwin1197]

Thankyou so much! It helped me a lot

[@ericndega]

Great and amazing insights!

[@AutomationMadeEasy]

Glad you enjoyed it

[@shankaraellamula8463]

Thank you very much...This was very informative and easy to understand.....😊

[@AutomationMadeEasy]

Glad it was helpful!

[@shelbybennion4585]

This was soooo helpful. Thank you!

[@AutomationMadeEasy]

Glad it was helpful!

[@SadamHussain-yx3uh]

Thank you for your guidance. It's worked

[@AutomationMadeEasy]

Glad it helped

[@andrewbeal6443]

Thanks! Very well done. What is the code to delay the sending of the emails to a specific date/time?

[@AutomationMadeEasy]

You can set up a scheduller job in windows to have this macro execute at a specific time

[@j.dasilva4567]

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.

[@AutomationMadeEasy]

let me check and get back

[@aznbspikey]

@@AutomationMadeEasy did you find out?

[@archiedelarosa499]

This is amazing! Thank you!

[@AutomationMadeEasy]

thank u

[@test4629]

You are amazing my friend! Thanx allot

[@AutomationMadeEasy]

Glad it helped!

[@xreeyJ]

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?

[@hongxiliu4282]

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?

[@sanjeebmaharjan]

Best, Thank you so much.

[@AutomationMadeEasy]

Welcome!

[@davide740]

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

[@sandeshpadigela0]

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?

[@AutomationMadeEasy]

Well seems feasible but will need lots of customization.

[@praneshkumarrathinasamy7740]

Amazing content. Thanks a lot

[@AutomationMadeEasy]

My pleasure!

[@selvan1264]

Thanks for the video. How to save the outlook email draft into local folder?

[@kasragg2715]

It was so helpful, Would you please let me know how we can modify "Email Address" of Sender too? Thanks

[@AutomationMadeEasy]

for that you will need to have rights of the mailbox from whose email id you wish to send the emails

[@9r266]

Sir you're great thanks

[@AutomationMadeEasy]

So nice of you

[@samanthaworrall1918]

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?

[@AutomationMadeEasy]

Glad you found it helpful. Will try to find a solution for it. Dont have it right now

[@亦涵张]

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

[@darshilshah9755]

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.

[@janinehadia3036]

How so send it from different email address for example if i am going to use the generic mailbox on behalf of my department?

[@deepali8939]

Hello, if i want to choose email id for TO: and CC: how to customize it?

[@wolfenstein6288]

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

[@antothomas7523]

This is very helpful. Can you also please share the code for sending these emails using outlook web application.

[@daffaburhan6675]

Great video! Can I setting to send that email automatically everyday at specific time?

[@AutomationMadeEasy]

you will have to use windows scheduller for the same

[@vorkpalur]

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?

[@AutomationMadeEasy]

yes, refer below tutorial: kzbin.info/www/bejne/mWi2YWBprZ6bfNk

[@Micomicooo-eo5ee]

Hi sir how can I make part of the text bold?

[@MyDearFriend]

amazing video, is there a way to have it send emails based on an if statement. for example If a date is coming up?

[@AutomationMadeEasy]

certainly it can be customized but it all depends on structure of data and conditions

[@123naimish]

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?

[@AutomationMadeEasy]

Let me check

[@shubhamyadav-nd4zx]

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.

[@JLa-lw6pe]

Can you send an excel spreadsheet using this code?

[@himanshuarora14]

I want to send follow up emails from the same email threads that they were send from last time, how can I do that?

[@kristinwillers6723]

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,

[@saptarshidalal5765]

This is really helpful. But how can I add an image in this email? could you advise on this please.

[@AutomationMadeEasy]

You can attach the image. Attachment example is explained in the tutorial.

[@saptarshidalal5765]

​@@AutomationMadeEasyI do not want to attach it. The image will be in the mail body

[@dhirajsuryawanshi4510]

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

[@AutomationMadeEasy]

for trainings/consultation write into [e-mail]

[@YaelShriki]

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,

[@YaelShriki]

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."

[@gaspumprepairservice7009]

@@YaelShrikibe 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.

[@EZEQUIELGOMEZHORVITZ]

Could you provide a link to your blog with the code?

[@vipulprajapati2797]

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

[@AutomationMadeEasy]

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

[@vipulprajapati2797]

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

[@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 [e-mail]

[@robydc56]

Hello, great video, thanks. 1 question, please: if I want to set the Amount in blue color, how can I do? Thank you!

[@AutomationMadeEasy]

let me check

[@SanviPatil2019]

superb.. sir how we can send pay slip without outlook via. SMTP

[@nagakishorel1368]

If 'To' email Id cell is blank then Email shouldn't go what code we need to enter ?

[@reynandtrinidad4228]

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

[@RadMoulk-ok3nn]

how to send a message with images like in signature since excel does not accept images in sheets

[@deepakbhatia8839]

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

[@AutomationMadeEasy]

need to see how your data is structured.

[@deepakbhatia8839]

@@AutomationMadeEasy please assist how can I share the data samples for your reference.

[@AutomationMadeEasy]

for training/consultation write into [e-mail]

[@eltotsira1000]

Hi, can you share the VBA code so I can copy paste. Thank you.

[@randomrandy3059]

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?

[@haridx05]

How to add cc and Bcc.can you plz add that

[@pramodofindia]

Can this be modified to work with Gmail? How? Thanks in advance.

[@pramodofindia]

Thanks, but the reason why I want to use Gmail is, that I don't have Outlook.

[@SunitaKumari-fb6gg]

Thanks

[@AutomationMadeEasy]

Welcome

[@ರಘುನಾಥ್ಕೆ]

Sir name part is not working its coming ws how to make it to auto fetch correct name from Customer Name coloum Please guide

[@AutomationMadeEasy]

check spelling, it will work the same way as other fields

[@ರಘುನಾಥ್ಕೆ]

Thank you sir 🙏 It's working

[@michaellawrence6009]

Is there away to add CC's

[@emilvincentgomez8977]

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.

[@AutomationMadeEasy]

whats the error?

[@bertongputik1015]

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

[@AutomationMadeEasy]

need to see your code and spreadhseet to understand the error

[@bhumapoojithreddy6737]

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

[@AutomationMadeEasy]

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

[@JLa-lw6pe]

Keep getting an error message when trying to attach file using this code above it is not reading the drive the file is in.......I am trying to attach an excel file, the file path is correct but keep getting an saying "Cannot find file. Verify the path and file name are correct". How do I fix this?

[@AutomationMadeEasy]

need to see your code

[@ರಘುನಾಥ್ಕೆ]

Sir could you please guide how to delay the mail sending 60 seconds for each mail 🙏

[@Srikanth-lb3gl]

Hi, Could you please share the code, Thanks in Advance

[@mallikarjunamavilla7479]

hi the code not working me it's asking for error 424 Object required

[@rasikajadhav2746]

Same can we used in mac???

[@AutomationMadeEasy]

not sure about mac.

[@josephkelly4310]

Can I do this on Mac?

[@AutomationMadeEasy]

not sure if mac supports vba

[@sandippatil8588]

I wish to add body table in this

[@Talkatalkk]

Hello how to contact you ?

[@deepshah3344]

Microsoft Outlook object library is not shown in my list

[@AutomationMadeEasy]

which os are you using?

[@deepshah3344]

Window 11

[@KamalRaj-nl8jg]

I get error 438 and error in attachment code line. How to debug it

[@himanshudaksh6796]

Hello Sir, can we do this with the recording feature in Macro?

[@AutomationMadeEasy]

no

[@sunnykunche]

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]

any error message?

[@sunnykunche]

@@AutomationMadeEasy No error message sir getting message as email sent but emails not going from outlook

[@rodgeri.gaeseb7297]

I am getting an error on line 424 error when setting strMailBody...

[@AutomationMadeEasy]

whats the error description

[@sharmilaramnani1740]

I am getting some error. Can you please guide me... I can mail you the code I have written based on your tutorial...

[@AutomationMadeEasy]

what is the error description?

[@sharmilaramnani1740]

@@AutomationMadeEasy The code DimObjOutlook As Object is getting highlighted and the error message is Complile error. Statement invalid outside type block.

[@sharmilaramnani1740]

Would it be possible for you to review my requirement and make the necessary modifications in my file? Naturally for a fee...

[@AutomationMadeEasy]

share your requirements at [e-mail]

[@sharmilaramnani1740]

@@AutomationMadeEasy Sent...

[@albertodiaz6915]

Hello! Can you please share with me a copy of the macro so I can customise it. Thanks

[@AutomationMadeEasy]

where shall i send

[@shalinsharma6662]

Hi, how can we add weblinks in the mail body ? please reply

[@AutomationMadeEasy]

will create a tutorial on it soon

[@chitreshmhaskar6893]

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

[@AutomationMadeEasy]

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

[@sanjeebmaharjan]

If only we could send it from gmail too

[@AutomationMadeEasy]

yes its certainly possible. Refer below tutorial: kzbin.info/www/bejne/mWi2YWBprZ6bfNk

[@benjaminmathew8578]

Can you share coding

[@AutomationMadeEasy]

it available on the blog automationandagile

[@kwesi_AI]

Please how do I add the option to Copy someone in the email

[@ayanshetty9023]

Please share your excel file with us