Updating an email domain

Monday, December 1, 2008

One of our organizational members just changed their email domain. How can I change all the emails at olddomain.org to the same address at new domain.org?

Email addresses, along with all other one-line electronic addresses, are stored in the phone table. This table has a calculated field called domain. This field is blank for anything other than an email address.

So a query like

select addresseesort email
from phone
where phonetype="Email" and domain="olddomain.org"

will collect all the addresses you need to change. Then click EDIT on the ribbon,
and in the dialog tell the system to change the field domain to newdomain.org

Click OK and you've done it!

Tip Category Query
Get this widget!

Powered by Orchid Suites
Orchid ver. 4.7.6.