هذا جواب الذكاء الاصطناعي لكيفية ارسال الرسائل من الإكسيل إلى الواتساب. الاسم في العمود A ورقم الموبايل في العمود B والرسالة في العمود C.
Here are simplified steps for sending WhatsApp messages from Excel:
Method 1: WhatsApp Web (Manual)
1. Open your Excel file.
2. Copy the phone number in column B.
3. Go to web.whatsapp.com and scan the QR code.
4. Paste the phone number in the chat window.
5. Copy the message from column C.
6. Paste and send.
Method 2: VBA Script
1. Open Excel and press Alt + F11.
2. Create a new module (Insert > Module).
3. Paste this code:
Sub SendWhatsAppMessages()
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("YourSheetName")
Dim i As Long
For i = 2 To ws.UsedRange.Rows.Count
Dim phone As String
phone = ws.Cells(i, 2).Value
Dim message As String
message = ws.Cells(i, 3).Value
Dim url As String
url = "https://wa.me/" & phone & "?text=" & EncodeURL(message)
ThisWorkbook.FollowHyperlink url
Application.Wait Now + TimeValue("00:00:05")
Next i
End Sub
Function EncodeURL(url As String) As String
EncodeURL = WorksheetFunction.EncodeURL(url)
End Function
1. Replace "YourSheetName" with your sheet's name.
2. Run the macro (F5).
Method 3: Power Automate (formerly Microsoft Flow)
1. Create a Power Automate account.
2. Connect your WhatsApp account.
3. Create a flow:
- Trigger: Excel (read data)
- Action: WhatsApp (send message)
1. Configure the flow using your Excel data.
Choose the method that suits you best.
