Search results

Currently, a VBA module in Outlook runs a code where it reads the emails and moves the attachments to a folder in the Share drive and the email with attachment to the archive folder within the mailbox. This action is set up as a Outlook rule. I am using a Access DB to import the contents of the...

Hello, How to run a Outlook rule, which runs a module, from a Access Form Command action? TIA

This morning there was only one item so I was unable to recreate the error. But this is my code, which stopped after the 16th item yesterday. Set OlItems = MYFOLDER.Items 'For Each olMail In OlItems y = olMail.Count Do Until y = 0 If olMail.subject Like...

two things.. it still stopped import after the 16th item, when there was 17 in total. Also, it throws an error at .Name

I modified my code to use Do Loop and count mails first and also used the .Name Set OlItems = MYFOLDER.Items 'For Each olMail In OlItems y = olMail.Count Do Until y = 0 If olMail.subject Like "*Proceeding ID*" Then strFile = olMail & ".XML"...

I am confused by "not deleting the attachments". I am just going through the emails and moving them to a folder. Can you tell me which line(s), I need to modify? Thanks

I modified but still it stops after importing few items.If there are 30+ items, it stops at 18 and I again click the event. Set OlItems = MYFOLDER.Items For Each olMail In OlItems If olMail.subject Like "*Proceeding ID*" Then strFile = olMail & ".XML"...

Can you help with my code with how to loop backwards? TIA

Hi, I had been on vacation and just joined this week. I tried your suggestion but it failed. Probably the For loop wasn't correct. This is my code. How to modify to include your advise? ............................................ Set MYFOLDER =...

I am not sure what you mean by to save all the attachments before moving them? I would need help to modify the above code. Thanks

Hi All, My VBA script uses a loop to download attachments from Outlook into a folder on C. It works well without issues but imports only 8-10 email attachments at a time. I do not get any error in the code and when I click the Import button on the Access Form, it again imports another 8-10...

Thanks much. It worked but for times like 2024-02-27 20:45:01 it updated to 2024-02-29 8:45:01 PM. Is it about settings?

Rather than now(), is it possible to retain the time part and just change the day from 27 to 29? If the value is 2024-02-27 10:18:38, i need it as 2024-02-29 10:18:38 and if it 2024-02-27 10:19:40 it need it as 2024-02-29 10:19:40

I tried an update query on my field, insertdatetime as update to :DateAdd("dd",2,[insertdatetime] and criteria as [insertdatetime] but it updated it to 2024-02-27 and left out the time part :(

We receive a csv file daily in which almost most fields are static except for few fields and the date. Since one daily file was missed , someone erroneously updated the Access table with the csv file of a previous date. The date time field is like 2024-02-25 10:18:38 . Is there a way to update...

Hello Everyone, Looking forwards to learn and exchange MS Access knowledge!