VBA Coding in Outlook

[Guest]

Access 2002. I am familiar with coding VBA in Access and a little in Excel.
I am not familiar with coding for Outlook.

1. Does anyone have an example of code that would retrieve items from a
distribution list? I need to retrieve the current entries in a distribution
list and examine some of the fields in the entry (like email address and
company). Ultimately, I want to be able to do this not only in Outlook, but
also from the other applications like Word, Access, and Excel.

2. I noticed a subject called "forms" in this newsgroup. What are Outlook
forms, and how would I create one?

Thanks for the help.

 

[Hollis D. Paul]

2. I noticed a subject called "forms" in this newsgroup. What are Outlook
forms, and how would I create one?

The primary resource for non-Microsoft Outlook information is
www.slipstick.com and it's companion site of www.Outlook-tips.net.
Right-behind these is www.outlookcode.com. You will find a lot of information
there. The first think you want to do is go to the library and find a good
beginning book title. Then buy and read it. Oddly enough, it will tell you
about Outlook forms. It is a creature of many virtues, and becomes the
development platform for Outlook programming in VBScript. You want to learn
about that before you worry about using the VBA facility of Outlook.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2600
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA

 

[Hollis D. Paul]

1. Does anyone have an example of code

Look for code examples on www.slipstick.com and www.outlookcode.com.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Mukilteo, WA USA