![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
set ContactsFolder =
OutlookApplication.Session.GetDefaultFolder(olFold erContacts) set NewContactsFolder = ContactsFolder.Folders.Add("Contacts Subfolder") set Contact = NewContactsFolder.Items.Add("IPM.Contact") Contact.Email2Address = " Contact.FirstName = "Margaret" Contact.LastName = "Bartley" Contact.Save -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Margaret Bartley" wrote in message ... I use Access to manage my membership data. I'd like to generate an new Access mailing list everytime I send out a newsletter, using a vba module. That module will create a MailingList table. I'd like add some code to that module to open Outlook, create a new Contacts folder, and populate that new folder with the address in my new MailingList table. Can anyone please point me to some vba automation code that will give me the syntax to create a new Contacts folder and then populate it with an Access table? I already have some code to instantiate Outlook, so that's not necessary, but certainly won't hurt, either. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro: Create New Message and Auto populate To Field | geosptial | Outlook and VBA | 5 | August 14th 09 02:04 PM |
Populate Message area with text from access database | LenJr | Outlook - Using Forms | 1 | August 4th 08 02:09 PM |
using access query to populate outlook distribution list | Iona | Outlook - General Queries | 0 | July 11th 06 06:39 AM |
Can custom form data populate access database | jbtempe | Outlook - Using Forms | 1 | January 20th 06 03:02 PM |