Hello Sue,
Great stuff. I do have a question though: I would like a user to be prompted to select a mail item, which would then be attached to a message generated through code (the host app is ACCESS 2003). I know how to get a users input for attaching a file from a network for example, but don't know how to interrupt the code with an outlook explorer window which would allow the user to select a mail item, after which the code would resume its course. I don't need an extensive explanation (for which I'm sure you don't have the time), but would really appreciate if you could put me on the right track.

Many thanks in advance,
Stefan.

Anonymous User 3/3/2005 8:06:16 AM

Sue your articles are great - you really know your stuff. I've got one question I can't seem to find the answer to anywhere: how to I get at the Notes field (the one on the standard contact form) ContactItem in VBA?
Thanks
Justin


Anonymous User 1/31/2005 5:34:32 PM

Sue, you write excellent articles and very clever code and are obviously brilliant. But reading it makes my blood boil; that Microsoft has unleashed the twin evils of Outlook and VBA on an unsuspecting world. Just stand back and ask oneself whether any of this really makes sense or is even logical. What a waste of everyone's efforts!

Robert5/26/2004 3:37:02 PM

Chris, if you're not running the code in Outlook VBA (i.e. the focus of this series of articles), you'd need to use the literal values for those constants or add a library reference, depending on the coding environment.

Sue Mosher 3/3/2004 7:49:27 AM

Tom, yes, that works, because Item is an intrinsic object when you're writing code behind an Outlook form (as is Application).

Sue Mosher 3/3/2004 7:48:29 AM

Great introduction and jump start to understanding the basics of Explorer v. Inspector application programming. Helped bring to light the understanding I was needing!

David K. Baker 1/19/2004 10:34:11 PM

It seems to work to reference "Item" as the currect email item when writing code in the "Message" form. Example:

MsgBox "Sending to: " + Item.To

Is this an acceptable technique?

Thanks

Tom Sage 1/9/2004 9:11:21 AM

Listing 1 contains several undefined constants for the value of ActiveWindow.Class

Chris Kinsman 1/8/2004 9:23:24 AM

Dave, it is not possible to obtain any information from Outlook as to what day the user may have selected in the calendar.

Sue Mosher 8/27/2003 12:24:23 PM

Does anyone have an idea, how to work out what the currently selected calendar is ?

So that I can hit a macro button an assign a repatitve appoinjtment to the currently SELECTED day.

Which is not the current actual day.

Thanks

Dave Crawford 10/16/2002 10:33:32 AM