How to Create An Indian Kirana Store Calculator & Receipt Generator In Basic Python?

How To Find Factorial & No Of Trailing Zeros In A Factorial Of A Number In Python?

How To Create A Currency Converter In Python? | Python Programming Practice (Hindi)

How To Create A Python HTTP Server For Web Development?

I Created an Automatic Folder Cleaner in Python

I Created a Drink Water Notification Reminder App in Python

I Created a Password Generator using Python

I Created an Automatic Birthday Wisher To Auto-Wish Friends In Python

How I Secure My Passwords Using Python

In this tutorial we are going to create a Python application which will automatically wish someone on their birthday. This application will wish someone automatically on schedule. So let us see how to make it.
Let&rsquo;s open our favourite IDE and create a file named main.py. Now we need to install a few models which will help this program to run, such as pandas, openpyxl etc. We will type the following in terminal/CMD to install the modules :
<ul>
<li style="font-weight: 400;">&ldquo;pip install pandas&rdquo;.</li>
<li style="font-weight: 400;">&ldquo;pip install openpyxl&rdquo;</li>
</ul>
Now we will create an excel sheet on that folder and open it. We will add the following rows, such as Sno, Name, Birthday, Dialogue, Year, Email. Now for testing purposes we will add a few entries to it. Now let's get back to the main.py file. Now we need to create a function which will read the excel file and extract data from it. We will use the pandas library for it. Now to send email we will use the smtplib library. We will be using Gmail for this application. Now we need to create a function which will send email using a gmail id. Now to use this service you need to enable less secure apps on the gmail account which you are going to use for sending the messages. Now our program is ready. Now to schedule the program you need to do the following:
<ul>
<li style="font-weight: 400;">We need to create a task scheduler task which will run our main.py file on 12:00 am everyday so that it can check and wish that person on their respective birthday.</li>
<li style="font-weight: 400;">To do that, you need to copy the path of the file.</li>
<li style="font-weight: 400;">Now open the task scheduler.</li>
<li style="font-weight: 400;">Now you need to click on&nbsp; create a task and then triggers.</li>
<li style="font-weight: 400;">Now click on new and set that as daily and time as 00:00:00 (for 12 am).</li>
<li style="font-weight: 400;">Now get back to the general tab and add name and description.</li>
<li style="font-weight: 400;">Now go to action then new and then click on browse.</li>
<li style="font-weight: 400;">Now on program/script click browse and then choose python.exe by browsing and for arguments just paste the path of the file within the double quote.</li>
<li style="font-weight: 400;">Now press ok and exit it.</li>
</ul>
Now our program is ready to run. You can also watch the video for better explanation.
Source Code:
main.py as described in the video:
<pre class="language-python"><code>import pandas as pd
import datetime
import smtplib
import os
os.chdir(r"D:\MyData\Business\code playground\Python Practice Programs\birthday wisher")
# os.mkdir("testing") 

# Enter your authentication details
GMAIL_ID = ''
GMAIL_PSWD = ''


def sendEmail(to, sub, msg):
 print(f"Email to {to} sent with subject: {sub} and message {msg}" )
 s = smtplib.SMTP('smtp.gmail.com', 587)
 s.starttls()
 s.login(GMAIL_ID, GMAIL_PSWD)
 s.sendmail(GMAIL_ID, to, f"Subject: {sub}\n\n{msg}")
 s.quit()
 

if __name__ == "__main__":
 #just for testing
 # sendEmail(GMAIL_ID, "subject", "test message")
 # exit()

 df = pd.read_excel("data.xlsx")
 # print(df)
 today = datetime.datetime.now().strftime("%d-%m")
 yearNow = datetime.datetime.now().strftime("%Y")
 # print(type(today))
 writeInd = []
 for index, item in df.iterrows():
 # print(index, item['Birthday'])
 bday = item['Birthday'].strftime("%d-%m")
 # print(bday) 
 if(today == bday) and yearNow not in str(item['Year']):
 
 sendEmail(item['Email'], "Happy Birthday", item['Dialogue']) 
 writeInd.append(index)

 # print(writeInd)
 for i in writeInd:
 yr = df.loc[i, 'Year']
 df.loc[i, 'Year'] = str(yr) + ', ' + str(yearNow)
 # print(df.loc[i, 'Year'])

 # print(df) 
 df.to_excel('data.xlsx', index=False) </code></pre>