Email Query

  • Thread starter Thread starter cmichaud
  • Start date Start date
C

cmichaud

I have a query that returns email and name based on other criteria
(Club Name). It returns every record with a certain club name in it
regardless if it has an email not. This makes it difficult when i run
the module to send it to outlook...the module fouls up. how can i
structure the query so that it will return only the users with email
and then make a seperate listing of the names with snail mail addresses
so that i can snail mail them.
 
Just make two queries. One that pulls records where the Email Address field
is not blank and one where it is.
 
Or ask then user when the query opens if they want email or snail mail
listing. Then pull the records based on the response.
 
Rick

Ok. But i am running a macro that runs a module that i guess then
opens up the query. Do i combine the two queries. How. And how do i
limit it only to return records with an email address. i am a newbie
here.
 
To find only records with an email address, just include criteria under the
email address such as..

Is Not Null



As far as the rest, you will have to either adjust your code to run both, or
change it to make this two features. If it were me, I'd have two separate
buttons, one to "print a snail mail listing" and one to "export an email
list". Or something like that.

I'm not sure why you are using functions, queries, and macros.
 
Back
Top