Search results

Hi Nauticalgent, Thanks for the suggestion. However I forgot to update one thing, the mails which are coming to these folders are form mails so default option is not downloading form fields hence that method is not working I have already attempted and failed.

Hi team, I am downloading emails from outlook to ms access using below given codes. Timer function will activate these codes and download mails. But i heard there is a way to directly download the mails from exchange server instead of relying on outlook. Since database will be more stable if...

Many Thanks Bob, That worked like a breeze you have sorted out my head ache. Though I made a small change to the nz function from - I have changed it to + =Nz([text4],0)+Nz([text14],0)+Nz([text21],0)

Hi team, Kindly check the attachment I have a form with few calculated fields (i.e) Total of On job row will be start time - end time for all the rows it work well but I am unable to cumulate the total of all the three totals could you assist?

Is there anything that I need to do in Set db = current db

Firstly I have integrated outlook with ms office so that any mails in the outlook inbox will get downloaded into access if I click a button. Now such an integration is affected when I open some other database. The code checks for the table in the database which is kept opened first. If it is not...

Hi team, I need your assistance in the below issue. Requirement: I need to capture data in a database firstly code has to check if the specific database is already opened if database is opened then data has to be captured else it has to open the specific database and then capture the data...

Thank you very much to all who helped me out. Especially Arnelgp your answers are always to the point.

Hi Ridders, Yes I have tried that too but still getti same error

Hi Arnelgp / Gasman, As you said I tried to debug the code. The var is capturing the taskid from the mails and the same is viewable in the immediate window. The error occurs after the .findfirst completes the entry for last mail item. Ideally after looking into the last mail item it has to go...

I have tried what you have suggested. When I hover the cursor over var it shows taskid = empty. But there are mails with taskid Am I committing any mistakes

I am trying to use the below given procedure to download unique mails but getting error (91 Object variable or with block variable not set) Error in line : .FindFirst "task =""" & Mailobject.UserProperties.Find("taskID") & """" Private Sub getml() Dim rst As DAO.Recordset Dim OlApp As...

The taskid is a field which contains both alpha numeric characters separated by a hyphen e.g. "Task-1234" After applying new code I am unable to download mails is there any suggestion from your end?

I tried assigning a PK for the fields once I do that update queries in the db throws key violation error. Hence I need a vba approach to solve my issue

I am using this code to download certain outlook mail fields into access. This works well however the code is keep on downloading duplicate mails. Is there a way to check for existing records and download records which are not in the table? Your answers would help a lot in my project Private...