Closed Thread
Results 1 to 13 of 13

Simple macros to send Whatsapp messages from a Excel sheet

  1. #1
    Registered User
    Join Date
    11-08-2020
    Location
    Madrid
    MS-Off Ver
    Office 365
    Posts
    2

    Simple macros to send Whatsapp messages from a Excel sheet

    Hi,

    I have developped a simple solution to send Whatsapp messages from an Excel sheet. I have based my development in others found in Youtube.
    The idea is to enable sending notification messages to WhatsApp contacts (either Groups or individuals).
    The ActiveSheet contains a table with the following fields:

    1) Name (group or individual) - (optional)
    2) Mobile phone number - (optional)
    3) Notification date - (mandatory)
    4) Notification message - (mandatory)
    5) Notification sent date

    There are two buttons:
    1) Send Whatsapp messages based on names
    2) Send Whatsapp messages based on mobile number

    Notification messages already sent are not sent again, no matter you press button 1 or button 2

    You must have Chrome as your predertemined navigator in Windows, and open Webwhatapp.com in Chrome
    Attached Files Attached Files
    Last edited by JuanAmor; 11-19-2020 at 03:09 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Simple macros to send Whatsapp messages from a Excel sheet

    Note: All content, including code names and comments, is in Spanish.

  3. #3
    Registered User
    Join Date
    11-08-2020
    Location
    Madrid
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Simple macros to send Whatsapp messages from a Excel sheet

    Yes, everything is in Spanish. Quite simple to translate using Google Translator.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Simple macros to send Whatsapp messages from a Excel sheet

    This is an English-speaking forum, though, so the expectation is that anything shared here be in English. Please bear this in mind in future. And no, Google Translate cannot accurately translate everything!!!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Simple macros to send Whatsapp messages from a Excel sheet

    Quote Originally Posted by AliGW View Post
    Google Translate cannot accurately translate everything!!!
    It can, 99.9% of the time if you use proper English that is stored in their databases, instead of new-age slang that we are so used to.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Simple macros to send Whatsapp messages from a Excel sheet

    Wrong, Adam.

  7. #7
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Simple macros to send Whatsapp messages from a Excel sheet

    Quote Originally Posted by AliGW View Post
    Wrong, Adam.
    oh? got an example?

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Simple macros to send Whatsapp messages from a Excel sheet

    Google is your friend - there are hundreds of examples. You can make yourself understood using Google Translate (as you have done yourself on occasion here on this forum in the non-English section), but don't expect it to be perfect, even if your English is faultless.

  9. #9
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Simple macros to send Whatsapp messages from a Excel sheet

    Created a new thread for the Google Translate discussion to avoid hijacking JuanAmor's thread.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Simple macros to send Whatsapp messages from a Excel sheet

    There's nothing further to discuss, so it won't be used by me, Jeff, but thanks anyway.

  11. #11
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Simple macros to send Whatsapp messages from a Excel sheet

    Quote Originally Posted by AliGW View Post
    even if your English is faultless.
    it can't possibly be faultless. I don't live in England and the USA both.

    that's the closer for this thread. moving on...

  12. #12
    Registered User
    Join Date
    02-27-2022
    Location
    Sudan
    MS-Off Ver
    2019
    Posts
    1

    Re: Simple macros to send Whatsapp messages from a Excel sheet

    could you help to add code for the existing code to send picture with text?

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Simple macros to send Whatsapp messages from a Excel sheet

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Please help me code on VBA to send bulk whatsapp messages & emails
    By painfullystoic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2021, 02:35 PM
  2. How to create excel sheet for sending WhatsApp messages
    By Liza Express in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2021, 08:43 AM
  3. send whatsapp messages from excel
    By raj soni in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2019, 04:14 PM
  4. I want to send video message to whatsapp from Excel sheet to many numbers
    By rizwanahm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-01-2019, 02:51 AM
  5. Send whatsapp bulk messages using vba to unknown numbers
    By bhupeshsingal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2018, 11:36 AM
  6. Send whatsapp bulk messages using vba to unknown numbers
    By bhupeshsingal in forum Excel General
    Replies: 1
    Last Post: 10-16-2018, 07:42 AM
  7. Send message to myself in WhatsApp form Excel VBA
    By BillDoor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-22-2018, 03:40 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1