Automatically Send Message with Image Via Whatsapp
How to automatically send message with image via Whatsapp using VBA.
Here's the complete VBA code:
Option Explicit
Sub SendMessageWithPicViaWhatsapp()
Dim ie As InternetExplorer
Set ie = New InternetExplorer
Dim mytext As String
Dim myDir As String
mytext = Sheet1.Range("C2")
Dim myObj
Dim Pictur
Set myObj = ActiveSheet.DrawingObjects
For Each Pictur In myObj
If Left(Pictur.Name, 7) = "Picture" Then
Pictur.Select
Pictur.Delete
End If
Next
Dim EmployeeName As String, T As String
myDir = "C:\Users\takyar\Pictures\employees\"
EmployeeName = Range("A2") & Range("B2")
T = ".jpg"
On Error GoTo errormessage:
EmployeeName = Range("A2") & Range("B2")
ActiveSheet.Shapes.AddPicture Filename:=myDir & EmployeeName & T, linktofile:=msoFalse, _
savewithdocument:=msoTrue, Left:=240, Top:=15, Width:=60, Height:=60
errormessage:
If Err.Number = 1004 Then
MsgBox "File does not exist." & vbCrLf & "Check the name of the employee!"
Range("A2").Value = ""
Range("B2").Value = ""
End If
ActiveSheet.Shapes(1).Copy
ie.navigate "web.whatsapp.com/send?phone=9..." & mytext
Application.Wait (Now + TimeValue("00:00:10"))
Call SendKeys("^v")
Call SendKeys("{ENTER}", True)
Application.Wait (Now + TimeValue("00:00:05"))
Call SendKeys("{ENTER}", True)
End Sub
Refer to this video on how to add an appropriate image to a worksheet:
www.exceltrainingvideos.com/h...
Пікірлер: 212
Very nice information Sir, I will definitely try this and let you know the feedback.
@Exceltrainingvideos
3 жыл бұрын
Please do.
Hello....sir, like every video for your's this is also very helpful one. Specially for one's like me who's work totally depends on what's app only. I would be very thankful if you can make a video on how we can send msgs on what's app group and not on individual mobile no. Thanks.
@Exceltrainingvideos
3 жыл бұрын
Noted
Dinesh Sir, First I want to say many many Congratulations for teaching every one from this video. But my another question how do we send message, pictures, Documents:- MS word, MS Excel, MS PPT, PDF documents and files to single user, multiple users and groups?
@Exceltrainingvideos
3 жыл бұрын
kzread.info/dash/bejne/ZZ-gr6eRZJPMp8o.html
Extremely useful! Thanks for your time and efforts which I highly appreciate. =Hari Chandan GHAZIABAD UP=
@Exceltrainingvideos
2 жыл бұрын
So nice of you! Please share my KZread channel on Excel with your friends too.
Sir, you are too good at vba 💯👍. Can you please make video on event dispatching on drop down list, in Webscraping.?
@Exceltrainingvideos
3 жыл бұрын
Check out this playlist: kzread.info/dash/bejne/fH2irqqfosLPZbw.html
Amazing ... you are the best
@Exceltrainingvideos
3 жыл бұрын
Thank you so much 😀 Please share with all your buddies.
Love you hogaya uncle G!
@Exceltrainingvideos
3 жыл бұрын
Thanks son!
Very good tutorial.
@Exceltrainingvideos
3 жыл бұрын
Glad you liked it! Please share the VBA tutorial on Whatsapp with your friends.
Simply superb sir🙏. Do you have any course on VBA? If yes please share the link. Thanks a lot
@Exceltrainingvideos
3 жыл бұрын
Please share with your friends too. To learn Excel VBA step by step you can watch the playlist: kzread.info/dash/bejne/ZIiDxrpqiauwgbQ.html
Very very helpful... Thank you sir... One question is that can we send same massage to multiple people?
@Exceltrainingvideos
3 жыл бұрын
Ty it out! You might need to use a looping process.
Sir, First I want to say many many Congratulations for teaching every one from this video. But my another question how do we send message, pictures, Documents:- MS word, MS Excel, MS PPT, PDF documents and files to single user, multiple users and groups?
@indiavikas-computer
3 жыл бұрын
Yes i want to know
@Exceltrainingvideos
3 жыл бұрын
kzread.info/dash/bejne/ZZ-gr6eRZJPMp8o.html
Great tutorial Sir.
@Exceltrainingvideos
2 жыл бұрын
Glad you liked it!
Great vedio sir
@Exceltrainingvideos
3 жыл бұрын
Thanks and welcome. Please share with your friends also.
Great video...superb. Sir, if instead of image, say a pdf file needs to be sent, then how to do that? 🙏🙏🙏
@Exceltrainingvideos
3 жыл бұрын
Did you try the macro on your desktop? What happens before the message is sent? Do you see a preview screen? Work on the idea.
You are Super sir
@Exceltrainingvideos
3 жыл бұрын
Glad you liked the video. Please share with friends.
Dinesh great work! One question: How can I send to a Group ?
@Exceltrainingvideos
3 жыл бұрын
Will work on this good idea.
@rahuls711
3 жыл бұрын
@@Exceltrainingvideos anything did you find on this?
Dinesh Sir, Thank you so much for teaching such amazing way to send messages automatically. But how to send paragraphs on WhatsApp using this technique?
@shriharsh_
3 жыл бұрын
OR how to add next line in single message?
@Exceltrainingvideos
3 жыл бұрын
This Excel VBA lesson will help and guide: www.exceltrainingvideos.com/whatsapp-desktop-automation-with-vba/
@shriharsh_
3 жыл бұрын
@@Exceltrainingvideos Thank You so much SIr Really Helpful Video🙂
Thank you so much for the video, it has been very very helpful. Is there a way to send msg to a whatsapp group??? Thanks again!
@Exceltrainingvideos
2 жыл бұрын
Click on a group and inspect its HTML.
Well appreciated
@Exceltrainingvideos
2 жыл бұрын
Most welcome! Please share my KZread channel on Excel with your friends too. Thanks.
Sir, Many thanks for this useful tutorial. Please show how to send WhatsApp message to a WhatsApp Group from Excel sheet Regards Bivash Ghosh
Sir, Many many thanks for sharing this useful video. Please upload video showing how to send WhatsApp meassage with image to a WhatsApp group. Regards Bivash Ghosh
@Exceltrainingvideos
2 жыл бұрын
This Excel tutorial will help: kzread.info/dash/bejne/hqiYptCSYqq3gdI.html
Great awesome Sir
@Exceltrainingvideos
3 жыл бұрын
Please share with your friends too.
@dilipsebastian5742
3 жыл бұрын
Great 👍
@sureshkannar4462
3 жыл бұрын
@@Exceltrainingvideos Sure Sir, I am watching your Learning and too many effective on me for advance level. Thank you, Thank you Sir
Hello there. very nice application. Is it possible to send by opening whatsapp desktop application instead of web browser?
Hi Sir, Really awesome video,this i was searching so long,is it possible to send mulitple images to the whatsapp group instead of a particular number ?
@Exceltrainingvideos
2 жыл бұрын
Should be possible by again clicking on the 'Add' + sign. For that you'll need to study the HTML code of the relevant page.
@suvarnadhanasekar
2 жыл бұрын
@@Exceltrainingvideos Thank you so much for the reply ..Surely will try the same
superb video
@Exceltrainingvideos
3 жыл бұрын
Thank you so much 😀
That's great!!!! that also works with numbers that I don't have register??
@Exceltrainingvideos
3 жыл бұрын
Glad to hear that LOL!
Well great 👍 Which version of excel r you using in this video
@Exceltrainingvideos
2 жыл бұрын
Excel 365
Great Sir 👏Can we send text message with screenshot using VBA as whatsApp is blocked to access using company's desktop
@Exceltrainingvideos
3 жыл бұрын
Query not quite clear.
@devendrayadav283
3 жыл бұрын
Sir, can we send text message on mobile from excel using VBA
Hi Sir Can we Send Bulk Messages and With Attachments to Single Private Messenger? Pls Guide! Thanks!!
Very Good
@Exceltrainingvideos
3 жыл бұрын
Thanks. Please share with all your friends.
Very Good information. Dear sir can you please make video on hindi language.
@Exceltrainingvideos
2 жыл бұрын
kzread.info
excelent
@Exceltrainingvideos
3 жыл бұрын
Thanks. Please share with your friends too.
Thanks for such a wonderfull program, I am facing the error RUN TIME ERROR 13 TYPE MISMATCH also i intend to send one jpg file to all my contacts from excel pls advice
@Exceltrainingvideos
3 жыл бұрын
Please check your code carefully. The image that you have in Excel must be in some folder on your computer.
Can this process be automated using userform with listbox?
Sir, Which internet explorer you have used, because of I have used version 10 it's showing web what's up is not supporting internet explorer please use Firefox chrome or safari please tell me which internet explorer version will work.
@Exceltrainingvideos
3 жыл бұрын
Microsoft Edge. You can try: Shell "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe -url web.whatsapp.com/send?phone=919810081867&text=mytext"
@Khalnayak_sanju143
3 жыл бұрын
@@Exceltrainingvideos thank you sir
Mantap
@Exceltrainingvideos
3 жыл бұрын
Thanks!
sir also show how to send unlimited messages like this
Sir , i was able to paste the text through chrome , but the picture is not being pasted. can u highlight which part of the code does that .. ?
@Exceltrainingvideos
3 жыл бұрын
Try again. Check your VBA code carefully line by line.
can we send image or pdf directly without enter any key in vb6.0. this function is in my project and having no more idea about it actually in my project should be able to send image or pdf file directly to user when they register.
@Exceltrainingvideos
2 жыл бұрын
Interesting project. On my channel I show how to use VBA in Excel for automation.
Its sending the pic but not text. At text stage it stopped. How to change the code to run for many rows? Please help
i was having numbers in excel & i want to send jpg image to all those numbers via whats app..suggest me
@Exceltrainingvideos
3 жыл бұрын
You'll have to use the business API.
öncelikle yaptığınız paylaşım için sizi tebrik ediyoru. .pdf dosyalarının a whasaap a gönderme versiyonunu yayınlarsanız sevinirim. iyi günler.
@Exceltrainingvideos
3 жыл бұрын
This VBA tutorial will help: kzread.info/dash/bejne/ZZ-gr6eRZJPMp8o.html
Dear sir, can i atteched a pdf file for auto send through whatsapp
@Exceltrainingvideos
3 жыл бұрын
Did you try the VBA tutorial on your computer? If yes, in the end you are offered a preview where you can click on a '+' sign and add a file. Try it out.
what if I want to loop thru multiple numbers. will I have to open whatsapp multiple times in multiple windows? or there is way to avoid this?
@nunotorresreis
3 жыл бұрын
Call a variable to where he has if phone number
@Exceltrainingvideos
3 жыл бұрын
It doesn't seem to work when using a variable for the phone number. Can you share a working code here?
@MRvinz1
3 жыл бұрын
@@Exceltrainingvideos Any solution for this? also doing similar project now. Thanks
sir please show to embed this with html page
Dear sir, Can we send message to whatsapp group from Excel by time Based.
@Exceltrainingvideos
2 жыл бұрын
Check out the description.
👍🏻
@Exceltrainingvideos
3 жыл бұрын
Thanks. Please share with your friends.
how to send message excel to whats app and message print with excel concatenate formula and some row+column message miss and send bottom message. my excel sheet error. when i missing some column or rows this script show the top message. please guide me.......
@Exceltrainingvideos
3 жыл бұрын
Noted
hello sir, does we have to add all number in our phone contact?
@Exceltrainingvideos
3 жыл бұрын
At present you can use this concept to send details to one phone number.
@priyeshpandey100
3 жыл бұрын
@@Exceltrainingvideos ok...alos sir it is not picking up the image...what can u say?
Hey sir, What if I want to share the message with a group or a contact name instead of a Phone number?
@Exceltrainingvideos
3 жыл бұрын
This link will guide: kzread.info/dash/bejne/lm2Tkqymdpu6cbQ.html
@azghar.suhail
3 жыл бұрын
@@Exceltrainingvideos Thank you so much for ur reply. But I need without selenium like how it's in this video for whatsapp desktop app. Please request your help
Can we make the browser run in a headless mode? I want it to run in the background
@Exceltrainingvideos
3 жыл бұрын
What is headless mode?
@user-sj9xq6hb9p
3 жыл бұрын
@@Exceltrainingvideos Its a way to use the browser in the background without showing it up to the user We can do that using Selenium in Python
Help me I want to send whatsapp messages to bulk contacts with individual customized pdf or word docs
@Exceltrainingvideos
2 жыл бұрын
kzread.info/dash/bejne/ZZ-gr6eRZJPMp8o.html
Sir can we send text message also using excel
@Exceltrainingvideos
3 жыл бұрын
This link will help: kzread.info/dash/bejne/ZZ-gr6eRZJPMp8o.html
@ikdeepwaseer
3 жыл бұрын
@@Exceltrainingvideos sir i meant that can we send SMS also using excel vba.. plz help
ActiveSheet.Shapes(1).Copy error sir... What can i do sir... Please help me... and give suggestion to me...
@Exceltrainingvideos
3 жыл бұрын
Check your code.
Sir , not working , do u have an option to send via chrome ?
@Exceltrainingvideos
3 жыл бұрын
Try again. Check your code carefully. Check the wait time. For Google Chrome use: Shell "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe -url web.whatsapp.com/send?phone=919810081867&text=mytext"
@learningtechie2964
3 жыл бұрын
@@Exceltrainingvideos THANK YOU SIR . will check and revert
How to add a dynamic WhatsApp number of the receiver? Thank you
@Exceltrainingvideos
3 жыл бұрын
Try it out. If it works, share it!
What if I want to send multiple images with message on each image can I do so
@Exceltrainingvideos
3 жыл бұрын
You need to study the 'html' code for the space below the added image.
@CraftycreationHQ
3 жыл бұрын
@@Exceltrainingvideos is there any video for that
Can I use this on Google sheets
@Exceltrainingvideos
2 жыл бұрын
Add-ons are available.
This is Not Working...Please Send me Code For Chrome ... I checked in the comment box but I did not understand. Tell me where to declare the code for Chrome Use.
@Exceltrainingvideos
3 жыл бұрын
This link will guide: kzread.info/dash/bejne/ZZ-gr6eRZJPMp8o.html
how to use whatsapp share button in vba for sending pdf file
@Exceltrainingvideos
3 жыл бұрын
kzread.info/dash/bejne/ZZ-gr6eRZJPMp8o.html
Object doesn't support this property or method This message comes can you plz fix this
@Exceltrainingvideos
2 жыл бұрын
Most probably you didn't use the 'References'. Watch the video again. Thanks.
Sir, In this method bypassing QR code ?
@Exceltrainingvideos
3 жыл бұрын
No
can you share method to send single message to multiple contacts without being blocked by WhatsApp
@Exceltrainingvideos
3 жыл бұрын
I don't think that is possible with a standard account. You can contact Whatsapp.
How would you send to multiple phone numbers...
@Exceltrainingvideos
3 жыл бұрын
Create a group.
Sir isme hum trigger lga skte h
@Exceltrainingvideos
2 жыл бұрын
You can try.
Sir i copy code and when i run it showing error 1004 showing yellow color on Activesheet(1).copy..please help me
@Exceltrainingvideos
3 жыл бұрын
Can you share the complete code here in the comments section?
@sabiatasleem7491
3 жыл бұрын
@@Exceltrainingvideos any help Sir
Sir, Can it possible in whats up group?
@Exceltrainingvideos
3 жыл бұрын
Working...
hi sir, how the phone number comes in ? what is the link for that?
@Exceltrainingvideos
2 жыл бұрын
www.exceltrainingvideos.com/automatically-send-message-with-image-via-whatsapp/
The module is showing an (automation error) after running Plz help
@Exceltrainingvideos
3 жыл бұрын
Try again.
Sir please make in Android mobile for doing that in Android mobile can this possible in Android mobile
@Exceltrainingvideos
2 жыл бұрын
Will work on it. I don't have an Android phone at present.
@mehrajmolla6461
2 жыл бұрын
@@Exceltrainingvideossir, is this possible in smart phone (automatic wattsup image) ??
Is this works in Bulk Msg
@Exceltrainingvideos
2 жыл бұрын
You can create a group.
Please Create excel sheet with columns Mobile NUMBER, MSG, PICTURE AND SEND BUTTON Please share it asap
@Exceltrainingvideos
3 жыл бұрын
Please search this channel to solve your problem. There are enough videos to help solve this problem quickly and easily.
Hi sir, how can we automated whatsapp message from Google form responses
@Exceltrainingvideos
2 жыл бұрын
What have you tried?
@shalapkhandelwal1153
2 жыл бұрын
@@Exceltrainingvideos I have not tried anything yet
can u share your sheet with us ?
@Exceltrainingvideos
3 жыл бұрын
This link will guide: www.exceltrainingvideos.com/automatically-send-message-with-image-via-whatsapp/
Sir, how to send my number to other WhatsApp numbers using VB6.0
@Exceltrainingvideos
3 жыл бұрын
Don't know
i went step bu step but not able to please do help me if u can
@Exceltrainingvideos
2 жыл бұрын
This tutorial will help: www.exceltrainingvideos.com/upload-image-pdf-and-video-files-automatically-via-whatsapp/ Installation of the following apps properly is important: Chrome Driver Selenium Selenium Wrapper
phone number shared via url is invalid error
I really want to use this feature i pay some mony
@Exceltrainingvideos
2 жыл бұрын
This Excel VBA lesson will guide: www.exceltrainingvideos.com/automatically-send-message-with-image-via-whatsapp/ Please install the different apps as mentioned on this link: www.exceltrainingvideos.com/upload-image-pdf-and-video-files-automatically-via-whatsapp/
sir koi yesa application h jo whatsapp pe auto reply me image ,photo ,koi document bhejata ho jo ham manually set kare
@Exceltrainingvideos
3 жыл бұрын
Please contact the Whatsapp for the best solution.
@gardentechnology9695
3 жыл бұрын
@@Exceltrainingvideos sir aap apna whatsapp no dijie
How to share same image to multiple people
@Exceltrainingvideos
3 жыл бұрын
You can create a group.
Kindly help with payment
@Exceltrainingvideos
2 жыл бұрын
Already replied. You don't need to make any payment. The details are given below again: www.exceltrainingvideos.com/automatically-send-message-with-image-via-whatsapp/ Please install the different apps as mentioned on this link: www.exceltrainingvideos.com/upload-image-pdf-and-video-files-automatically-via-whatsapp/
Developer not show coding details
Sir kuch time baad Internet explorer.application Wale code me error aata hae and bechme ruk jata hae
@Exceltrainingvideos
2 жыл бұрын
Maybe internet speed problem.
How did this work you didn't add mobile number
@Exceltrainingvideos
2 жыл бұрын
ie.navigate "web.whatsapp.com/send?phone=919810081867&text=" & mytext The above line of code is also in the description accompanying the video.
its stuck on (ActiveSheet.Shapes(1).copy)
@Exceltrainingvideos
2 жыл бұрын
Check your code. This link will also help: kzread.info/dash/bejne/a6iCss2egae3nLQ.html
i face some error plz guide me
@Exceltrainingvideos
3 жыл бұрын
This link will guide: www.exceltrainingvideos.com/automatically-send-message-with-image-via-whatsapp/
give me IMO bulk sms sanding VBA Cord
sir its not working, pl help me.
@Exceltrainingvideos
2 жыл бұрын
Check your code and process again.
HOW TO SEND PDF FILE SEND SIRJI
@Exceltrainingvideos
3 жыл бұрын
Check this Excel VBA tutorial on WhatsApp: www.exceltrainingvideos.com/upload-image-pdf-and-video-files-automatically-via-whatsapp/
Error "User defined is not defined" at 2nd line ie
@Exceltrainingvideos
3 жыл бұрын
Check your code and installations of required software carefully.
@rajendrameghwal6409
3 жыл бұрын
@@Exceltrainingvideos First of all thanks for your valuable reply. Sir may i get coding for send this message by desktop App, i mean without require Code scan for login
Year
@Exceltrainingvideos
2 жыл бұрын
OK
Help me
@Exceltrainingvideos
2 жыл бұрын
These tutorials will help: www.exceltrainingvideos.com/install-selenium-to-use-chrome-with-excel-vba/ www.exceltrainingvideos.com/tag/whatsapp-desktop-automation-with-vba/ You can also search my website or KZread channel.
Not working properly what is this sir
@Exceltrainingvideos
2 жыл бұрын
This link will guide: kzread.info/dash/bejne/a6iCss2egae3nLQ.html What do you mean by what is this?
@digitrixenterprises9382
2 жыл бұрын
@@Exceltrainingvideos its showing error and not working properly not sending images
@Exceltrainingvideos
2 жыл бұрын
@@digitrixenterprises9382 I don't publish ANYTHING without checking it thoroughly on my laptop!
Sir need your mail id
@Exceltrainingvideos
3 жыл бұрын
takyardinesh@gmail.com
@rakeshtc92
3 жыл бұрын
@@Exceltrainingvideos thanks sir
Can I send pdf file also through this method. Please let me know if there are some other changes to be made
@Exceltrainingvideos
3 жыл бұрын
Yes. This Excel VBA tutorial on WhatsApp will guide: www.exceltrainingvideos.com/upload-image-pdf-and-video-files-automatically-via-whatsapp/
Year
@Exceltrainingvideos
2 жыл бұрын
OK