hi, my code does not run smoothly, even after copying and pasting the source codes directly, even after typing manually the code line after line. Please advise me on what to do

@@Lokihits Thanks for watching. Unfortunately, with that bit of information, I cannot help you. You might want to take some time to write down which line of code is causing the error; let me know if you have modified the code from the tutorial, explain in more depth what you did to troubleshoot the problem and provide some more context. Thanks!

Thanks for your reply. sure i could send a screenshot of the error that keeps popping up.

@@Lokihits You cannot attach screenshots to KZfaq comment. Just write it down here

Thanks for the positive feedback and your kind words! Appreciate you taking the time to leave a comment. 👍

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

Happy to hear that you found the video helpful. Happy Coding! 🚀

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! Cheers, Sven ✌️

Hi Ermal Gashi. Happy to see you around. Thanks for watching and your kind words! 👍

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! Happy Coding! :)

Hi Jörn! Happy to hear that. Thanks for watching the video and taking the time to leave a comment! 👍

Hard to tell from a distance. My closest guess is that you are getting this issue because you are trying to import a module of a library which is not installed in your virtual environment. If you have run 'pip install pandas' already, ensure to call your Python file from the same environment in which you installed the package. For example, in your IDE/text editor, you might have set a different Python environment for executing your script. Therefore, try to run your Python file also from the command prompt. If that does not work, try searching for the text of your error message on Google/StackOverflow. Happy Debugging!

@@CodingIsFun Hello, My code runs well in my computer, I checked the env variables as well and all paths are included. The only issue I have is when I try to run it on Deta . I am now trying to adapt it into a tkinter gui, but honestly, my python experience is basic. My main goal is to share this program with colleagues that wouldn't require to install python. I appreciate your video nonetheless, you inspire me to keep grinding!

Glad you liked it. Thanks for watching and taking the time to leave a comment!

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

@@CodingIsFun can this work with streamlit?

@@tebogoselepe969 in general, yes

Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet for a solution. Sorry that I cannot help!

@@CodingIsFun thank you for the feedback!

Thanks for watching. Yes, that sounds possible.

An absolute pleasure, very happy to hear that you found it useful!

Glad you liked it. Thanks for watching! 👍

Glad to hear that! :)

Hard to tell from a distance. Sorry that I cannot help

Thanks for watching. Hard to tell from a distance. You might want to try reaching out to the experts at the deta discord server: discord.com/invite/K3gYNqHXUU Happy Debugging!

@@CodingIsFun thank you always for your kind support, appreciate it!

Thanks for watching. Yes, I know. Deta has unfortunately changed a lot. Currently, I run all my Python scripts and APIs on PythonAnywhere. However, the FastAPI feature on PythonAnywhere is currently in Beta, and the web UI for managing FastAPI there is a bit limited for now. Cheers, Sven ✌️

@@CodingIsFun Thanks again for your trusted recommendation. I would have stuck with Deta (space) had there been some simple way or help forum. Will dive into your channel much more.

Thanks for watching. That depends on your email provider. For outlook check out the following link: support.microsoft.com/en-us/office/sending-limits-in-outlook-com-279ee200-594c-40f0-9ec8-bb6af7735c2e I hope it helps! Cheers, Sven ✌️

Thanks for watching. It is possible, but you would need to schedule your Python script to run locally on your machine instead of running it in the cloud.

You're very welcome! Thank you for watching and for the comment!

As mentioned in the video, there are already a lot of tutorials here on KZfaq on how to access private spreadsheets using Python.

Thank you, Florian!

hm same problem here any solution u got?

Thanks for watching. Here is an example: stackoverflow.com/a/13071761 Happy Coding! Cheers, Sven ✌️

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

Thanks for watching the video and for asking your question! I think it's a good idea for you to try it out yourself and see what happens with the checkbox. My guess is that it will be converted to a Boolean value, but it's always helpful to test things out and see how they work in practice.

Thanks for watching. In the video I am explaining the spreadsheet structure.

Thanks for watching! In the future, I might create an updated version to connect to deta space. P.S. My name is Sven 😅

@@CodingIsFunah sorry sven 😆.. thankssss i confused because this migration has minim literation and tutorial.. the structure micros has very different between old and new 😆

Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet for a solution. Sorry that I cannot help!

​@@CodingIsFun Hi Sven, Sorry to disturbe you again with my questions ^^ I have one more question for you, for which I would greatly appreciate your support. In addition to your code I built a function which write in the csv file the sending status (whether emails are sent or not). The function works well on my computer (for each email sent, the status is updated from "to be send" to "sent"). But when I deploy it using Deta, the emails are sent but I get the following: OSError: [Errno 30] Read-only filesystem: 'data_email.csv' ---> so the sending status is not added to my csv file "data_email.csv". Can you please let me know if you already faced this error ?? if so, how can i fix it? as the solutions found on internet are not woking for me... Thanks

Hello, I have my own. I think you need to activate a specific password for python, I do not remember how I did that, but you need to set a specific password for specific apps, I remember the password is generated automatically, you copy it and you use it for that moment on. So, in the Python script I use the X password that was given by gmail. But I log-in with my usual password.

🙋

@@CodingIsFun Can you do a tutorial sir?

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

@@CodingIsFun No worries! It was a formatting error in the txt file. However I did want to ask, did you use a virtual environment when making this tutorial? I did and I think its causing me some complications when it comes to uploading it to deta

Yes, you can apply inline style to the HTML element.

@@CodingIsFun I am getting an error that outlook authentication is failed. May be due to some security reasons. Your video is almost 2 years old. can you confirm me if this is still working or not

While using outlook it's giving "smtpauthenticationerror: (535, b'5.7.139 authentication unsuccessful, account locked.)" error I've tried using app password too for the app but it's still throwing the same error.

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

Thanks for watching. With that bit of information I cannot help you. Sorry!

Yes, you can. If that helps, consider supporting this channel by buying me a coffee here: "pythonandvba.com/coffee-donation"

Thanks for watching and your suggestion! 👍

Thanks for watching. That was my Windows Terminal

how to do this

@@user-ns3ko3fc4r Here you are: chat.openai.com/share/8d1ea8cc-7ad5-43f3-b207-daa2f2634250

Thanks for watching. You can also use an (paid) API Email service. Here is one example: github.com/sendgrid/sendgrid-python/#quick-start

@@CodingIsFun Thanks for the reply.

Thanks for watching. It seems your question is not related to the video. For general Python questions, you may want to check out our discord community: pythonandvba.com/discord

Thanks for watching. Unfortunately, with that bit of information, I cannot help you. You might want to take some time to write down which line of code is causing the error; let me know if you have modified the code from the tutorial, explain in more depth what you did to troubleshoot the problem and provide some more context. Thanks!

Thanks for watching. In the official Python documentation you can find examples on how to add attachments: docs.python.org/3/library/email.examples.html

@@CodingIsFun thanks for your reply I will review

Thanks for watching. I have explained it at the 3:03 mark. Good luck with your project! 🍀

I am not an Java Expert, but I guess it is also possible in Java

@@CodingIsFun ok sir👍

Glad you liked it. Thanks for watching.

And where are the files located?

Thanks for watching. I hope this helps: chat.openai.com/share/4e6c2278-f945-41aa-b0c7-35289c3c9ac7

thank youu @@CodingIsFun

Hey there, thanks for watching the video! I'm sorry I can't help you with your problem based on the information you provided. To give me a better idea of what's going on, it would be super helpful if you could write down which line of code is causing the error, let me know if you modified the code from the tutorial, and explain in more detail what you did to troubleshoot the problem. Don't forget to also give me some context about your setup and environment. If you're having trouble figuring things out, another option is to join our Discord server at pyhtonandvba.com/discord. You can ask your question there and maybe someone in the community can help out. Thanks for understanding.

Thanks for watching. The error means you're trying to use strftime on a string. You need to convert row["due_date"] to a datetime object first. Here's how: df['due_date'] = pd.to_datetime(df['due_date']) Happy Coding!

...then you can also do that. Here are some examples: docs.python.org/3/library/email.examples.html

As explained in the video (18:32 min), deta is a third-party package. If you want to install it, you need to run "pip install deta"

which ide you used

Thank you for watching the video. Your questions are great, but finding the time to answer them is difficult. Kindly understand that I receive many requests for individual solutions or modifications. That said, you might want to join our Discord server ( pythonandvba.com/discord ) and post your question there. Thanks for your understanding. Happy Coding!

@@CodingIsFun thnk u so much for ur respense i'm gonna wait for the solution ♥️ wish you continuous success

Yes, it is possible to automate Google Docs with Python using the Google Docs API. The Google Docs API allows you to create, edit, and retrieve documents and their contents, as well as manage document formatting, styles, and templates. To get started with the Google Docs API, you will need to set up a project in the Google Cloud Console and enable the Google Docs API for your project. Then, you will need to install the Google API Client Library for Python and authenticate your app with the Google Cloud Platform. Once you have set up your project and installed the necessary libraries, you can use the Google Docs API to perform various tasks, such as creating new documents, inserting text and images into documents, formatting text and paragraphs, and more.

@@CodingIsFun TY for this answer)

If you want to run the script only once, there is no need to set up a cron job.

@@CodingIsFun Thanks for the quick reply! What I meant is that, every minute (if the conditions are met) the email will be sent over and over again. I would like the mail to be sent only when the conditions are met for the first time.

@@thetiagofromchile It's feasible with additional customization. Consider adding a column called "Sent Already," and mark it with "x" once an email has been sent. Before sending any emails, you can check the conditions in that column. If no "x" is present, proceed with sending the email.

@@CodingIsFun good idea thanks!

@@CodingIsFun one last question, how can I write into Google Sheets ?

Thanks for watching. Sorry, I cannot help with that.

@@CodingIsFun can you tell any possible reasons?

@@anubhavbairoliya1003 Nope, I would also need to search for a solution online

Deta change their interface. Kindly refer to their docs

Can you please tell me where I can host this for scheduling except deta? Please send me any tutorial

@@BeingBlogger kzfaq.info/get/bejne/i92mdLCcrZ_YhIk.html&feature=shares

I suggest a quick Google search

Thanks for watching. To check emails using Outlook SMTP and Python, you need to use the IMAP protocol instead of SMTP, as SMTP is for sending emails. You can use the built-in imaplib module. Happy Coding! :)

@@CodingIsFun ok, could you consider to make a video about it? ;-)

@@rb9888 I will keep in mind, but I cannot make any promises

Here is the link: pythonandvba.com/discord

rename email.py to send_email.py or something else and try again.

also, this message, PS C:\Users\lenovo\Desktop\Automate emails> & 'C:\Users\lenovo\AppData\Local\Programs\Python\Python311\python.exe' 'c:\Users\lenovo\.vscode\extensions\ms-python.python-2022.20.1\pythonFiles\lib\python\debugpy\adapter/../..\debugpy\launcher' '50360' '--' 'c:\Users\lenovo\Desktop\Automate emails\email.py' File "c:\Users\lenovo\Desktop\Automate emails\email.py", line 16 else find_dotenv() ^^^^ SyntaxError: invalid syntax vo\AppData\Local\Programs\Python\Python311\python.exe' 'c:\Users\lenovo\.vscode\extensions\ms-python.python-202vo\AppData\Local\Programs\Python\Py2.20.1\pythonFiles\lib\python\debugpy\adapter/../..\debugpy\launcher' '50384' '--' 'c:\Users\lenovo\Desktop\Autpy\adapter/../..\debugpy\launcher' omate emails\email.py' File "c:\Users\lenovo\Desktop\Automate emails\email.py", line 2, in import smtplib ^^^^^^^^^^^^^^ File "C:\Users\lenovo\AppData\Local\Programs\Python\Python311\Lib\smtplib.py", line 47, in import email.utils File "c:\Users\lenovo\Desktop\Automate emails\email.py", line 3, in from email.message import EmailMessage ModuleNotFoundError: No module named 'email.message'; 'email' is not a package PS C:\Users\lenovo\Desktop\Automate emails> c:; cd 'c:\Users\lenovo\Desktop\Automate emails'; & 'C:\Users\lenovo\AppData\Local\Programs\Python\Python311\python.exe' 'c:\Users\lenovo\.vscode\extensions\ms-python.python-2022.20.1\pythonFiles\lib\python\debugpy\adapter/../..\debugpy\launcher' '50669' '--' 'c:\Users\lenovo\Desktop\Automate emails\email.py' File "c:\Users\lenovo\Desktop\Automate emails\email.py", line 2, in import smtplib ^^^^^^^^^^^^^^ File "C:\Users\lenovo\AppData\Local\Programs\Python\Python311\Lib\smtplib.py", line 47, in import email.utils File "c:\Users\lenovo\Desktop\Automate emails\email.py", line 3, in from email.message import EmailMessage ModuleNotFoundError: No module named 'email.message'; 'email' is not a package PS C:\Users\lenovo\Desktop\Automate emails> c:; cd 'c:\Users\lenovo\Desktop\Automate emails'; & 'C:\Users\lenovo\AppData\Local\Programs\Python\Python311\python.exe' 'c:\Users\lenovo\.vscode\extensions\ms-python.python-2022.20.1\pythonFiles\lib\python\debugpy\adapter/../..\debugpy\launcher' '50680' '--' 'c:\Users\lenovo\Desktop\Automate emails\email.py' Traceback (most recent call last): File "c:\Users\lenovo\Desktop\Automate emails\email.py", line 2, in import smtplib

@@Lokihits Just clone the repo and give it another try.

Thanks for watching. As explained here: 18:34 min. If you want to run it locally, ensure to run "pip install deta"

I have installed pip install deta but the problem is still prevailing

@@sadmansakibabir8456 I suggest creating a separate virtual environment and installing the required libraries there. This will ensure that you have a clean, isolated environment for running your Python code, which can help avoid conflicts with any other libraries that you have installed on your machine.

@@sadmansakibabir8456 I suggest creating a separate virtual environment and installing the required libraries there. This will ensure that you have a clean, isolated environment for running your Python code, which can help avoid conflicts with any other libraries that you have installed on your machine.

Thanks for watching. Probably because I did not sync my mic with my camera correctly.

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

Thanks for watching. As shown in the video, you must set up the environment variables (using your email address + password). Happy Coding!

Where do I put the email and the password i have same problem@@CodingIsFun

@@user-ns3ko3fc4r please watch the video