Using secondary email address [#961184]

I'd like to use Mass Contact to send out SMS notifications via email. This would require storing and using a secondary email address for SMS notification (e.g. 123456789@vtext.com) for each user, which is easy enough to do on the user's profile.

In looking at the Mass Contact code, I see the query "SELECT name, mail FROM {users} WHERE..." that selects the user's email. That would obviously need to be changed to query the secondary email field, wherever it may be stored. Then there's the issue of letting someone select or specify that field in the first place.

I may be forced to look into implementing this myself and then offer it back as a contribution to this module, but has anyone else done anything similar? I'll go look for some other Drupal module that may do something similar so I can copy/paste as much code as possible to select another profile field as a secondary email address, but I would really appreciate any pointers to something more specific.

Comments

Comment #1

oadaeh CreditAttribution: oadaeh commented 4 November 2010 at 23:44

If you're okay with a quick and dirty solution, you should be able to just modify the relevant SQL statements to get what you want. You'll probably have to do an inner join connecting where the sms e-mail address is saved and the users table, joining those tables with the uid field.

AFAIK, there is nothing in existence that does what you're looking for. And there's not much in the SMS department at all (other than the framework). I developed a simple module for an intranet site to send SMS messages to individual users using a Content Profile cell phone field and the SMS Framework module, because there wasn't anything that did it already.