none
importing selected MS Outlook messages into ACCDB(using Visual Studio 2015, WPF and C# RRS feed

  • Question

  • In the past, I have successfully imported an entire folder from MS Outlook into an ACCDB.

    Is there a capability within MS Access 2010 to import selected messages into an ACCDB instead, to correlate them with corresponding records within the ACCDB via foreign keys.

    The user interface would use Visual Studio 2015 and WPF(with C#), as well.



    • Edited by irsharp Friday, November 13, 2015 10:15 PM
    Friday, November 13, 2015 7:46 PM

Answers

  • Hi irsharp,

    >> Is there a capability within MS Access 2010 to import selected messages into an ACCDB instead, to correlate them with corresponding records within the ACCDB via foreign keys.

    No, there is no direct way to achieve your requirement. Access 2010 only support import outlook folders, and it could not only import the selected message.

    For a workaround, I suggest you create a new folder which is used to import into Access, and when you want to import the selected message, copy or move the selected message into the new folder. Then import the messages into Access.

    # 1 get selected message
    # How To Get the Currently Selected Item in an Outlook Folder from Visual Basic
    https://support.microsoft.com/en-us/kb/240935

    # 2 move message
    # MailItem.Move Method (Outlook)
    https://msdn.microsoft.com/en-us/library/office/ff860683.aspx

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Monday, November 16, 2015 2:57 AM
  • There is an indirect way to do what you want:

    Link to the Outlook Mailbox:

    External Data ribbon
    Import & Link Group: More
    Outlook folder

    Then use Received (Date/Time) field to decide messages you want to append to another table.  This could be automated somewhat, but you'd need to copy and paste the date/times you want.

    The reason I suggest linking is (1) to keep things current, and (2) so you don't bloat your database, but obviously if you import and then append, you could add a flag field to mark the messages you want.  Then after you delete the big outlook mailbox table, Compact and Repair :)

    As Edward suggested, you could move the messages you want to their own Outlook folder, which would make things easier when you want to put them into Access.  Once they are there, you'd want to shuffle them out of the Wanted folder so you don't get them again.



    Warm Regards, Crystal http://www.AccessMVP.com/strive4peace * (: have an awesome day :)


    Monday, November 16, 2015 6:55 AM

All replies

  • Hi irsharp,

    >> Is there a capability within MS Access 2010 to import selected messages into an ACCDB instead, to correlate them with corresponding records within the ACCDB via foreign keys.

    No, there is no direct way to achieve your requirement. Access 2010 only support import outlook folders, and it could not only import the selected message.

    For a workaround, I suggest you create a new folder which is used to import into Access, and when you want to import the selected message, copy or move the selected message into the new folder. Then import the messages into Access.

    # 1 get selected message
    # How To Get the Currently Selected Item in an Outlook Folder from Visual Basic
    https://support.microsoft.com/en-us/kb/240935

    # 2 move message
    # MailItem.Move Method (Outlook)
    https://msdn.microsoft.com/en-us/library/office/ff860683.aspx

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Monday, November 16, 2015 2:57 AM
  • There is an indirect way to do what you want:

    Link to the Outlook Mailbox:

    External Data ribbon
    Import & Link Group: More
    Outlook folder

    Then use Received (Date/Time) field to decide messages you want to append to another table.  This could be automated somewhat, but you'd need to copy and paste the date/times you want.

    The reason I suggest linking is (1) to keep things current, and (2) so you don't bloat your database, but obviously if you import and then append, you could add a flag field to mark the messages you want.  Then after you delete the big outlook mailbox table, Compact and Repair :)

    As Edward suggested, you could move the messages you want to their own Outlook folder, which would make things easier when you want to put them into Access.  Once they are there, you'd want to shuffle them out of the Wanted folder so you don't get them again.



    Warm Regards, Crystal http://www.AccessMVP.com/strive4peace * (: have an awesome day :)


    Monday, November 16, 2015 6:55 AM