Just be careful not to spam which is defined as many messages in a short period of time / a maximum limit of 1000 per day from a Business WhatsApp account (not a paid subscription).
As you send message one by one I would suggest watching this video to make it easier for you: Excel to WhatsApp: Send Messages with Attachments for FREE! ruclips.net/video/5Q8FQ_i9_8g/видео.html
Not with the hyperlink formula but watch this video for a more advanced solution Excel to WhatsApp: Send Messages with Attachments for FREE! ruclips.net/video/5Q8FQ_i9_8g/видео.html
Hi can we create automation whatsapp message, for example in this video suppose payment was increased by $300 to $350, i want there whatsapp msg shoot automatically to the customer without click on send whatsapp.
This worked nicely when I had regular text in the target cell but it brings up a #value! error as soon as I target a cell with generated text. I changed no other code in the cell and the generated cell works great if I copy-paste it to a whatsapp message. can anyone tell me why this is happening?
If you have more than 265 characters it won’t work. Try this solution Excel to WhatsApp: Send Messages with Attachments for FREE! ruclips.net/video/5Q8FQ_i9_8g/видео.html
If you try to send over 165 characters it will show an error with the formula, try this solution instead: Excel to WhatsApp: Send Messages with Attachments for FREE! ruclips.net/video/5Q8FQ_i9_8g/видео.html
I will appreciate if u cud share the video of sending messages from Excel automatically - no more clicking on the Send button,as I have to send atleast 120-130 msgs in a single go.Also suggest how to include PDF and JPG files with the msgs.
i copy paste the whatsapp link, when i click it, the whatsapp page will said 'This link is incorrect. Close this window and try a different link.' Any idea?
Download the practice file here: bit.ly/3BoJepZ - Remember there is a 256 Character limit in the message,
The problem is that WhatsApp opens a new tab on every contact. How can I configure it to open in the same tab?
For every send message the a new whats ap session starts. Is there a setting to be updated ??
How to keep the message as paragraph? It transfers it as one line
Hi, Good morning from Malaysia, is this method have usage limit? such as 10 message a day. etc? Thank you.
There is no limit for the number of messages only 160 character limit for the actual message.
this makes blasting less hassle without subscribing any plan. thanks a lot!
Just be careful not to spam which is defined as many messages in a short period of time / a maximum limit of 1000 per day from a Business WhatsApp account (not a paid subscription).
Thanks for reminding me! Not really that many blasting. Just for event reminder. So yeah. Pretty convenient
Good day, why would I get an error like this Couldn't look up phone number " because it's too short. How should the number be structured?
Thank you
You need to have the full code together with the international dialling code in 0044 format for example ..
@@SkillUpAndExcel I am in South Africa our code is +27 , I seem to struggle to get it to work, any suggestions
This is wonderful, thank you very much. Can I also send a picture attachment using this method and how?
Check the pinned comment for the video that’s allows images .
Hey i tried but its showing the error value! I have too much information in the text is that fine?
Hi the character limit is 255 so that’s why the error comes, watch the other video here for a better solution :
Excel to WhatsApp: Send Messages with Attachments for FREE!
ruclips.net/video/5Q8FQ_i9_8g/видео.html
Can I send the message on the WhatsApp group instead of individual number?
As of now this option isn’t available
Do I need to use Web WA or Desktop WA for sending the messages from Excel ?
@shushantgoel please watch this space I will have a perfect video for you in the coming week…
@@SkillUpAndExcel
Can I send WA messages from Excel without clicking the send button on WA ?
good to know that there is such possibility. is it possible to use outlook online to send an email in similar way? (without macros or power automate)
Yes there is! Video coming up soon for it ..
@@SkillUpAndExcel Yeah. I'll be waiting
is there any possible way to send all of them in one press ?
Please watch this video for a solution: Excel to WhatsApp: Send Messages with Attachments for FREE!
ruclips.net/video/5Q8FQ_i9_8g/видео.html
suppose I want to send only to paticular person who's dollar is greater then 200 because even if we filter the dollar still it send the message to all
As you send message one by one I would suggest watching this video to make it easier for you: Excel to WhatsApp: Send Messages with Attachments for FREE!
ruclips.net/video/5Q8FQ_i9_8g/видео.html
How to do same in online excel? Or gdrive?
@@gauravbhatt6258 excel
what if i want to send the message not to an especific number but to a group chat in wsp??
This is not possible as of now
@@SkillUpAndExcel thanks for your response :), and i have another question: is it possible to send a message longer than 255 characters??
Not with the hyperlink formula but watch this video for a more advanced solution Excel to WhatsApp: Send Messages with Attachments for FREE!
ruclips.net/video/5Q8FQ_i9_8g/видео.html
@@SkillUpAndExcel thanks you!! :)
Hi can we create automation whatsapp message, for example in this video suppose payment was increased by $300 to $350, i want there whatsapp msg shoot automatically to the customer without click on send whatsapp.
@DXavinash please keep watching the channel I will have a great solution for you shortly for WhatsApp automation!
Hi , in my case its msg is somtimes loading and sometimes not loading into the typing bar please help
Try to restart the excel and WhatsApp screen, it can help.
Hi
I am getting an error in formula as "Value!"
I have long message
Hyperlink will allow only 255 character limit, check the video below 👇 that might help: ruclips.net/video/5Q8FQ_i9_8g/видео.htmlsi=mI7TTxg7Wiua3cDV
Can you send me this sheet?
Download link is in the description
This worked nicely when I had regular text in the target cell but it brings up a #value! error as soon as I target a cell with generated text. I changed no other code in the cell and the generated cell works great if I copy-paste it to a whatsapp message.
can anyone tell me why this is happening?
ok. I see now that you answered below that long messages with more than 255 characters would not be acceptable. thanks.
send excel file please
bit.ly/3BoJepZ
Can I send WA messages from Excel without clicking the send button on WA ?
WhatsApp link is not working
If you have more than 265 characters it won’t work. Try this solution Excel to WhatsApp: Send Messages with Attachments for FREE!
ruclips.net/video/5Q8FQ_i9_8g/видео.html
formula shown an error
If you try to send over 165 characters it will show an error with the formula, try this solution instead: Excel to WhatsApp: Send Messages with Attachments for FREE!
ruclips.net/video/5Q8FQ_i9_8g/видео.html
all text is in one line while I added char(10) too.
Still one by one. No bulk send
Kindly check this solution out : Excel to WhatsApp: Send Messages with Attachments for FREE!
ruclips.net/video/5Q8FQ_i9_8g/видео.html
it says #value! while i did the same steps
What version of Excel are you using? And at which stage do you get the error?
@@SkillUpAndExcel I have the same problem. Macbook Excel version 16.89.1
Apparently there is a limit on the number of words in the message.
The number of characters are limited to 160 In this case
I will appreciate if u cud share the video of sending messages from Excel automatically - no more clicking on the Send button,as I have to send atleast 120-130 msgs in a single go.Also suggest how to include PDF and JPG files with the msgs.
@shushantgoel please check this video: Excel to WhatsApp: Send Messages with Attachments for FREE!
ruclips.net/video/5Q8FQ_i9_8g/видео.html
It says #VALUE!
Are the characters above 255? If so then that’s the reason
i copy paste the whatsapp link, when i click it, the whatsapp page will said 'This link is incorrect. Close this window and try a different link.'
Any idea?
Facing the same issue.
@@atifkhurram2785 I bought whatsapp Programe in shopee, cost me usd5, works like charm
What version on Excel are you using? Do you have WhatsApp web or desktop version?
@@SkillUpAndExcel Latest Office 365 and i tried it after signing in WhatsApp using chrome
Same Situation
, please help
Assalam-o-Alaikum
You speak Urdu ?
this api link is not working
what's the issue?