Recent content by alexl-123

  1. A

    Code To Send Each Customer An Email With All Of Their Orders

    Hi My Table Structure is as follows 1 table Name Field email Field Order ID field product field status field postcode field house no field batch Id Field hope this helps
  2. A

    Code To Send Each Customer An Email With All Of Their Orders

    Hi Apologies about this, previous orders are not added into this query as when the query is run it assigned a batch id to all the records then when that batch is dispatched the query criteria to send emails is based upon them being in that batch
  3. A

    Code To Send Each Customer An Email With All Of Their Orders

    Hi, I only have one table which has the structure name email Order_ID with regards to the debugging I have changed the code Option Compare Database Private Sub Command2_Click() Dim dbS As DAO.Database Dim rst, drst, nrst As DAO.Recordset Dim tblName As Variant Dim sqlStr, Email, Order_ID...
  4. A

    Code To Send Each Customer An Email With All Of Their Orders

    simply I want Current data Name- Steve-steve-paul-steve-susan-paul email- stevesmail-stevesmail-paulsmail-stevesmail-susansmail-paulsmail order- 1-2-3-4-5-6 Desired Data name - steve-paul-susan emails- stevesmail-paulsmail-susansmail order1- 1-3-4 order2- 2-5- order3- 3- -
  5. A

    Code To Send Each Customer An Email With All Of Their Orders

    just to provide you with some more information to help you all help me imagine this scenario, a customer orders 40 items that creates 40 records with 40 email addresses all the same when I use my update query to mark these all as dispatched another query runs and collects the jobs and then sends...
  6. A

    Code To Send Each Customer An Email With All Of Their Orders

    okay how would this work, what is wrong with my initial code?
  7. A

    New Record using an old record

    make a form property's set to Data Entry create the user input fields required set the property of default value = [forms]![Formname]![FormInputFieldName] this would be reference to your original form so when the new form loaded it would get the values from the originating form then...
  8. A

    Code To Send Each Customer An Email With All Of Their Orders

    Hi, why is this not a good idea and how would I make a loop to do as you suggested? Thanks
  9. A

    Code To Send Each Customer An Email With All Of Their Orders

    Hi, I already have a sub which sends the emails for me the issue is that if 1 customer has 40 orders and I updated them all to dispatched then It would generate 40 emails to that one customer where as I want to send one with all of their orders I have a table (test) It's structure is as below...
  10. A

    Code To Send Each Customer An Email With All Of Their Orders

    Hi, the Debugging I was doing was running the code and seeing what errors it returned then amending appropriately, however I have now got to this stage and Access just crashes when I try to run it. I have tried the F8 key you suggested and it doesn't appear to do anything? sorry about not...
  11. A

    Code To Send Each Customer An Email With All Of Their Orders

    Hi, I am trying to make a VBA Solution that will at the click of a button send an email out to all of my customers with updates on there orders I have got a code to send an email to each record however this means that if a customer has 40 orders they will receive 40 emails, where as I want to...
See more
Back
Top Bottom