queries using email addresses

[RAClarke]

I have some fields in a table that contain email addresses (in data type text, perhaps I should have used hyperlink?). I want to be able to pull out of the table via a query these addresses in order to compose an email. If I do this will I be able to do a straightforward copy and paste into the To box in Outlook?

 

[MMSantiago]

It should work. Even with the datatype as TEXT, the addresses are still in a valid syntax (i.e. person@domain). When you paste the text into Outlook, it'll be the same as if you typed it in manually. Now, if your goal was to allow someone to run the query and then click on the email address to have it create a new message, then you would probably have to change the datatype.