Excel VBA To Web.whatsapp.com

Hi,

I have found the vba code to send messages via https://web.whatsapp.com, the vba code send messages from textbox but the code is incomplete, it doest not search and match the exact contact list, meaning it will send to all people with same surname, i have below questions, hope someone can enlighthen me:

1. how to search and select contact list in https://web.whatsapp.com and match the exact name only, or match phone number?

2. send customized messsages based on messages and contact list in cell value, eg. A1 = contact list, B1 = customomized massages

3. how to insert and send jpeg picture as attachment?

Attached is the vba file.

Thank you so much for your help.

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Hi

Sorry for the mistake, i actually wanted to post this question in vba forum, but made a mistake posted here, i tried to delete this post from here but cant find any delete button

Can you pls advise how to remove this post ? Sorry for any inconvenience caused

Thanks

If you do not have the registered contact you can not send message, and you can register it in google contacts, but for the recipient you can use the number and not the name.

Have you managed to get it work?

Originally Posted by calebseah

Have you managed to get it work?

Not yet. I have been searching for it very long but no solution yet.

I think not viable to do it using vba

Thanks

Hi All,

PFA a file which can help you to send whatsapp from excel using VBA code. The code is basically a joint effort of various people whose code was found on internet and whatever I could do to append the same to meet the purpose.
The code is not very robust but still somehow meeting the purpose so if anyone feels they have a solution to overcome shortcoming, please do share back.
Share your experiences as well !!

Thanks
Ravi

Steps to use are listed below.
1. Download and save template
2. Replace the Col A and Col B with Contact number ( Mandatory ) and Contact Name ( optional )
3. Write your general message in C1
4 Save the file
'this is to open your whatsapp web manually
5.Open Chrome
6. Open whatsapp web and log in manually

7 Come back to excel and click send Whatsapp button.

8 System will as you with a popup message that whether whatsapp is loaded or else. ( this is introduced since in testing sometime whatsapp web was not loaded and the script started running causing mess !!)

9. CAUTION HERE !!! - YOU HAVE TO MANUALLY COME BACK TO YOUR CHROME TAB WHERE WHATSAPP WEB IS OPEN AND LEAVE THE SYSTEM WITHOUT TOUCHING !!!
10 . AGAIN !! WHILE THE SCRIPT RUN, DO LEAVE THE SYSTEM IDLE !!

Dear Ravisca ,
this is working great , thank you
but i need to add attachment do you have any idea?

Hi,

Please help me.

I have download file and replace contact number and message but the message is not sent.

Regards
Helen

Originally Posted by chhiew

Ravisca2003 ,
Thank you so much for sharing, appreciate your help.

Tested the code, not working, no respond after the prompt "is whatsapp loaded, click no to cancel".

Just one more question, can sendkeys function send picture from folder to whatsapp as well? eg. i have picture url path in column C.

Thanks

Hi there,
Please see point number 9 in my post.wait untill web.whatsapp.com is loaded and u r properly logged in. Once it is.done, you have to click YES. On the message whether WhatsApp loaded or else.

Now here is the catch.

Immediately after u press YES , U HAVE TO COME BACK MANUALLY TO THE BROWSER TAB IN WHICH WHATSAPP IS LOADED.

Just to explain u more so that I understand, when u press YES to respond to the message, system passes the active control to this VBA object and could not go back to the WhatsApp window hence user have to intervene manually to do that and that too immediately.

Further send keys can also attach but currently the code does.not.support attachment. If u have any solution to make WhatsApp pick the attachment file as well, I am happy to hear from you as it is something I could.not.get right.

Sorry for typos. Sent from handheld

Good luck.

Originally Posted by HelenDevanatha

Hi,

Please help me.

I have download file and replace contact number and message but the message is not sent.

Regards
Helen

I Helen please follow the steps after checking them once again. Also read my reply to other user as well.

I think you are missing some manual intervention here otherwise the code worked so far so good with most of thwm to.whom I shared.

Originally Posted by Ravisca2003

Hi All,

PFA a file which can help you to send whatsapp from excel using VBA code. The code is basically a joint effort of various people whose code was found on internet and whatever I could do to append the same to meet the purpose.
The code is not very robust but still somehow meeting the purpose so if anyone feels they have a solution to overcome shortcoming, please do share back.
Share your experiences as well !!

Thanks
Ravi

Steps to use are listed below.
1. Download and save template
2. Replace the Col A and Col B with Contact number ( Mandatory ) and Contact Name ( optional )
3. Write your general message in C1
4 Save the file
'this is to open your whatsapp web manually
5.Open Chrome
6. Open whatsapp web and log in manually

7 Come back to excel and click send Whatsapp button.

8 System will as you with a popup message that whether whatsapp is loaded or else. ( this is introduced since in testing sometime whatsapp web was not loaded and the script started running causing mess !!)

9. CAUTION HERE !!! - YOU HAVE TO MANUALLY COME BACK TO YOUR CHROME TAB WHERE WHATSAPP WEB IS OPEN AND LEAVE THE SYSTEM WITHOUT TOUCHING !!!
10 . AGAIN !! WHILE THE SCRIPT RUN, DO LEAVE THE SYSTEM IDLE !!

Hi Ravi,
Thanks a lot for this, It works Great.
I just want to know is there a way i can send a customised message.

I actually want to send message to my co employees their respective timings. I will put in their In time and Out time in a column and would want the VBA Script to load the timings from there. Also I will want to notify them about the project on which they will be working.

Eg :
The message would be sent like "Hi Jessica , Today's Schedule Work on Bathroom design 3:00 pm to 5:30 pm and then Ceiling Decoratives 5:45 pm to 7:45 pm.

Here I would keep Bathroom design and Ceiling decoratives in two cells and intime outtime in another cell.

Hello, I use this Excel file to send WhatsApp messages and this runs very well.
Do you know any configuration to send a file with this excel in WhatsApp?
Thank you

Hi There,

Yes you can do that with my new version. I have created 4 Variables col. in which you can write your variable texts and send it to your users. I have been using it like that for a while.

Originally Posted by ratneshpathak12

Hi Ravi,
Thanks a lot for this, It works Great.
I just want to know is there a way i can send a customised message.

I actually want to send message to my co employees their respective timings. I will put in their In time and Out time in a column and would want the VBA Script to load the timings from there. Also I will want to notify them about the project on which they will be working.

Eg :
The message would be sent like "Hi Jessica , Today's Schedule Work on Bathroom design 3:00 pm to 5:30 pm and then Ceiling Decoratives 5:45 pm to 7:45 pm.

Here I would keep Bathroom design and Ceiling decoratives in two cells and intime outtime in another cell.

Hi There,
Please check this thread. I have uploaded a new version today but somehow I cannot link a file to this reply. SOrry for the confusion and added trouble but what you need is doable with my new version attached.