[duchnmex]

So I am at my new job, and have been handed a Raiser's Edge DB that might not have been kept up with best practices. I am trying to run a constituent query and output email address.

Currently we are keeping track of email addresses in the bio1 tab not the addresses tab.

what filter/output field can i select to see the constituents email addresses?

This is a very basic operation, thanks for your help and comments.

[Jo Ward]

Email addresses are considered phone types, and phones are associated with a particular address. Since you are recording them on the Bio 1 tab, you are associating them with the Preferred Address.

You don't say what other information you might want or need, but usually you'll have better results from Export for something like this. If you have a query of all of the constituents you want, you can feed that query into Export and in the output, ask for Name and the under under Address, choose Preferred Address. Then scroll past all of the address fields until you come to the Phones category and select Phone number. Export will ask how many phones you want for each record. Say 1, and select email as the type. If you want more than one phone type, do not answer 2 or 3 to the how many phone types question. Instead, position your cursor at the top of the Export output (where it says New Constituent Export) and select Phone number again. This will give you another chance to specify how many phone types and which one. Answer 1 again, and select Home as the type. Continue until you have all of the phone types you want to dispaly. If some constituent does not have a particular phone type, the export column will be blank, but you will know which phone type it is that is missing because of the order in which you requested them.

Hope this helps.

Jo