Search results

  1. A

    Access + Outlook: move emails interrupts vba code

    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...
  2. A

    outlookMessage.ReceivedTime changing?

    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.
  3. A

    folderOutlook.Items.Restrict() Multiple restictions

    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...
  4. A

    VBA variable in SQL?

    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
  5. A

    Update Master Table Baesd on Slave Table

    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...
Back
Top Bottom