Add items from Access db to existing distribution list?

  • Thread starter Thread starter James Houston
  • Start date Start date
J

James Houston

Is it possible to add emai addresses from an Access DB to an existing
Outlook distribution list? Or create a new distribution list and add the
addresses from Outlook to it? Anyone have any code samples on how this
might work? Thanks in advance.

Jim
 
This is a pretty broad question, Jim. All that you are asking for is
'possible'. Do you have a specific question?

Creating distribution lists are fairly straightforward. Here's a basic
example from the Outlook VBA reference:

Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olDistributionListItem)
myItem.Display

Take a look at the properties and methods available to the DistListItem
object; you should be able to do all you need with them.
 
Back
Top