In the U.S., MMS messaging is currently supported by AT&T, MetroPCS, Sprint, T-Mobile USA, U.S. Cellular, and Verizon Wireless. This covers the majority of subscribers across the country.
If your message is being sent to a number that isn't on one of these networks, they'll receive a text message linking them to the content. That way, you'll still get your message across!