Create and Distribute Excel Files using Python and Outlook | Automate Excel with Python

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this video, I will demonstrate how you can use Python (Pandas) to automate the creation of Excel files, which you can then distribute via email to a list of contacts. To send out the emails, we are going to use the Desktop application of Microsoft Outlook.

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[CodingIsFun]

*If you have any questions or want to see more excel automation examples using Python, let me know in the comments.*

[marco_rock_s]

I love how you get ahead of people's questions by showing solutions to problems/complications that people may experience. You're once step ahead. Awesome stuff!

[ermalgashimramori]

It's always a pleasure seeing you up the level of the content, please keep up the good work. Time spent watching your videos is quality time, thank you!

[bc]

OMG I love your videos! Using coding to solve little tasks like this is *exactly* the kind of thing I aspire to, and perfect for my needs and interests. Thank you!

[rajeevmenon]

As always Sven, real worthwhile content. Keep up the good work!! You are a rockstar

[thamilanban]

Thank you. You deserve a million subscribers.

[ryanbuzar]

Great tutorial! That was very helpful! Thank you for sharing!

[ahmedsalman]

This worked as smooth as it was supposed to be. I love your way to explaining the code line by line. It was a use_case for me, and I am glad to say that you are a life saver. This is fantastic! 😊😊

[datalyticsbootcamp]

Great video! I could see myself creating something like this.

[maevabj]

Thank you so much for this incredible video. This was the first video I saw that didn't need to add passwords and settings. Fits perfectly.
I would like to know if you have any videos that I can watch that help me create a logic that changes the content of mail.HTMLBody according to values found in the csv that we export. Example, if Value is greater than 60, it shows one content, if it is smaller, another. If zero, a specific...
Have a great week and thanks again!

[AbCdEf-vhjj]

Hi Sven! It's admirable how you manage to display your work in just 7 minutes and make it so enjoyable!
I got one question: As you work with win32 here (which works with win64 according to another comment of you): Does it also work on the Outlook version of *APPLE*? What's the prerequisite for implementing this? Do you have to download the desktop version of Outlook for this? Glad if you you could add some Know-how on this. Thanks a lot and keep it on. It's a great joy to check out your great progress!

[bottega]

Thanks @CodingIsFun, very informative. Are you able to provide a video for the same exact steps but using VBA to execute this process pls? Much appreciated!

[mariamazeez]

This is helpful and wished i had seen this earlier! New subscriber alert.

Question please: what if the master file has two tabs and you want to pull from the two tabs into two tabs in the individual files

[gomesarmando]

@Coding Is fun, thank you this is very helpful 🙏 🔥
what if I want to attach multiples files to one or more receivers instead of one attach per receivers. does this method still work ?, should I create as much column in my Excel file (source), as I have files to attach ?

Thank you very much !

[sinnombre]

Thank you!, this tutorial is really useful.
Sven, how We can insert an image of a chart to the body mail?

[chayan]

Hi there, Cant this be done without the attachment approach? What if I wish to paste the contents of the excel per unique email IDs in the body?

[mrx]

I am really enjoying and learning a lot from your videos. I have a question regarding the outlook mailing list. How you can add a different signature for instance each country email? 😊

[Bzman]

Is it possible to do this with each excel having a column which includes a drop down list to select an option (data validation) ?

[cvas-d]

Thank you so much for the brief explanations. Is there any other option other than outlook to send email?.. If yes, could you please help with that which will be much helpful.

[Chrisfagan]

Cool video. Would like to see how you could password protect the files before sending.