Скачать или смотреть Sending 100 sms automatically using python and Microsoft Phone Link

Send customized SMS to 100 people using python and Microsoft Phone Link with sample xlsx file

There are times where you need to send sms message to many people with customised message to each mobile number. For this I have devised this script to automate sending customised SMS message to 100 people. The mobile operators in India allow only 100 messages per day to prevent spam and fair use. The script requires following

An xlsx file containing mobile number in one column with column name “Mobile Number” and another column with custom message to be sent named “Message”. Keep in mind the spelling else script won’t run. Also keep the message words in limit to prevent extra charges. Put

MS Windows 11 with Python 3 installed along with pyautogui, pandas, pyperclip libraries installed.

Microsoft Phone link installed in PC as well as Android phone compatible with Link to Windows

The script:


Execution steps

Create a xlsx file with “Mobile Number” and “Message” column heading. Put mobile number and message carefully. Sample xlsx file named sampleMessages.xlsx is available on github. Save this file in a new folder with any name.

First copy above code in a file with name `autoSMSScript.py` or any other name and put this file in same folder as your excel file created above

Now open Microsoft Phone Link and connect your mobile from which you need sms to be sent. Go to Messages tab in phone link and keep it open

Now open Powershell, navigate to your folder where you have stored python file and xlsx file.

now run following command in command line

python3 autoSMSScript.py sampleMessages.xlsx

or

python autoSMSScript.py sampleMessages.xlsx

If the script runs successfully, console will show following message 

`switch to your target page, Starting in 2 seconds.`

When you see this message, immediately switch to phone link software and keep message tab open. Then voila, script will automatically paste the mobile number in To column and Paste message in message box.

Now, at this point, I have comhmented out the send command so the above script will not send any message. This is done to ensure safety from user error. Once you understand and feel confident, uncomment this line in code # pyautogui.press(“enter”).


This script is provided for informative and educative purpose only without any warranty. Do not use this for spamming and/or other activities which are not allowed by law. Refer to github repo for details of GPL-3 license.