Combine vba and bulks sms API with existing criteria in Excel Spreadsheet

Hello,
I have an issue. that i need help with.
I have spreadsheet with vba code that i use to send email via outlook based on certain criteria in a cell. I want to be able to configure it to also use the same Criteria for the API supplied by my bulk sms provider to send sms. The SMS provider has sent me the API now i need to make it to utilize these conditions.
the existing sheet search for an email address in a certain cell and also checks if there is a YES written in another cell for it to generate an email to the address and picks certain information from others cells for the body of the email.
I got an API from my bulk sms provider and has not been able to include it in the code to use the conditions.

Please note that i have checked through similar threads that dealt with API and bulksms but didnt find my solution.

i tried posting the code here but the system keeps giving the below errors
You are not allowed to post any kinds of links, images or videos until you post a few times.




Regards

THIS IS THE CODE BELOW FOR THE SPREADSHEET:

Sub Notification()

Dim OutApp As Object
Dim OutMail As Object
Dim cell As Range

Application.ScreenUpdating = False
Set OutApp = CreateObject("Outlook.Application")

Originally Posted by Goodi

THIS IS THE CODE BELOW FOR THE SPREADSHEET:

Sub Notification()

Dim OutApp As Object
Dim OutMail As Object
Dim cell As Range

Application.ScreenUpdating = False
Set OutApp = CreateObject("Outlook.Application")

can anyone help me out on this, i keep getting the error message that i cant post code or images or attachments until i have made a number of posts, how do i get around it, how many posts do i need to make in order to be enabled.