+ Reply to Thread
Results 1 to 12 of 12

Want to send Direct Message from Whatsapp Web using Content in Excel

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    5

    Post Want to send Direct Message from Whatsapp Web using Content in Excel

    Hi ,

    I am talking with reference to the thread ... *Excel vba to web.whatsapp.com*

    I have succesfully managed to run this file given by Ravi.
    But I want to customise the message that I am sending.

    In this file , all contacts get the same message which can be useful at times.
    But my requirement is to send different message to different recipient.

    I have to send the schedule of my co employees and the task they have to finish.
    For eg : Hi Jessica, Your schedule for 18 sep is 3:00 pm to 5:30 pm Bathroom Ceiling and 5:45 to 7:45 Hall flooring.

    Here....18 sep , 3:00 pm , 5:00 pm , Bathroom ceiling etc... will be in a cell from which the content will be pulled.

  2. #2
    Forum Contributor
    Join Date
    04-30-2015
    Location
    The Netherlands
    MS-Off Ver
    office 365
    Posts
    195

    Re: Want to send Direct Message from Whatsapp Web using Content in Excel

    For those interested, the post he/she is referencing is https://www.excelforum.com/excel-gen...tsapp-com.html.

    Also, this post might be more suited for the vba sub forum.

    Kind regards,
    Ferdy

  3. #3
    Registered User
    Join Date
    08-19-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Want to send Direct Message from Whatsapp Web using Content in Excel

    Can someone please help me with this?? Or atleast let me know where can i get this solution???????

  4. #4
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Re: Want to send Direct Message from Whatsapp Web using Content in Excel

    Quote Originally Posted by ratneshpathak12 View Post
    Can someone please help me with this?? Or atleast let me know where can i get this solution???????
    Hi Ratnesh Pathak,
    PFA a recent version . Following Functionality added now

    1. Six Variables introduced
    2. Performance optimized
    3. Capture TIme stamp of message delivered in Col. 9
    4. To avoid resending of messages, I have introduced a condition. If col. 9 is not empty than the Whatsapp will not be delivered for that row. If you want to resend, please delete Col 9 value for the record and you will be able to resend it.



    Keep me posted.

    Do add reputation if I have been able to help you .

    Thanks
    Last edited by Ravisca2003; 10-15-2018 at 12:42 AM.

  5. #5
    Registered User
    Join Date
    09-20-2017
    Location
    Azerbaijan,Baku
    MS-Off Ver
    2010
    Posts
    3

    Re: Want to send Direct Message from Whatsapp Web using Content in Excel

    Hi Ravisca 2003,
    Is it possible to send attachment ?

  6. #6
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Re: Want to send Direct Message from Whatsapp Web using Content in Excel

    Dear Alesker,

    unfortunately Not yet possible. if you have any solution, pls do share.

  7. #7
    Registered User
    Join Date
    09-20-2017
    Location
    Azerbaijan,Baku
    MS-Off Ver
    2010
    Posts
    3
    Quote Originally Posted by Ravisca2003 View Post
    Dear Alesker,

    unfortunately Not yet possible. if you have any solution, pls do share.
    ,😖 Thank you for reply

  8. #8
    Registered User
    Join Date
    04-10-2019
    Location
    jordan
    MS-Off Ver
    2016
    Posts
    6

    Re: Want to send Direct Message from Whatsapp Web using Content in Excel

    thanks a lot for all
    may I ask if i want to send image

  9. #9
    Registered User
    Join Date
    07-06-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    73

    Re: Want to send Direct Message from Whatsapp Web using Content in Excel

    Hi Ravikanth, Thans for the facility and really Appreciated your code.. I have tried to send big messages in line1,Line2,Line4, Line4,Line5,Line 6 that contains character like Alpha Numeric Signs, Symbols, etc.. e.g. %,&,_. But there seems some issue as the messages are broadcasting to first user only. while we can see in whatsapp display, it searches for message instead of cell no.I have 5 lines with differnt data to be sent to almost 50 people. I have tried this by using MS office 2007 excel file. Also followed your instructions as mentioned in your post.

    Can you please throw some light on this..

    Regards,

    Kundanlal

  10. #10
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Want to send Direct Message from Whatsapp Web using Content in Excel

    @ kundantal
    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

  11. #11
    Registered User
    Join Date
    07-06-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    73

    Re: Want to send Direct Message from Whatsapp Web using Content in Excel

    Dear Sir,

    Thanks for your note. Actually I posted in the same thread because I have used the code that was posted by Mr. Ravikanth and I was getting some error. I will certainly post different thread but how to mark it to Mr Ravikanth (@ravisca2003) as it is his code.

    Kindly guide.

    Regards..

    Kundanlal

  12. #12
    Registered User
    Join Date
    12-29-2019
    Location
    Johannesburg
    MS-Off Ver
    2010
    Posts
    1
    Quote Originally Posted by onejan View Post
    thanks a lot for all
    may I ask if i want to send image
    Good day,

    Did you get a solution about this thread

    Regards

+ 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. send whatsapp messages from excel
    By raj soni in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2019, 04:14 PM
  2. vba to send msg on whatsapp
    By ahmedatef86 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-13-2018, 07:58 AM
  3. 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
  4. Excel VBA to Web.Whatsapp
    By chhiew in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2017, 02:23 AM
  5. Direct Linking to Outlook message
    By VitoBdG in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-10-2014, 04:13 AM
  6. Send mail if Excel content is changed
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-02-2013, 02:55 AM
  7. [SOLVED] How Can I send customized email content by Excel VBA
    By new.microsoft.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2005, 04:06 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