A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Showing results 1 to 15 of 15
Search took 0.01 seconds.
Search: Posts made by: deko
Forum: Outlook and VBA June 6th 08, 04:28 PM Posted to microsoft.public.outlook.program_vba
Replies: 9
Views: 1,767
Posted By deko
Outlook Automation: is there a better way?

This works nicely, too:

Dim olapp As Outlook.Application
Dim olfldr As Outlook.Folder
Dim exp As Outlook.Explorer
Dim strSearch As String

Set olapp = New Outlook.Application
...
Forum: Outlook and VBA June 6th 08, 01:33 PM Posted to microsoft.public.outlook.program_vba
Replies: 9
Views: 1,767
Posted By deko
Outlook Automation: is there a better way?

the missing link...

http://msdn.microsoft.com/en-us/library/aa123730(EXCHG.65).aspx

urn:schemas:mailheader:approved
urn:schemas:httpmail:attachmentfilename
urn:schemas:mailheader:bcc...
Forum: Outlook and VBA June 6th 08, 12:25 PM Posted to microsoft.public.outlook.program_vba
Replies: 9
Views: 1,767
Posted By deko
Outlook Automation: is there a better way?

Beta 2

does not error out, but the filter does not seem to work
note: messages exist in the Inbox that wd match filter criteria

? FindMessages()
562 unfiltered
@SQL="urn:schemas:httpmail:Subject"...
Forum: Outlook and VBA June 6th 08, 10:48 AM Posted to microsoft.public.outlook.program_vba
Replies: 9
Views: 1,767
Posted By deko
Outlook Automation: is there a better way?

To answer my own question:

Those links are schema property names used in the SQL-like DASL syntax,
which begins with @SQL=

See: http://blogs.msdn.com/rgregg/archive/2005/12/12/502904.aspx

If you...
Forum: Outlook and VBA June 6th 08, 07:25 AM Posted to microsoft.public.outlook.program_vba
Replies: 9
Views: 1,767
Posted By deko
Outlook Automation: is there a better way?

Thanks for the heads up, Dmitry.

I'm wondering if there's a way to force the cache to clear itself. Also, I
assume on a local Outlook PST there are no cache issues.

From reading the MSDN article,...
Forum: Outlook and VBA June 5th 08, 11:33 PM Posted to microsoft.public.outlook.program_vba
Replies: 9
Views: 1,767
Posted By deko
Outlook Automation: is there a better way?

I just upgraded to Office 2007 and would like to refactor my automation code
to improve speed and perhaps add some new functionality.

My Access 2007 database has code that searches Outlook 2007 for...
Forum: Outlook and VBA December 31st 07, 10:46 PM Posted to microsoft.public.outlook.program_vba
Replies: 4
Views: 665
Posted By deko
How to bring Calendar window to top after open?

I have an Access 2003 app running on Vista that opens the Outlook Calendar
like this:

Set olapp = New Outlook.Application
Set olns = olapp.GetNamespace("MAPI")
...
Forum: Outlook and VBA September 22nd 07, 11:13 AM Posted to microsoft.public.outlook.program_vba
Replies: 1
Views: 2,224
Posted By deko
How to loop through items in an Exchange Mailbox?

I've written a good bit of VBA and have automated Outlook on my home PC, but I'm
now tasked with automating an Exchange Mailbox for a small company.

Users have two Exchange Mailboxes visible in...
Forum: Outlook and VBA January 23rd 06, 07:15 PM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 4,176
Posted By deko
How to find Appointment Item by EntryID?

It sounds like you want to change the Categories value for all the
occurrences in a series - is that right? In that case you need to make the
change to the recurrence master. I assume from...
Forum: Outlook and VBA January 23rd 06, 06:18 AM Posted to microsoft.public.outlook.program_vba
Replies: 3
Views: 1,860
Posted By deko
How to change Categories property of recurring apointment?

Use the AppointmentItem.RecurrenceState property to work only with the
master appointments (olApptMaster or olApptNotRecurring)

Much better! Thanks for the tip!

If olai.Categories ...
Forum: Outlook and VBA January 23rd 06, 05:27 AM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 4,176
Posted By deko
How to find Appointment Item by EntryID?

When looping through a collection of Outlook.Items that includes
recurrences, and a recurring appointment is found, I need to get the
non-recurring appointment in order to change the Categories...
Forum: Outlook and VBA January 22nd 06, 02:32 PM Posted to microsoft.public.outlook.program_vba
Replies: 3
Views: 1,860
Posted By deko
How to change Categories property of recurring apointment?

One complication is that I'm trying to do this inside a For Each loop - of
all appointments, including recurrences. I don't know of any way to get the
"parent" or "series" AppointmentItem when...
Forum: Outlook and VBA January 22nd 06, 03:17 AM Posted to microsoft.public.outlook.program_vba
Replies: 3
Views: 1,860
Posted By deko
How to change Categories property of recurring apointment?

When attempting to change the Categories property of a recurring
appointment, I get this error:

Error Number -1179631611: This property cannot be changed for a single
instance of a recurring...
Forum: Outlook and VBA January 17th 06, 09:08 AM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 1,349
Posted By deko
Appointment Label colors - what are they in the color palette?

This is a close approximation:

Red - Important - 9211131
Blue - Business - 14848376
Light green - Personal - 7722386
Light gray - Vacation - 13095635
Orange - Must Attend - 7058426
Light blue -...
Forum: Outlook and VBA January 17th 06, 07:50 AM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 1,349
Posted By deko
Appointment Label colors - what are they in the color palette?

In Access, I can set the BackColor of a text box using the color palette on
the properties sheet. For example, white is 16777215, and royal blue is
16711680.

Is it possible to replicate the...
Showing results 1 to 15 of 15

 
Forum Jump

All times are GMT +1. The time now is 09:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.