Have you ever wanted to send someone a text message from e-mail? Each of the major carriers work the same way – enter the 10 digit phone number followed by the @ symbol, then the carrier specific domain from the list below:
- AT&T – txt.att.net
- Nextel – messaging.nextel.com
- Sprint – messaging.sprintpcs.com
- T-Mobile – tmomail.net
- Verizon – vtext.com
For example, to send a text message via e-mail to an AT&T customer with a number of (555) 444-3210, e-mail to firstname.lastname@example.org.
Remember text messaging is SMS (Short Message Service) which should be limited to 140 characters or less. Otherwise, your e-mail will be broken into multiple text messages, which might not make the recipient too happy. Don’t forget to remove your e-mail signature if you have one.
Technologies Used: Microsoft Visual Studio – VB.NET 3.5, Microsoft SQL Server, and WinSCP .NET Assembly and COM Library
Business Objective: A customer wanted to utilize SunTrust Bank’s Positive Pay Verification for checks written on Accounts Payable as an added security measure and prevent check fraud. SunTrust’s requirements included a formatted file containing all checks issued or voided each business day uploaded to their FTP server. The customer wanted this process automated to reduce dependency on an individual to upload this file daily and prevent errors.
Solution: Working with SunTrust Bank, Jason W. Martin analyzed the requirements and business processes involved to develop a custom solution that is completely automated requiring no interaction on the part of the customer. Using Microsoft Visual Studio, he wrote custom code to access data in a Microsoft SQL database which is the main data storage facility for the company’s ERP system.
The custom solution generates a text file meeting SunTrust Bank’s specifications and sends via WinSCP’s .NET assembly using SSH File Transfer Protocol. Error checking, logging, and event notification which sends e-mail confirmation detailing the specific data sent to SunTrust Bank ensures the daily automated process remains in check and immediate action can be taken should any issue arise.
Because Jason was able to leverage the existing infrastructure and systems the customer already had in place plus the available tools and technologies from Microsoft and WinSCP, he was able to provide a completely automated solution with no additional costs for hardware or software.