Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-21-2019, 12:38 AM   #1
Freshman
Newly Registered User
 
Freshman's Avatar
 
Join Date: May 2010
Location: South Africa
Posts: 363
Thanks: 21
Thanked 7 Times in 7 Posts
Freshman is on a distinguished road
WhatsApp

Hi all,

I came across this info regarding sending WhatsApp messages via the web (PC).

https://faq.whatsapp.com/en/android/26000030/?lang=lt

I can use FollowHyperLink to action a new message but I still have to click on the <Send> button in WhatsApp.

It is not a problem for Single messages but I would like to roll this out to Bulk Messaging a group of people.

Any ideas on how I can fully automate this?

Thanks a lot

__________________
Windows 7
MS Access 2007

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Freshman is offline   Reply With Quote
Old 01-21-2019, 01:54 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,779
Thanks: 425
Thanked 841 Times in 800 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: WhatsApp

Do you mean you want to use MS Access to spam WhatsApp users?

Sent from my SM-G925F using Tapatalk
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 01-21-2019, 01:57 AM   #3
Freshman
Newly Registered User
 
Freshman's Avatar
 
Join Date: May 2010
Location: South Africa
Posts: 363
Thanks: 21
Thanked 7 Times in 7 Posts
Freshman is on a distinguished road
Re: WhatsApp

Quote:
Originally Posted by Uncle Gizmo View Post
Do you mean you want to use MS Access to spam WhatsApp users?
Haha - don't jump to conclusions - I'm sending notices to a close-group of members

__________________
Windows 7
MS Access 2007

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Freshman is offline   Reply With Quote
Old 01-21-2019, 02:03 AM   #4
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,779
Thanks: 425
Thanked 841 Times in 800 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: WhatsApp

Quote:
Originally Posted by Freshman View Post
Haha - don't jump to conclusions - I'm sending notices to a close-group of members
I actually like the idea of sending WhatsApp messages from Access, could be very useful.

However, it's not clear to me what the actual problem is?

Sent from my SM-G925F using Tapatalk
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 01-21-2019, 02:05 AM   #5
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,779
Thanks: 425
Thanked 841 Times in 800 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: WhatsApp

Is there an API interface for WhatsApp?

Sent from my SM-G925F using Tapatalk
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 01-21-2019, 02:24 AM   #6
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,682
Thanks: 40
Thanked 3,463 Times in 3,352 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: WhatsApp

there is - at a price (at least to use it). Just google 'WhatsApp api'
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 01-21-2019, 02:40 AM   #7
Freshman
Newly Registered User
 
Freshman's Avatar
 
Join Date: May 2010
Location: South Africa
Posts: 363
Thanks: 21
Thanked 7 Times in 7 Posts
Freshman is on a distinguished road
Re: WhatsApp

I agree - there is an API but at a price.
The code/URL string in my OP is however from WhatsApp's official website.
I'm using it at the moment and it works fine but you have to manually click on <Sent>
which I would like to automate to make the above option even more powerful
I normally stay away from SendKeys so don't think that can work

__________________
Windows 7
MS Access 2007

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Freshman is offline   Reply With Quote
Old 01-21-2019, 02:56 AM   #8
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,682
Thanks: 40
Thanked 3,463 Times in 3,352 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: WhatsApp

as with anything on the web - if it's free it will never quite do what you want for business, most free stuff is targeted at consumers to provide a marketing channel for businesses.

So with regards automating to bulk recipients, the link you provided is for a single chat. So I don't think you will be able to adapt it to your requirements
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 01-21-2019, 03:13 AM   #9
Freshman
Newly Registered User
 
Freshman's Avatar
 
Join Date: May 2010
Location: South Africa
Posts: 363
Thanks: 21
Thanked 7 Times in 7 Posts
Freshman is on a distinguished road
Re: WhatsApp

Quote:
Originally Posted by CJ_London View Post
as with anything on the web - if it's free it will never quite do what you want for business, most free stuff is targeted at consumers to provide a marketing channel for businesses.

So with regards automating to bulk recipients, the link you provided is for a single chat. So I don't think you will be able to adapt it to your requirements
I like to try and think out the box with free stuff and making them do what I want.
I can easily loop through a list of mobile numbers to do some of this but I would still like to find a solution for the <Send> button.
Maybe someone here has web coding knowledge and can build a "wait until fully loaded" command with a command to trigger the send button inbetween the loops.
I've seen over the years that while we chat about why something is not possible, someone else is already working on a solution. You can do amazing things with VBA
__________________
Windows 7
MS Access 2007

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Freshman is offline   Reply With Quote
Old 01-21-2019, 03:21 AM   #10
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,682
Thanks: 40
Thanked 3,463 Times in 3,352 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: WhatsApp

Sorry, thought you wanted to send a message once to a group of people, not same message separately to multiple individuals.

Suggest google something like 'vba to click a button on a web page', you'll get a number of hits with different possible solutions.

Be aware that some sites (don't know about WhatsApp) can detect multiple messaging of this type and ban you as a potential spammer
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 01-21-2019, 03:25 AM   #11
Freshman
Newly Registered User
 
Freshman's Avatar
 
Join Date: May 2010
Location: South Africa
Posts: 363
Thanks: 21
Thanked 7 Times in 7 Posts
Freshman is on a distinguished road
Re: WhatsApp

Thanks - gonna try that!
__________________
Windows 7
MS Access 2007

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Freshman is offline   Reply With Quote
Old 01-21-2019, 07:24 AM   #12
shadow9449
Newly Registered User
 
Join Date: Mar 2004
Location: Toronto, Ontario
Posts: 952
Thanks: 6
Thanked 38 Times in 36 Posts
shadow9449 will become famous soon enough shadow9449 will become famous soon enough
Re: WhatsApp

I haven't looked into it carefully to know if it's realistic, but I know that Twilio has a WhatsApp integration. The documentation includes the syntax for cURL: https://www.twilio.com/docs/sms/whatsapp/quickstart

So if you can convert that to VBA it should be quite doable.

Maybe consider looking into that?
shadow9449 is offline   Reply With Quote
Old 01-21-2019, 09:17 AM   #13
Freshman
Newly Registered User
 
Freshman's Avatar
 
Join Date: May 2010
Location: South Africa
Posts: 363
Thanks: 21
Thanked 7 Times in 7 Posts
Freshman is on a distinguished road
Re: WhatsApp

Ahh great - Just not sure if I'll be able to convert it to VBA...
__________________
Windows 7
MS Access 2007

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Freshman is offline   Reply With Quote
Old 01-21-2019, 10:20 AM   #14
shadow9449
Newly Registered User
 
Join Date: Mar 2004
Location: Toronto, Ontario
Posts: 952
Thanks: 6
Thanked 38 Times in 36 Posts
shadow9449 will become famous soon enough shadow9449 will become famous soon enough
Re: WhatsApp

Quote:
Originally Posted by Freshman View Post
Ahh great - Just not sure if I'll be able to convert it to VBA...
Maybe someone who knows more about HTTP requests in VBA and cURL can lend a hand. I did a search once on "convert curl to VBA" and got a few hits. Maybe those can help

shadow9449 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Send data to Whatsapp hankla General 2 01-06-2017 12:44 AM
Microsoft Access integration with Whatsapp cysklement General 1 10-30-2014 12:42 AM




All times are GMT -8. The time now is 08:49 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World