Databases
StackOverflow2013
Postsdbo
POAccessing Outlook ost file
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAccessing Outlook ost file
    primarykey
    data
    text
    <p>I have seen the difference between pst and ost files and currently working on accessing the outlook pst file through the following code given below. Is there any way to use the same code for accessing ost file? Can someone refer me to this?</p> <pre><code>private DataTable GetInboxItems() { DataTable inboxTable; //try //{ filter = "[ReceivedTime] &gt;= '" + dtpStartDate.Value.ToString("dd/MM/yyyy 12:00 AM") + "' and [ReceivedTime] &lt;= '" + dtpEndDate.Value.ToString("dd/MM/yyyy 11:59 PM") + "'"; Outlook.Application outlookApp = GetApplicationObject(); Outlook.Folder root = outlookApp.Session.DefaultStore.GetRootFolder() as Outlook.Folder; EnumerateFolders(root); //string filter = "[ReceivedTime] &gt; '" + dtpStartDate.Value.ToString("dd/MM/yyyy") + "'"; //inbox Outlook.MAPIFolder inboxFolder = outlookApp.Session.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox); inboxTable = CreateTable(); int count = 0; if (inboxFolder.Items.Count &gt; 0) { var restrictedItems = inboxFolder.Items.Restrict(filter); restrictedItems.Sort("[ReceivedTime]", true); //descending //foreach (var item in inboxFolder.Items) foreach (var item in restrictedItems) { var mail = item as Outlook.MailItem; if (mail != null) { //try //{ DataRow row = inboxTable.NewRow(); //row["sn"] = (++count).ToString(); row["sn"] = mail.EntryID + " " + mail.ReceivedByEntryID; row["MailType"] = "Inbox"; row["SenderName"] = mail.SenderName; row["SenderEmail"] = mail.SenderEmailAddress; row["ReceivedDate"] = mail.ReceivedTime; row["Subject"] = mail.Subject; row["Body"] = mail.Body != null ? (mail.Body.Length &gt; 25 ? mail.Body.Substring(0, 25) : mail.Body) : null; //row["Body"] = mail.Body != null ? mail.Body : ""; row["MailSize"] = mail.Size.ToString(); string attachments = null; if (mail.Attachments.Count &gt; 0) { foreach (var attachment in mail.Attachments) { if (((Outlook.Attachment)attachment) != null) //attachments = ((Outlook.Attachment)attachment).FileName + " " + ((Outlook.Attachment)attachment).Size.ToString() + ", "; attachments += (((Outlook.Attachment)attachment).Size / 1024).ToString() + " KB, "; } } row["AttachmentCount"] = mail.Attachments.Count; if (attachments != null) row["AttachmentSize"] = attachments.Substring(0, attachments.Length - 2); inboxTable.Rows.Add(row); } //catch (Exception ex) //{ // return null; //} } } return inboxTable; } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPeter Ritchie
    1. USnewbie
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThis code works with Store object, it doesn't care if the store is PST, OST or online exchange without offline file. Did you have problems with this code? Maybe it requires credentials...
      singulars
      1. POAccessing Outlook ost file
      1. USArthur
    2. COThanks Arthur...How can i access OST file? could you please demonstrate with a code example at what point credentials are required? And what benefit does this OST file provides over PST file?
      singulars
      1. POAccessing Outlook ost file
      1. USnewbie
    3. COOST is created when using cached mode in Exchange account type, you can't control it. PST is used to store mail data without server account or using other type of accounts like IMAP. The code you have in your question will read OST file if the default store is of Exchange account. Did you tried it? Did you had problems?
      singulars
      1. POAccessing Outlook ost file
      1. USArthur
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload