Working in Access 2007.
I am working with an existing database that has members in a table with up to 3 e-mail addresses for each - these are in separate fields e-mail1, e-mail2 and e-mail3.
I need a list of all e-mail addresses (that is a list of e-mail1, e-mail2 and e-mail3 combined into a single column). It does not need to contain any other information - its just to create a simple text file that I can upload to a listserv with everyone's e-mail address.
I can't for the life of me figure out how to combine several fields into a single column list.
Right now, I'm able to create a query of all e-mail addresses, but not surprisingly, it creates a three column list. I take these and put them into excel where I manually combine them into a single column and delete any blank cells. I want to automate the entire process so that I have a single text file with a list of e-mails.
Hope this makes sense to someone.