Search results

I do apologise, but this is all I've got. I know that the rest of the code works fine, since when I cycle through all the emails I mark them as READ and so at the end of the cycle, all of the emails that pass the criteria are marked as READ. However, when I apply the above code to move the...

Good day, The following interrupts code execution once in a while. It basically moves email to the "Imported" folder and a subfolder with the month and year the email was received. This part is general setup of outlook, and creation of strDestMoveFolder = "Imported" if required Set...

Good day, Has anyone experienced the outlookMessage.ReceivedTime property change time (in seconds). Sometimes I extract data and it's for ex. 10:42:00, sometimes it's 10:42:40? Thank you.

Good day, Can folderOutlook.Items.Restrict() accept multiple filters: fromemail and subject? This doesn't work: sCriteria = "@SQL=" & Chr(34) & "urn:schemas:httpmail:subject" & Chr(34) & " like '%Request%'" & _ " " & Chr(34) & "urn:schemas:httpmail:fromemail" & Chr(34) & " like...

Nevermind, got it open by first opening Access 2010 with its VBA editor and then openning the Utilities2003 database Thanks

Thanks how can I view the VBA for it in Access 2010?

Good day, Can an SQL statement contain a VBA variable? I'm trying this: DoCmd.RunSQL "ALTER TABLE tbl_outlooktemp ADD COLUMN 'Categories'&[Count] text;" I want to add columns to table with names Categories1, Categories2, ...etc. Thank you

Directly from .csv

Good day! I'm Access 2010 newbie. I need to transfer Excel program into Access. I have a .csv file (data extracted from emails) and a Master Excel sheet. Master Excel fields are updated from the .csv - if the primary keys match, else the new records are added. Also, the .csv contains colour...