+ Reply to Thread
Results 1 to 11 of 11

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
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,639

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,046

    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!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  5. #5
    Valued Forum Contributor vba_php's Avatar
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    1,678

    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.
    -Adam (please don't call me ""sir"" or ""vba_php"")!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,046

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

    Wrong, Adam.

  7. #7
    Valued Forum Contributor vba_php's Avatar
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    1,678

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,046

    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
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,639

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,046

    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
    Valued Forum Contributor vba_php's Avatar
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    1,678

    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...

+ Reply to 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: 0
    Last Post: 05-05-2020, 05:23 AM
  2. send whatsapp messages from excel
    By raj soni in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2019, 04:14 PM
  3. 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
  4. 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
  5. 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
  6. How to create excel sheet for sending WhatsApp messages
    By Liza Express in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2018, 04:19 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