Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bobhallata

    Sending email to multiple address using a query in Access 2007

    The other code that I was playing with for a little bit is below. Dim r As Recordset Dim email As String Set r = CurrentDb.OpenRecordset("select * from QryEmail") Do While Not r.EOF email = email & r(2) & ";" r.MoveNext Loop r.Close DoCmd.SendObject acSendNoObject, Null, Null, email...
  2. bobhallata

    Sending email to multiple address using a query in Access 2007

    Skip, Each course is more unique in that it is it's own record. The instructor drop downs are keyed off of what they are vetted to teach. So when you have a record for delivery of the FRTI course, only instructors who are vetted for that specific course will be available in the drop down...
  3. bobhallata

    Sending email to multiple address using a query in Access 2007

    Skip, I've gone through several different variations of coding while bludgeoning myself but here is the last one. Dim strSql Dim db As Database Set db = CurrentDb() Dim rs As Recordset Dim Lrs As DAO.Recordset Dim Outlook strSql = "SELECT E-Mail FROM QryEmail2" Set Lrs =...
  4. bobhallata

    Sending email to multiple address using a query in Access 2007

    Hello all. This is my first post to the site and I have a problem that I've been beating my head against the wall on for the last couple weeks. I'm sure that it's child's play for most of you. I'm not brand new to VBA coding but I am by no means a master of the art. I have a database that...

Part and Inventory Search

Back
Top