Send emails in outlook from a column of addresses while grabbing row data/changing data

The purpose of this post is to document my progress and ask for help in my endeavor to create a VBA script which loops through email addresses in a column and sends emails in outlook (in the background) to each address. Each email will be personalized with specific data from the current row (customer name, time of appointment, date, address, etc.).

This script will send emails to mobile phone numbers by using a Email to Sms service (smsglobal).

This script will detect which emails are phone numbers and which are true emails (by detecting the @ symbol in the cell.value or not).

This script will skip over blank email address cells.

This script will change the sent/unsent status to SENT after sending the email for the current row.

Attached here is the excel table with no script:
personalized email sender.xlsx

Here is the pseudocode for what I wish to accomplish:

Please Login or Register  to view this content.

Here is a screenshot of the table for visual reference:
zUNP5ZV.png