Outlook - How to create the customized Outlook SQL DASL for selected days?
Asked By Bill Lin
12-Feb-10 10:55 AM
Outlook 2007/2010 provided pre-defined view for tasks due by the selected
days. It seems the SQL DASL Filter dialog has the ability to do it, but I
do not know what is the property tag for selected days
I am using the filter below to get tasks due on today.
%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%
When I changed the selected days on the calendar taskpad view, it will not get
the tasks due on the date I selected. Can't find any documents to use SQL
DASL filters except for Andre Delin's weblog: Doing more with Outlook filter
and SQL DASL syntax
Can you please help? Thanks
Bill
Outlook 2007
(1)
Outlook
(1)
PropertyAccessor
(1)
OutlookSpy
(1)
DueDate
(1)
Reminders
(1)
Andre
(1)
Butdoes
(1)
Ken Slovak - [MVP - Outlook] replied to Bill Lin
The help on PropertyAccessor has a lot more about using DASL filters, but
does not cover everything. Usually to construct a DASL filter many of us go
to the customize dialog for views and in the filter section we create the
filter in the Advanced tab and then look at the SQL tab to get the
equivalent DASL terms.
The filter you refer to in your message is looking at the task DueDate
property for dates of today.
The SQL tab will show the DASL MAPI property tag for a property added in the
Advanced tab.
I also use a MAPI viewer to get DASL tags for any property, I use OutlookSpy
as my MAPI viewer (www.dimastr.com).
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
Bill Lin replied to Ken Slovak - [MVP - Outlook]
Thank you, Ken. Your information is helpful
Bill
Saving attachments to folder from public folder Outlook Hey there! I am currently working on a project that involves merging data from many into one Excel workbook for analysis. The csv files are sent to a public folder (outlook: \ Public Folders \ All Public Folders \ etc. . .) I thought the easiest way to do this would be to import the data straight from Outlook to the Excel file but after much painful testing I could not get it to main mailbox folders, not public and am unsure why. . . I have almost no experience with Outlook coding so any help is appreciated! This is the current code: If there is a instead of using a selection, that is fine too! Public Sub SaveAttachments() Dim objOL As Outlook.Application Dim objMsg As Outlook.MailItem 'Object Dim objAttachments As Outlook.Attachments Dim objSelection As Outlook.Selection Dim i As Long Dim lngCount As Long Dim strFile As String Dim strFolderpath
Handling application.quit event Outlook Hello, i am developing an exe application and i use global object to declare outlook application withevents. I use outlook 2007 sp2 and i am having trouble releasing my variable references or reusing then. I use this code : Public Class StartOE Private WithEvents o As Outlook.Application = Nothing Private ns As Outlook.NameSpace = Nothing Private omFolder As Outlook.MAPIFolder = Nothing Public Sub New() If detectOutlook() Then o = GetObject(, "Outlook.Application") Else o = New Outlook.Application End If Try ns = o.GetNamespace("MAPI") ' get namespace
Create a macro in Outlook to run a rule Outlook I created a rule in Outlook 2007 for e-mails that have certain words in the subject line, to be deleted. I that and not have to click on tools, rules, etc. How do I do that? Outlook Program VBA Discussions Application.GetNameSpace (1) Outlook 2007 (1) Outlook (1) Outlook.NameSpace (1) VBA (1) VB (1) RunRuleDeleteSpam2 (1) RunRuleDeleteSpam (1) Sub RunRuleMyRule() Application
Problem seeing some characters when sending email to Outlook client Outlook Using VB6, I am sending an HTML email using SMTP. I am having a problem like a bullet point that looks like an arrow) thru email that is received in Outlook. The weird thing is some Outlook client can see the arrow fine, some can not. My Outlook 2003 used to be able to see the arrow ok, but now it does not Some Outlook 2007 can see it ok, some cannot. I can see the arrow fine in Gmail. This a problem with: = E2 = 96 = BA That arrow character becomes this in some of the Outlook client: – Thank you for your help. This is my code: Set poSendMail = 3D New clsSendMail
Looking for good email program? Outlook Hi forum members, This is the first time I have posted at this forum, and to an excellent internet / web based email. With Microsoft, it appears I have two choices, Outlook, or Outlook Express. Up front I am stating, not interested in all the bells and whistles that that exists, whether it is free, or, I have to pay for it. So, between Outlook and Outlook Express, what are the pros and cons about one versus the other? Please do not about the stuff I have stated I am not interested in. Simply want to compare Outlook vs Outlook Express's email program and how either will serve me best. My needs: 1 - I do not waste anybody's time with stuff that is not relevant to my question. Outlook or Outlook Express? For EMAIL PURPOSES. One or the other, Why vs Why Not? After