Search results

  1. M

    Help on Lookup Please

    Thanks for your response. Ward is just the name given to the field with the town names. It does need to go in that table because of reports that come off that table. Any suggestions on a way for it to populate? Cheers
  2. M

    Help on Lookup Please

    All, I am getting stuck on this and need some help please. I need a value placing in one field dependant upon another field relevant to a list in a sub table like lookup in excel. I have my master table (T_Main List) Fields: ID, Ward & Area & ......... I have a sub table (T_Ward)...
  3. M

    Table data into BCC for emailing multiple recipients in one email.

    Minty, That is wonderful, thank you. One point though when in the outlook e-mail it shows e-mails like this Email_company.co.uk#mailto:email_company.co.uk#. This then requires modifying, is this from access or how it pulls through? Thanks again for all of your help, you are brilliant
  4. M

    Table data into BCC for emailing multiple recipients in one email.

    Minty, Sorry I am so slow but I don't understand v basic much, including things like the names that you have been using e.g continuation and declaration I have made a couple of changes and added your code in, I have attached screenshot, Please can you take a look and see what needs changing...
  5. M

    Table data into BCC for emailing multiple recipients in one email.

    Thanks for your continued help, I replaced that line as suggested and it went red, I tried to run it but got a sintax error Here is my current code Private Sub Command6_Click() Dim rst As DAO.Recordset Dim strEmailAddress As String Dim strSubject As String strSubject = "From...
  6. M

    Table data into BCC for emailing multiple recipients in one email.

    Thanks for your help most deeply appreciated. I still get the same error with the same yellow and arrow, my new code is below Private Sub Command6_Click() Dim rst As DAO.Recordset Dim strEmailAddress As String Dim strSubject As String strSubject = "From Ryedale" Set rst =...
  7. M

    Table data into BCC for emailing multiple recipients in one email.

    Thanks for Reply, I have tried that here is the new code but still get the message, when I click debug, it highlights the two lines starting Docmd.send in yellow with an arrow pointing at the 2nd line starting , , strsubject Private Sub Command6_Click() Dim rst As DAO.Recordset Dim...
  8. M

    Table data into BCC for emailing multiple recipients in one email.

    Please Help I don't know vba and need to get this working. My current code is as follows Private Sub Command6_Click() Dim rst As DAO.Recordset Dim strEmailAddress Set rst = CurrentDb.OpenRecordset("T_Export") Do Until rst.EOF strEmailAddress = strEmailAddress & rst(E - Mail) & ","...
Top Bottom