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

[davide]

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

[leroymentor]

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

[andrewbeal]

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

[kasragg]

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

[sandeshpadigela]

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?

[daffaburhan]

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

[亦涵张]

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

[wolfenstein]

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

[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?

[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,

[darshilshah]

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.

[j.dasilva]

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.

[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?

[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?

[samanthaworrall]

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?

[selvan]

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

[mehdibakhtiari]

You made it really easy to understand!

[deepali]

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

[saptarshidalal]

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

[janinehadia]

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