Re: Query CurrentUser from Outlook View

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

--
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


<fred@xxxxxxxxxxxxxxxxxxxx> wrote in message news:93eff726-669d-4228-bcb0-a384d87032b3@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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?

.

Relevant Pages

  • Re: open a form with userlevel criteria
    ... Dim strCriteria As String ... Dim repname As String ... The final problem I am having with this is how can i keep it so the filter ... >What I want to do is compare the CurrentUser() info to the Debt Advisor table ...
    (microsoft.public.access.formscoding)
  • open a form with userlevel criteria
    ... show info pertaining to the user that is currently logged in. ... What I want to do is compare the CurrentUser() info to the Debt Advisor table ... Then filter the current form "greybar" to only show data where the rep number ... I hope what I am writing is understandable... ...
    (microsoft.public.access.formscoding)
  • Filtering blocks 1 single record
    ... I have a form opened by the switchboard with openargs setting a filter on the records. ... I'm using 'CurrentUser' to identify the employee logged in to my front end. ...
    (microsoft.public.access.forms)
  • Filtering blocks 1 single record
    ... I have a form opened by the switchboard with openargs setting a filter on the records. ... I'm using 'CurrentUser' to identify the employee logged in to my front end. ...
    (microsoft.public.access.formscoding)
  • Re: store and retrieve a value in ms outlook which is not visible
    ... John ... > CurrentUser, or any of the scripting methods of getting a user network name. ... CurrentUser is restricted in secure versions of Outlook unless you use ... > Reminder Manager, Extended Reminders, Attachment Options ...
    (microsoft.public.outlook.program_vba)