Using Microsoft Access queries to generate text

[csi]

I have a query that generates a list of email addresses from a table.
The problem I've run into is using the addresses for a mailing list. I
cannot find a way to extract the filtered data into a text box on a
form.

Out of 705 people listed there are a total of 70 with email addresses.
I further filter using organizations, or types of interests they have,
to pinpoint the mailings. I also use dates to check the length of time
since their last activity to determine their ongoing interest. All
this is working as expected.

Using a macro I can export to a number of formats, but they all end up
in a table, or a format I can't get to work.

I've tried finding a method to export into a temporary database, but
have had no luck. If I can get the filtered data into an Access
Database I can create a mailing list from it. If I can get it into a
delimited text file I can work with that also.

Does anyone know of a method to do either one? I sure would appreciate
getting this to do what I want!

Thanks.

 

[SteveM]

Have you looked at the TransferText method?

With that, you can output your query to various formats including a
delimited text file.

Steve

 

[John Spencer]

If you can get the data in a query and you say you can use the data if it
were in an Access table, then just use the query as if it were a table. In
almost all cases a query (in Access) can be referenced and used as if it
were a table.

If that doesn't work for you, you should be able to use the query as the
source for a make table query which puts the data into an Access table.



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[csi]

If you can get the data in aqueryand you say you can use the data if it
were in an Accesstable, then just use thequeryas if it were atable. In
almost all cases aquery(in Access) can be referenced and used as if it
were atable.

If that doesn't work for you, you should be able to use thequeryas the
source for a maketablequerywhich puts the data into an Accesstable.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

I tried both methods an decided to use the query creating a table
since the code was already written to extract the information. I thank
you both for your help.

I am continually amazed at how little I know about using VBA.