Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>What view are you setting up in advanced find ? As you can write a VBA macros to pull items from your inbox and put them into you speadsheet. Alot of the advance find option are not in the outlook object model so it depends on the view you are trying to set up. So can you tell me what you are doing in advanced find ..? 76mel</p> <p>Ok using outlook tables you can put this in your Excel as a macro <br/> Use "sfilter" to define your advance search criteria. <br/> You will have to pump the data into Excel at the bottom.</p> <pre><code>Sub GetMail() Dim oApp As Outlook.Application Dim oFolder As Outlook.Folder Dim oNameSpace As Outlook.Namespace Dim emailCount As Integer Dim counter As Integer Dim sfilter As String Dim oRow As Outlook.Row Dim oTable As Outlook.Table Dim i As Outlook.MailItem Set oApp = CreateObject("Outlook.Application") Set oNameSpace = oApp.Session Set oFolder = oNameSpace.GetDefaultFolder(olFolderInbox) 'Add what ever filter you want here using DASL sfilter = "[LastModificationTime] &gt; '5/1/2005'" 'Restrict with Filter Set oTable = oFolder.GetTable(sfilter) 'Remove all columns in the default column set oTable.Columns.RemoveAll 'Specify desired properties With oTable.Columns .Add ("EntryID") .Add ("Subject") .Add ("ReceivedTime") End With 'Enumerate the table using test for EndOfTable 'Pump it into your worksheet Do Until (oTable.EndOfTable) Set oRow = oTable.GetNextRow() Debug.Print (oRow("EntryID")) Debug.Print (oRow("Subject")) Debug.Print (oRow("ReceivedTime")) Loop 'Clean up Set oTable = Nothing Set oFolder = Nothing Set oNameSpace = Nothing Set oApp = Nothing </code></pre> <p>End Sub</p>
    singulars
    1. This table or related slice is empty.
    1. POTracking e-mails in outlook with excel
      singulars
      1. PTQuestion
    1. PTAnswer
    1. US76mel
    1. US76mel
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POTracking e-mails in outlook with excel
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI was using advanced find to search the inbox by date; I don't want to alter any of the e-mails in the inbox, but just to make a copy of the subject line and date received of each e-mail in an excel sheet. Basically what I'm trying to do is distinguish between replies to already existing issues and 'fresh' problems we need to address, the purpose of which is to produce a list of outstanding issues so that we can easily spot long unresolved problems brought to us. We've had some problems with e-mails sitting unanswered and forgotten about.
      singulars
      1. PO
      1. USNiall
    2. COOk, that do-able .. There are a number of ways. 1.Write an addin in outlook to export > Excel 2.Write a Marco and VBA in Excel that queries the mailbox and insert the data
      singulars
      1. PO
      1. US76mel
    3. COHave added some code for the Excel Macro way above.
      singulars
      1. PO
      1. US76mel
 

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