 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Programming VBA / March 2008Query CurrentUser from Outlook View
Is there a way to Query the CurrentUser from an Outlook View using SQL ? Query what? What are you trying to do? You can use SQL syntax (actually WebDAV) for advanced find searches and for creating search folders.  SignatureKen Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm > Is there a way to Query the CurrentUser from an Outlook View using > SQL ? Trying to Setup a View that displays only items that are assigned to the CurrentUser. Using the Contacts field populated with the full name of the user (from the GAL). This results in the contacts field displaying the first and last name on any item assigned to them. We need a view to filter only items assigned to this user. I have tried using SQL in the view to select CurrentUser with no success. Is there another syntax that will allow this in the query? On Mar 26, 12:28 pm, "Ken Slovak - [MVP - Outlook]" <kenslo...@mvps.org> wrote: > Query what? What are you trying to do? > [quoted text clipped - 15 lines] > > - Show quoted text - I believe you'd have to hard-code the CurrentUser name for the DASL for the filter if you are using the Customize View or Define View dialogs unless you are using Outlook 2007. In Outlook 2007 you can use the new View object model additions (View.Filter). Then you could get CurrentUser as a string value in code before you constructed the view filter using that value. SignatureKen Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm Trying to Setup a View that displays only items that are assigned to the CurrentUser. Using the Contacts field populated with the full name of the user (from the GAL). This results in the contacts field displaying the first and last name on any item assigned to them. We need a view to filter only items assigned to this user. I have tried using SQL in the view to select CurrentUser with no success. Is there another syntax that will allow this in the query?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.