Recent content by MatthewM

  1. M

    MS Access VBA Loop Not working

    Thank you all I got it to work with the help of plog.
  2. M

    MS Access VBA Loop Not working

    Sorry about miss the recordset part, I tried to find a few email codes that would work and that is the one that i found and i just kept what worked. As for the me. i get that it looks at the form, which i am using but i would need it to go to the next record after it sends that email. If I don't...
  3. M

    MS Access VBA Loop Not working

    it is coming off a query that i have set up on my database. I use a form so that I can remove emails that I would not want to send them to. It is a split form that I use and I filter some of the emails that I may not need to send to those people, i use the query to filter out people that have...
  4. M

    MS Access VBA Loop Not working

    That is where the Email address that I am sending it to goes.
  5. M

    MS Access VBA Loop Not working

    I have tried that it does not move to the next record with or without the movenext. Both ways it sends out like 25 emails.
  6. M

    MS Access VBA Loop Not working

    Hi All, I am trying to get my Database to send an email with and attachment, I have that part working. It it the Loop that I am having an issue with. I have the code to look at a folder and attache the correct attachment but my code does not go to the next record. I have the code looking at form...
  7. M

    Solved HELP With Access to Excel

    Attached is the full code at range A110 is where i made a new Sub Aug02()
  8. M

    Solved HELP With Access to Excel

    I wrote the code to go down to 165 lines. If it does not then the code stops. I have broken it up into two Sub()'s but I can not get it to go into one excel workbook. It opens two of the same sheet.
  9. M

    Solved HELP With Access to Excel

    Do you know of a way that i can send it to the already open excel sheet. right now it opens two.
  10. M

    Solved HELP With Access to Excel

    Sorry I did not understand but now I got you.... The Error that I get is "Compile error: Procedure too large"
  11. M

    Solved HELP With Access to Excel

    Guy, What i posted was just a small part of the code. It runs until row 165 or the data is blank.
  12. M

    Solved HELP With Access to Excel

    I have an MS Access DB that pulls records from two tables (FYI this is for inventory). Boss has a premade Excel workbook that the information needs to go into. I use a Query to make sure that the data is from where she needs. then i have a VBA to export it out to the excel workbook, but Access...
Top Bottom