Object Library documentation

[dirtybarry]

Does anyone know where to find Object Library documentation?

Looking especially for documentation on the Outlook 14.0 object library that I'm using with MS-Access 2010.

Tring to determine what delimiter (if any) can be used to seperate multiple to-addresses for an Access /VBA email process.

Thanks

 

[genomon]

Object Browser in the VBA IDE is a good place to start; add a reference to the library first. It will at least expose the properties and methods that could be used as serach criteria on the web.

Gluais faicilleach le cupan làn

 

[dirtybarry]

Thanks genomon, guess I'd forgotten about the Object Browser. Not a manaual, but better than nothing.

 

[genomon]

Gotta love Microsoft

Gluais faicilleach le cupan làn

 

[dhookom]

dirtybarry,
Did you search Bing for "outlook 2010 object model"? This page What's New for Developers in Outlook 2010 came up and seems to have a lot of good information. Other links on this page are:
Getting Started with VBA in Outlook 2010
Programming the Outlook 2010 Solutions Module

I also found Outlook Object Model Reference

I'm not sure any other software provides this type of transparency to their technical details. Gotta love Microsoft .


Duane
Hook'D on Access
MS Access MVP

 

[dirtybarry]

Thanks dhookom, I'll check it out.

 

[dirtybarry]

Well dhookom, I checked it out, and I did find some useful links, however I would still prefer to have all of the information in a document with a table of contents and an index.

I'm old fashioned I guess. Anyway thanks again for your informative reply.

 

[genomon]

what delimiter (if any) can be used to seperate multiple to-addresses for an Access /VBA email process

The answer is none; you use the .RecipientAdd method of the Outlook object.
Sorry I missed that in my rush to get a reply out! Here is a code snippet I use:

If intComma > 0 Then  'array loop
    arrEmail = Split(strRecipientAdd, ",")
        For intIndex = 0 To UBound(arrEmail())
            .RecipientAdd strRecipient, Trim(arrEmail(intIndex)), , , False


etc...

If there is more than one address separated by a comma in the original "To:" string, I load it into an array and loop using
.RecipientAdd.
Above, intComma is a count of commas in strRecipientAdd


Gluais faicilleach le cupan làn

 

[dirtybarry]

Thanks again genomon.

I made the delimiter work by using the following:

.To = My.[ToAddress]

Where My.[ToAddress] refers to a form field that captures an address or addresses, each delimited with a semi-colon.

Works great.

Thanks again. I like this forum.

Go ahead, make my day!

 

[genomon]

I like your solution!

Gluais faicilleach le cupan làn