sendMessageTest.py

import subprocess
import sys

def install(package):
    subprocess.check_call([sys.executable, "-m", "pip", "install", package])

install("pyautogui")
install("pandas")

import pyautogui as pg
import webbrowser as web
import time
import pandas as pd

message = '''Greetings from Sigma Xi,%0a
%0a
Thank you for registering for Sigma Xi’s Rendezvous: The Research Stream. We are delighted to have you join us for Episode 1 of our talk show series.%0a
%0a
Our speaker, Mr. Anshuman Acharya, will guide you through the complexities of research and help you dive deeper into what it takes to start and develop your career around research and development. He'll walk you through his journey of getting into the field of research and provide valuable insights on the everyday life of a research expert.%0a
%0a
The event will be on the 29th of August, 2021 from 5:00 pm to 6:30 pm on MS Teams.%0a
%0a
Looking forward to seeing you there. You can join the event through the link given below.%0a
%0a
For any queries, contact:%0a
Rujul Srivatsava%0a
%2B91 8595347523%0a
%0a
Event Details:%0a
%0a
Name: Rendezvous%0a
Date: 29th August 2021%0a
Timing: 5:00 pm to 6:30 pm%0a
Meeting Link:  bit.ly/SigmaXiRendezvousEp1 %0a
%0a
Find us on:%0a
%0a
LinkedIn: %0a
www.linkedin.com/company/sigma-xi-vit/mycompany/ %0a
%0a
Instagram: %0a
www.instagram.com/sigmaxi.vit/ %0a
%0a
Facebook: %0a
www.facebook.com/SigmaXiVIT/ %0a
%0a
Regards%0a
Team Sigma Xi VIT'''

workbook = pd.read_excel('test.xlsx')

data_dict = workbook.to_dict('list')
numbers = data_dict['Number']
first = True
for num in numbers:
    print("Sending message to", int(num))
    time.sleep(4)
    web.open("https://web.whatsapp.com/send?phone="+f"91{int(num)}+"+"&text="+message)
    if first:
        time.sleep(6)
        first=False
    width,height = pg.size()
    pg.click(width/2,height/2)
    time.sleep(8)
    pg.press('enter')
    time.sleep(8)
    pg.hotkey('ctrl', 'w')