 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / March 2006Email Query
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.  SignatureRick B >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 [quoted text clipped - 3 lines] > and then make a seperate listing of the names with snail mail addresses > so that i can snail mail them. 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. SignatureRick B > 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. Or ask then user when the query opens if they want email or snail mail listing. Then pull the records based on the response. SignatureRick B >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 [quoted text clipped - 3 lines] > and then make a seperate listing of the names with snail mail addresses > so that i can snail mail them. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.