Search results

  1. J

    MS Access - Update Linked Table

    Hi, I found that I was the first in the know about when holidays were being requested as the system that was in place for the company I worked for required all requests to go through Team Leaders/Line Managers, so based on how the HR department calculated an individuals holiday I produced some...
  2. J

    MS Access - Update Linked Table

    Hi, I worked with something like these a good few years ago and I found the best option was to not link to the supplied excel spreadsheet, but to actually import it as a table within the database, that way I found I was able to do the things like you mentioned without any problem. What I did...
  3. J

    Moving text files

    Good afternoon folks, I am using MS Access 2000 and I would like to learn/find out how to write some code that will do the following: I have two drive locations as follows: \\prdfs01\prodreg (B: Drive) and \\qwima400\prodreg (E: Drive) The file structure under both directories is a...
  4. J

    Data Extraction From an .msg File

    Hi arnelgp, Thank you for all your help, that worked, can I ask what was the problem that caused the code error out, was it the fact there were postcodes with no postcode information or was it something else. Anyway your help has been fantastic. Thank you again John
  5. J

    Data Extraction From an .msg File

    Hi arnelgp, Please find attached some more .msg files containing both with and without postcode information in all three postcode fields. Your assistance is most appreciated. Regards John
  6. J

    Data Extraction From an .msg File

    Hi arnelgp, I've re-run the program after checking that those variable were correctly declared as per your post and the same problem occured. Could it be that the postcode field is empty, I have checked each of the text files and found that not all the postcode fields have a postcode in...
  7. J

    Data Extraction From an .msg File

    Hi arnelgp, Just got back into office checked that sub and both variables are declared as per your post. I will run the process again with a smaller number of .msg files and see what happens. Regards John
  8. J

    Data Extraction From an .msg File

    Hi arnelgp, I've finally been able to continue my work with the .msg files and deployed your code, however when I run your code I keep getting the following message: Run-time error 94 Invalid use of Null and then this block of code is highlighted when I select debug: DoEvents...
  9. J

    Data Extraction From an .msg File

    Hi arnelgp, Just briefly back in the office this morning will confirm with you later with results. Thanks once again for your help. Regards John
  10. J

    Data Extraction From an .msg File

    Good morning arnelgp, I clicked on your link, however unfortunatley due to my companie's security protocols in place, I am blocked from accessing your link. could you possible upload the code on here. Your assistance is most appreciated. Regards John
  11. J

    Data Extraction From an .msg File

    Hi arnelgp, On the .msg files I have from Vaillant they appear to be using on this latest batch of email the following in the "From:" part: Vaillant.co.uk vaillant@hrocdigital.co.uk On the initial .msg files I provided in my first post they are using this in the "From:" part...
  12. J

    Data Extraction From an .msg File

    Hi arnelgp, Please find 3 files uploaded. Many thanks John
  13. J

    Data Extraction From an .msg File

    Good morning arnelgp, I would like to thank you again for your assistance with the code to extracting data from an .msg file. I need your assistance again, because the clients without notice have submitted .msg files in a different format, which I didn’t discover until no data was being...
  14. J

    Data Extraction From an .msg File

    Hi arnelgp, Thank you very much for your assistance, it worked a treat, it has enabled me to identify mulitple records for the same customer and we only need to process one record for each customer. If I could ask what was your thought process in your approach to writing that code, this so...
  15. J

    Data Extraction From an .msg File

    Hi arnelgp, Thanks for your assistance here, I will test this, this morning, I've been out of the office. I'll let you know how I get on. Regards John
  16. J

    Data Extraction From an .msg File

    Hi Ranman256, Thank you for your response, I do realise that there will be a need for VBA programming, that's why I posted this in the Modules & VBA section of this forum. For JDraw, I do have access to my G Drive, I use it every single day, so there is no problem there, thank you for your...
  17. J

    Data Extraction From an .msg File

    Hi, I Hoping someone can help me as I’m having problems understanding how to write VBA to extract data from “.msg” files and import that data into a table in my database. I have over 5000 .msg files of which I need to extract the following information: First name: Tim Surname: O'Rourke Street &...
  18. J

    Hi my name is john lee, I was last on the site back in July and today when I came to post a...

    Hi my name is john lee, I was last on the site back in July and today when I came to post a thread I have found that I am no longer allowed to post anything at all and I was wondering why that was. Regards John Lee
  19. J

    Reading contents of .msg file into a text file

    Hi vbaInet, Yes every file has a "First name:" line. Regards John Lee
  20. J

    Reading contents of .msg file into a text file

    Hi vbaInet, It's not as good as I would like it to be, most of the time I'm just dabbling with code that's already been written and then making adjustments to that code to get it to do what I need, if I can get it to do what I need, otherwise I'll search around to see what I can find and ask...
Top Bottom