Results 1 to 5 of 5
  1. #1
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108

    Emailing data shown in a split form

    Hello,
    I have a split form that i use to maintain and search my database. I am wondering is it possible to make a button to email the filtered search results from the bottom of the split form? so i want to find everyone named Bob.. so i search for all Bob's.. this might not make sense but from there i want to be able to use the filter options on the table view at the bottom of the form to narrow down my results further and make a button to email the final results showing at the bottom of the form.



    i have to filter like this because i get various POC's for teh results. if someone could tell me how i could make a query that would pull all the employee's and only send the POC their specific employee's then that would be amazing and i would love you for ever!! dont get excited.. thats not really that good of deal.. ;P

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Can you upload a sample db so we could have a look? Only the form in question (and the associated tables/queries of course) with just a couple "dummy" records to show want you want to achieve. Do you have Outlook as your email client or something else. I think you are saying you want to send one email to every filtered record in the form with a specific attachment (POC=?). Usually you would have to loop through the form's recordset (or set another to match the filtered form) and create the email message customized for that record.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108
    I will get a dummy DB to upload, i have some things going on now so it might not be till next week.. but yes I use outlook 365 and agree some kind of loop, like below.. i would want all of POC A's employee' record be sent to POC A, ect.. I learned SQL 12 years ago.. and havent used it since unfortunate, so I am rusty to say the least..

    Emp_Name POC
    Employee 1 POC A
    Employee 2 POC A
    Employee 3 POC W
    Employee 4 POC U
    Employee 5 POC W
    Employee 6 POC S
    Employee 7 POC S
    Employee 8 POC W
    Employee 9 POC C
    Employee 10 POC B
    Employee 11 POC B
    Employee 12 POC D
    Employee 13 POC U
    Employee 14 POC C
    Employee 15 POC O
    Employee 16 POC A
    Employee 17 POC C
    Employee 18 POC D
    Employee 19 POC D
    Employee 20 POC E


    I know how to run a query and have Access email the results, but i have a possibility of 25 possible POC's and not are always gonna be on the report. so i dont want to have to run a separate report for each POC. I guess if i could even send one to the POC's that dont have anyone letting know that there is no data to report..??

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Sorry to ask, but what is a POC? In your sample POC A would get what exactly in the email? A list showing three employee names or IDs (1,2 and 16), a message with a PDF file created by using Docm.OutputTo from an Access report,...

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #5
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108
    The POC's are Admin Officers that distribute information about employee's under their department to the supervisors, things like promotions, reassignments ect.. The report would be an excel spreadsheet attachment. the body of the email can be one set template. I hope that answered your questions.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 10-25-2019, 10:09 AM
  2. Replies: 1
    Last Post: 10-20-2017, 12:57 AM
  3. Replies: 3
    Last Post: 10-19-2016, 02:58 AM
  4. Data entered into form is not shown in Table
    By engr_saud1 in forum Forms
    Replies: 5
    Last Post: 04-07-2013, 06:34 AM
  5. Code to sort data shown on a split form
    By meissnerb in forum Programming
    Replies: 1
    Last Post: 05-03-2012, 04:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums