How to send Whatsapp Messages from Excel - Malayalam Tutorial

എക്സലിൽ ഉപയോഗിച്ച് ഒറ്റ ക്ലിക്കിൽ നൂറു കണക്കിന് ആളുകൾക്ക് വാട്സാപ്പ് മെസ്സേജ് അയക്കുന്ന ടെക്നിക്ക്.
How to send WhatsApp messages from Excel, explained in Malayalam.

മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...

Subscribe to the channel @AjayAnandXLnCAD for more.

Check this video for sending WhatsApp messages from Excel using WhatsApp for the Web.

VBA Code to send Whatsapp messages from Excel

Sub XLToWhatsApp()
Dim LastRow As Long
Dim i As Integer, strip As String
Dim strPhoneNumber As String, strMsg As String, strPostData As String
Dim IE As Object
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
strPhoneNumber = Sheets("Payment").Cells(i, 3).Value
strMsg = Sheets("Payment").Cells(i, 4).Value

strPostData = "whatsapp://send?phone=" & strPhoneNumber & "&text=" & strMsg
Set IE = CreateObject("InternetExplorer.Application")

IE.navigate strPostData
Application.Wait (Now + TimeValue("00:00:01"))
Call SendKeys("^v")
Application.Wait (Now + TimeValue("00:00:01"))
Call SendKeys("{Enter}", True)

Next i
End Sub

Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...

#exceltowhatsapp #whatspptricks #excelmalayalam

[benoyav]

Wow, this is super useful. Thank you 👍.

[dingandheeran]

Ajay chetta... Awesome Work.. മാസങ്ങൾ ആയിട്ട് waiting ആയിരുന്നു.. Pwoli♥️

[abybaby]

Nice presentation.. Thank you..
Expecting more videos related to excel data comparison and it's formulas.

[ksfehelpline]

Excellant Sir, very easily explained... thank you so much.. Any method to add files as attachment along with message sir

[gopikrishna]

Sir, I need same vba code to use edge instead of IE. Is it possible

[AJMALABDULLA]

Very informative video. Thanks
WhatsApp web il ninnu message pokumo?

[The-anav.]

അടിപൊളി. അയക്കുന്നവരോട് 1000 നമ്പറിൽ കൂടുതൽ ഒരു ദിവസം അയച്ചാൽ വാട്സാപ്പ് ബ്ലോക്കാവനുള്ള സാധ്യതയുണ്ട്

[robinsjoseph]

I want to add image along with the text .... so what am I suppose to do? and without giving names on the columns coz I have 100 numbers without names too

[sudhikkhalid]

Hi... oru pdf file orupad perkk send cheyyanulla option paranj tharamo?? Broadcastil all my contacts ilekk send avanilla...

[amaanabi]

Send bulk. Msg with image attached for marketing purpose ee model. Ill. Oru video chayamooo

[ShaneefKPoyil]

Can we send to groups? Pls reply it will be very useful if I can send to grp.

[sreenathkdeva]

Your voice is also superb as your presentation

[RiyazHyder]

This is amazing... 👍
How can we send messages to a group?

[abdulsamadv]

Super presentation, can we attach a file in msg?

[gjjoksw]

Do you want to allow this website to open an application on your computer? how to solve this problem pls reply to me

[prashanttiwari]

Sir, I need same vba code to use google chrome
instead of IE. Is it possible

[KrishnaKumarDS]

is it nessary to have the phone numbers in our contact list ??? if those number are not in your whats app contact list - then ?

[UnniKrishnan-wvhz]

Good evening. How to insert one excel file with other files? Your response is highly appreciated. Example one Excel file I am having 3 sheets and I want to insert some additional sheets from other files....

[sreejithsl]

sir, any way to forward pdf files...
eg. payslip

[mmbcampus]

Great... Can we add attachment automatically ??