Figured it out!!!!
Well part of it.
I finally figured out how to create the query that created the full email address based on the user's selection of carrier.
Here is the SQL View of the query I made.
Code:
SELECT Contact.[Mobile Number], Contact.[Mobile Carrier], Carriers.[Carrier eMail], [Mobile Number] & "@" & [Carrier eMail] AS SMSEmail
FROM Carriers INNER JOIN Contact ON Carriers.[ID] = Contact.[Mobile Carrier];
Now on to design a table that tracks the messages sent to those emails and sending of the actual email itself.