 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / September 2007How do I...
I know how to import e-mails into Access. But I want to have Access to query itself and send an e-mail. For example... My master list is.. Jon Doe Jane Doe Steve Doe However in my table are only records for Jon Doe and Jane Doe. I would like an e-mail to be sent out stating that Steve Doe does not have a record. Is this possible??! Maybe I'm asking too much but if someone can help, that would be great. Thanks. Assuming you've got two tables, one with all three names, and one with only the two names, you can create a query that lists who's in table1 but not in table2, and then use that to generate a report that you then e-mail. Rather than me typing out instructions for all of the steps required, how about you say what part(s) you don't know how to do?  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) >I know how to import e-mails into Access. But I want to have Access to >query [quoted text clipped - 15 lines] > > Thanks. You'll have to excuse me, I am new and still learning Access, but... I know how to create a query, but I don't know how to create one that checks a table based on another table. I also do not know how to have Access send an e-mail. Thanks, David >Assuming you've got two tables, one with all three names, and one with only >the two names, you can create a query that lists who's in table1 but not in [quoted text clipped - 8 lines] >> >> Thanks. When you go to create a new query, you're given a number of choices. One of them should be "Unmatched Query Wizard". Choose that, and have it walk you through the exercise of creating a query that lists all rows that are in table 1 but not in table 2. For help with e-mailing from Access, see the Microsoft Access EMail FAQ that Tony Toews has at http://www.granite.ab.ca/access/email.htm SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > You'll have to excuse me, I am new and still learning Access, but... > [quoted text clipped - 21 lines] >>> >>> Thanks. |
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.