• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

Import Outlook Email but not duplicate

I am creating a process to import Outlook email data into an ACCESS 2003 database.  The user does not want the source folder in Outlook to be cleared after import.  So, each day when new emails are imported, is there an OutlookID that is generated by Outlook to uniquely identify each email?  The user could import several times a day so I cannot use Date, subject, To or from to differentiate.

Sandra
0
ssmith94015
Asked:
ssmith94015
1 Solution
 
Chris BottomleyCommented:
Each saved item has an Id ... Each item has this as The entryid, a string param so that a mail may be IDEntified as application.activeexplorer.selection(1).entryid.

This would return for example the 48 character entryid as

1234567890ABCDEF1234567890ABCDEF1234567890ABCDEF

Similarly application.session.getitemfromid("1234567890ABCDEF1234567890ABCDE1234567890ABCDEFF") returns the original item.

Chris
0
 
ssmith94015Author Commented:
Yes, I found the ID thank you!

Sandra
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now