I noticed when it was time to send out yesterday's tips newsletter that I still have quite a few email addresses that are @houston.rr.com. Those email addresses will be going away sometime later this year (since Comcast has taken over the local Roadrunner operations.

I realize that it is probably hard for people who have those addresses to remember who they need to send updates to. So I created a quick template that said:

I notice that you have one of the Road Runner email addresses that will be expiring soon. Don't forget to let me know your new email address when you get it.

Once I had the simple template completed, all I needed to do was a lookup. In the newer version of ACT (what would you expect me to be using?), I clicked...

1. Lookup, Advanced, Advanced Query
2. Created the query that says Email Address "Contains" "houston.rr.com"
3. Clicked OK.
4. Then I clicked, Write, Mail Merge.... well you can probably take it from there.

So now I have people emailing me back with their new email addresses.

If you are using an older version of ACT!, you could click Lookup, Keyword Search, in the "Search for" area, type houston.rr.com. In the "Search in" area, uncheck all options by "E-mail Addresses." Clicking Find Now will give you the list that you need.