A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Create new Contacts folder and populate it from Access



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old November 29th 09, 03:35 PM posted to microsoft.public.outlook.program_vba
Dmitry Streblechenko
external usenet poster
 
Posts: 2,116
Default Create new Contacts folder and populate it from Access

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 03:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.