Search results

  1. P

    Query by Employee Evaluation Date Range

    Fatastic - thanks for your help plog!
  2. P

    Query by Employee Evaluation Date Range

    I have one table with all my employee information, including the start and end dates of their evaluation years (based on an employee's hire date). I have a second table that has all the accounts the employee has resolved, including the date of resolution. This table lists the employee ID of...
  3. P

    Moving Outlook Emails from MS Access

    I have stepped through it, and it seems as though no matter what I set the folder to, it will not work. In the GetFolder function, objFolder always equals nothing - no matter what I try and set the folder value to... primary email account, secondary, main Inbox without a sub-folder, a...
  4. P

    Moving Outlook Emails from MS Access

    Thank you, once again! I have tried what you said, but clearly I do not correctly understand how to use it. I now have: Dim myOlApp As New Outlook.Application Dim myNameSpace As Outlook.NameSpace Dim myInbox As Outlook.MAPIFolder Dim myDestFolder As Outlook.MAPIFolder Dim...
  5. P

    Moving Outlook Emails from MS Access

    I have this code so far. It works fine to move mail items from the inbox to a folder that is subordinate to the inbox... but I want it to move from a folder that is NOT the inbox, to another folder that is NOT subordinate. How can I go about changing the code to do that? I have tried changing...
  6. P

    Moving Outlook Emails from MS Access

    Okay, what if I try a different tactic? What if I look for the email by its subject, and then move that specific email between folders? I am using Office 2003.
  7. P

    Moving Outlook Emails from MS Access

    Okay, I should be more specific. The emails are orders. Currently Access imports the email information, parses the body of the email, and places the information in the appropriate field of an Access form. After the information is reviewed, a button is clicked to process the information -...
  8. P

    Moving Outlook Emails from MS Access

    darbid, thank you very much. The code works great. The origin and destination folders are both in my secondary email account (though it is on the same exchange server as my primary). The only thing now, is how may I move the emails one at a time as they get processed? I can see the section...
  9. P

    Moving Outlook Emails from MS Access

    I would like to be able to automate the process of moving a specific email from one sub-folder to another sub-folder in Outlook, via an Access database that I am using. I am using an Exchange account, and the emails are within folders that are located on a secondary inbox in that Exchange...
  10. P

    Automate importing Exchange data to new table

    Thanks James, your advice got me on the right track. I ended up with using a linked table. I then automated the process of creating a new table with an autonumber, and appending the Body field to the autonumber - it works great! Thanks again!
  11. P

    Automate importing Exchange data to new table

    Sadly, no. The data is coming in from individuals off-site who only have access to the web page on which the form is located. As it is, they have been manually emailing it in and then we have been manually putting it into the database, but the objective here is to save time, and make a more...
  12. P

    Automate importing Exchange data to new table

    I have setup a system that allows users to fill out an online form, with the results being submitted via email to Outlook. I then use the Access "Get External Data" to "Import" the form emails to a new table using the default format, but with an added Primary Key. The result is that I can...
Back
Top Bottom