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 |