How To Send SMS Messages From Excel With VBA | Step-by-Step Tutorial

In this tutorial I will show you, how you can send SMS messages directly from Microsoft Excel with VBA.

We will build a POST Request to sms77.io API using VBA.

Excel File of the tutorial [Google Drive]:
👉 https://bit.ly/3fliFTb​

If you want to send multiple messages, please use this workbook [Google Drive]:
👉 http://bit.ly/38r4IkD

🛑 The link to the API has been changed. You can create an API KEY now as follows:

https://pasteboard.co/JR3auFe.png ​

SMS77.IO Documentation: https://www.sms77.io/en/docs/gateway/…

🚩 VBA CODE:

Sub SendSMS()

'Authentication
APIKEY = “YOUR API KEY” ‘CHANGE HERE

'Variables
toNumber = = “RECEIVER NUMBER” ‘CHANGE HERE
BodyText = “TEXT MESSAGE” ‘CHANGE HERE
'Use XML HHTP
Set Request = CreateObject("MSXML2.ServerXMLHTTP.6.0")

'Specify URL
Url = "http://gateway.sms77.io/api/sms?p=​" & APIKEY & "&to=" & toNumber & "&text=" & BodyText & "&details=1"

'Open POST Request
Request.Open "POST", Url, False

'Request Header
Request.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"

'Send Request
Request.send Url

'[OPTIONAL] Get response text (result)
MsgBox Request.responseText

End Sub

Subscribe: https://www.youtube.com/channel/UCZjRcM1ukeciMZ7_fvzsezQ

#excel #excel-vba

What is GEEK

Buddha Community

Data Validation in Excel

Data Validation in Excel

In this tutorial, let’s discuss what data validation is and how it can be implemented in MS-Excel. Let’s start!!!

What Is Data Validation in Excel?

Data Validation is one of the features in MS-Excel which helps in maintaining the consistency of the data in the spreadsheet. It controls the type of data that can enter in the data validated cells.

Data Validation in MS Excel

Now, let’s have a look at how data validation works and how to implement it in the worksheet:

To apply data validation for the cells, then follow the steps.

1: Choose to which all cells the validation of data should work.

2: Click on the DATA tab.

3: Go to the Data Validation option.

4: Choose the drop down option in it and click on the Data Validation.

Once you click on the data validation menu from the ribbon, a box appears with the list of data validation criteria, Input message and error message.

Let’s first understand, what is an input message and error message?

Once, the user clicks the cell, the input message appears in a small box near the cell.

If the user violates the condition of that particular cell, then the error message pops up in a box in the spreadsheet.

The advantage of both the messages is that the input and as well as the error message guide the user about how to fill the cells. Both the messages are customizable also.

Let us have a look at how to set it up and how it works with a sample

#ms excel tutorials #circle invalid data in excel #clear validation circles in excel #custom data validation in excel #data validation in excel #limitation in data validation in excel #setting up error message in excel #setting up input message in excel #troubleshooting formulas in excel #validate data in excel

Laravel 8 Send SMS to Mobile with Nexmo Tutorial

Laravel 8 send sms using nexmo example. In this tutorial, you will learn how to integrate sms gateway and send sms notification to mobile using nexmo in laravel 8 app.

This tutorial will guide you step by step on how to send send sms to mobile with nexmo in laravel 8 app. Now, You need to follow the some step to done laravel nexmo message.

First of all, visit the following link https://dashboard.nexmo.com/sign-in and create nexmo account. Get client id and secret from nexom account.

https://www.tutsmake.com/laravel-8-send-sms-to-mobile-with-nexmo-example/

#send sms with nexmo on laravel #nexmo message send sms #laravel send sms notification #nexmo sms installation laravel #how to integrate sms gateway in laravel

How To Send SMS Messages From Excel With VBA | Step-by-Step Tutorial

In this tutorial I will show you, how you can send SMS messages directly from Microsoft Excel with VBA.

We will build a POST Request to sms77.io API using VBA.

Excel File of the tutorial [Google Drive]:
👉 https://bit.ly/3fliFTb​

If you want to send multiple messages, please use this workbook [Google Drive]:
👉 http://bit.ly/38r4IkD

🛑 The link to the API has been changed. You can create an API KEY now as follows:

https://pasteboard.co/JR3auFe.png ​

SMS77.IO Documentation: https://www.sms77.io/en/docs/gateway/…

🚩 VBA CODE:

Sub SendSMS()

'Authentication
APIKEY = “YOUR API KEY” ‘CHANGE HERE

'Variables
toNumber = = “RECEIVER NUMBER” ‘CHANGE HERE
BodyText = “TEXT MESSAGE” ‘CHANGE HERE
'Use XML HHTP
Set Request = CreateObject("MSXML2.ServerXMLHTTP.6.0")

'Specify URL
Url = "http://gateway.sms77.io/api/sms?p=​" & APIKEY & "&to=" & toNumber & "&text=" & BodyText & "&details=1"

'Open POST Request
Request.Open "POST", Url, False

'Request Header
Request.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"

'Send Request
Request.send Url

'[OPTIONAL] Get response text (result)
MsgBox Request.responseText

End Sub

Subscribe: https://www.youtube.com/channel/UCZjRcM1ukeciMZ7_fvzsezQ

#excel #excel-vba

Excel VBA Tutorial for Beginners 17- Delete Cells using VBA in MS Excel

In this MS Excel VBA video, we are going to see that how can we delete cells in excel using the VB code in the VBA editor

Welcome to the The Beginner’s Guide course to Excel VBA (Visual Basic for Applications). This course enables you to Learn MS Excel VBA in simple and easy steps. In this Microsoft Excel Basics Tutorial series we will start from the basics and gradually move towards the Expert level in Microsoft Excel VBA. This MS Excel VBA course provides the Beginners to Intermediate Excel VBA Skills, Tips, and Tricks. In this course we will learn how to Enter and edit Excel data, Format numbers, fonts and alignment, Make simple pivot tables and charts, Create simple Excel formulas, How to Use Excel Functions IF and VLOOKUP. Learn common Excel functions used in any Office, How to Create dynamic reports, Build Excel formulas to analyze date, text fields, values and arrays and much more advanced stuff.

In this video we will see the Overview of formulas in Excel. We will see Basic Excel formulas & functions with examples .

#excel #excel vba t #ms excel #vba

Send WhatsApp Messages From Excel With VBA Using Twilio | Step-by-Step Tutorial

In this tutorial, I will show you, how you can send WhatsApp messages directly from Microsoft Excel with VBA.

🔥 PLEASE NOTE 🔥
According to Twilio, please be aware that the Twilio Sandbox for WhatsApp is meant for testing and discovery purposes only.
The Sandbox expires three (3) days after joining. After this time, you need to re-join (by re-sending the ‘code’ to Twilio’s number) to continue testing.

More details can be found here:

https://www.twilio.com/docs/whatsapp/…

👉 Excel File of the tutorial [Google Drive]:
https://bit.ly/3lJNmUl​

👉 Excel template for sending a message to multiple numbers [Google Drive]: https://bit.ly/38nXzC6

Subscribe: https://www.youtube.com/channel/UCZjRcM1ukeciMZ7_fvzsezQ

#excel #excel-vba #twilio