>2. How do you repetitively send emails to individual addresses stored in the database- just do
> multiple .Add(Recipient) statements.... or is the CreateItem( ) method also needed?
To send to multiple recipients, use the Add method of the Recipients collection for each one. Be sure to also use the Resolve method of Recipient to make sure that Outlook can turn the address you pass it into one that it can deal with.
>3. Rather than have to manually key in email addresses into my contact database, it would be nice to
> programatically access Outlook's Address Book and use the addresses retreived from Outlook
> to prime my contact database record... can I easily do this?
Yes, if you pass anything recognizable and unique to Recipients.Add, Outlook will handle it.
In addition, you can write code that reads the Outlook address book. The new book that Della Martin and I have coming out this month (Microsoft Office Automation with Visual FoxPro) includes an example that reads the Contacts folder from Outlook and creates a VFP cursor. You can check the book out at
www.hentzenwerke.com. (PUTM members also get a discount. Go through the link on the main UT page.)
>4. Can anyone give me a URL that gives a clear explanation of the properties and methods I might need
> to use in this application?
>
Use the Outlook VBA Help file (VBAOutl9.CHM). It's probably already installed on your machine.
Tamar