Send images in the WhatsApp using excel file data

[Mohammad_Rizwan_03 (Mohammad Rizwan)]

I have an Excel file with 500 mobile numbers, including country codes. I also have a specific file for each number, and I want to send these files via WhatsApp using the mobile numbers from the Excel file.

[pradeep931 (Pradeep Bandharam)]

Hi @Mohammad_Rizwan_03

Read Range to read the list of mobile numbers, For Each Row (Loop Through Mobile Numbers), In each iteration, get the mobile number and construct the file path.
Open WhatsApp Web
Use Open Browser to navigate to WhatsApp Web(Ensure you’ve logged in via QR code before running the automation (you can add a delay for manual login at the start if necessary),
Type the Mobile Number Send File
Automate the attachment process using Click, Type Into and Send Hotkey activities.

Below is the thread which is also having the solution

Send a Message via Whatsapp

Here’s my solution. Please feel free to improve the program. 1.Use the chrome; 2.When you run the first time, read QRcode with WhatsApp Web; (only the first time) to register the cell that will send the message; 3.Create a csv file named: phone list 3.Put in the csv file the relation of the numbers to which you want to send the message; 4.Place the cell phone number with the country and city code. 5.Adjust your message; Main.xaml (18,1 KB)