How to send email to SMS or MMS

Each phone carrier has its own hostname. To send a text message via email, you’ll need to use a SMS or MMS to SMTP Outgoing email gateway. Just substitute a 10-digit cell number for ‘number’ for each carrier below:

AT&T: number@txt.att.net (SMS), number@mms.att.net (MMS)
T-Mobile: number@tmomail.net (SMS & MMS)
Verizon: number@vtext.com (SMS), number@vzwpix.com (MMS)
Sprint: number@messaging.sprintpcs.com (SMS), number@pm.sprint.com (MMS)
XFinity Mobile: number@vtext.com (SMS), number@mypixmessages.com (MMS)
Virgin Mobile: number@vmobl.com (SMS), number@vmpix.com (MMS)
Tracfone: number@mmst5.tracfone.com (MMS)
Metro PCS: number@mymetropcs.com (SMS & MMS)
Boost Mobile: number@sms.myboostmobile.com (SMS), number@myboostmobile.com (MMS)
Cricket: number@sms.cricketwireless.net (SMS), number@mms.cricketwireless.net (MMS)
Republic Wireless: number@text.republicwireless.com (SMS)
Google Fi (Project Fi): number@msg.fi.google.com (SMS & MMS)
U.S. Cellular: number@email.uscc.net (SMS), number@mms.uscc.net (MMS)
Ting: number@message.ting.com
Consumer Cellular: number@mailmymobile.net
C-Spire: number@cspire1.com
Page Plus: number@vtext.com

Get multiple records in MySQL Database by number of occurrences

If you have problem remembering all abbreviations of U.S. States, use the query below to get data from MySQL Database. In MySQL DB, you must have a state table that include id, state_full_name, state_abbreviation and all records. You must have a table of all users containing some records. The example below are from my own DB, the names of the 2 tables are tblstates and tbluserdetails.

select s.State_name, c.state_name,
count(c.state_name) as NumberOccurrences
from tblstates s, tbluserdetails c
where s.State_Abrv = c.state_name
group by c.state_name
having ( count(c.state_name) > 1 );

The screenshot below is the results from the query above.

Get multiple records in MySQL Database by number of occurrences


Saturday October 10th from 9:00pm to 10:00pm PST

247Apps Scheduled Maintenance

 

We will be making some improvements to our servers to provide greater reliability and performance for our customers.
From 9:00pm to 10:00pm PST, Saturday October 10th, we will be conducting some hardware upgrades to our servers. Services for WordPress Website Builder Elementor, Rental Plugins, Custom Calculation, DownloadInsights customers will be affected. While you may continue to work in open applications, you may experience an interruption to web services during the maintenance period.
We apologize for any inconvenience this disruption may cause and thank you for your patience.

Thank you,
247AppsMobi – Web Services of MyNetworkSolution Dev Team