Create new Contacts folder and populate it from Access

Status
Not open for further replies.
M

Margaret Bartley

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.
 
set ContactsFolder =

OutlookApplication.Session.GetDefaultFolder(olFolderContacts)

set NewContactsFolder = ContactsFolder.Folders.Add("Contacts Subfolder")

set Contact = NewContactsFolder.Items.Add("IPM.Contact")

Contact.Email2Address = "may04_NOTTHIS@mindspring.com"

Contact.FirstName = "Margaret"

Contact.LastName = "Bartley"

Contact.Save

Dmitry Streblechenko (MVP)

-

"Margaret Bartley" <may04_NOTTHIS@mindspring.com> wrote in message

news:ex$$vtobKHA.2188@TK2MSFTNGP04.phx.gbl...
> 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.

>
 
Status
Not open for further replies.
< If i have a entry id, how could i get its IABContainer? | Retrieving CalendarView for Outlook 2003 >
Similar threads
Thread starter Title Forum Replies Date
M How to Create Macro in Visual Basic to add Contacts from Personal Folder Using Outlook 4
D Can Exchange Admin Center create a pst for users email/contacts/calendar? Exchange Server Administration 0
F How to create phone number as links in notes of Contacts Using Outlook 2
C Create new Message with shared contacts & BCC'ing recipients Outlook VBA and Custom Forms 0
F Should a new email account also create new contacts Using Outlook 2
M regarding the Create Contacts From Messages code Using Outlook 8
Diane Poremsky Automatically Create Contacts From Messages Using Outlook 1
S How can I create a rule to move inbound emails from any of my contacts out of Inbox? Using Outlook 1
T Unable to create contacts subfolder in EAS profile Using Outlook.com accounts in Outlook 6
E How to create contacts group list with IMAP/iCloud? Using Outlook 2
M Create Contacts?? Using Outlook 1
R Create a contacts list on Exchange 2010 Exchange Server Administration 10
S [outlook-users] Create contact group from other user's contacts Using Outlook 1
G Possible to create reports that return contacts based on account criteria? BCM (Business Contact Manager) 0
D I want to create subcategories under business contacts? BCM (Business Contact Manager) 1
P How do I create a macro to add contacts from email messages? Outlook VBA and Custom Forms 1
V How to create add-in to delete duplicated contacts Outlook VBA and Custom Forms 1
S Create Outlook Task from Template and append Body with Email Body Outlook VBA and Custom Forms 4
B Modify VBA to create a RULE to block multiple messages Outlook VBA and Custom Forms 0
J Want to create a button on the nav bar (module add-in) to run code Outlook VBA and Custom Forms 2
B How to create a button that sorts and selects the most recent message with ONE click Using Outlook 2
J PSA: How to create custom keyboard shortcut for "Paste Unformatted Text" in Outlook on Windows Outlook VBA and Custom Forms 1
W Create a Quick Step or VBA to SAVE AS PDF in G:|Data|Client File Outlook VBA and Custom Forms 1
Wotme create email only data file Using Outlook 1
S Outlook 365 Help me create a Macro to make some received emails into tasks? Outlook VBA and Custom Forms 1
J How to create a drop down user defined field that will appear on an inbox view Outlook VBA and Custom Forms 8
Commodore Any way to create "from-only" account on Outlook 2021? Using Outlook 1
L Capture email addresses and create a comma separated list Outlook VBA and Custom Forms 5
N Can't create NEW GROUP and add/remove a member from existing Group in Outlook Using Outlook 1
NVDon Create new Move To Folder list Outlook VBA and Custom Forms 0
C Create Meeting With Custom Form Outlook VBA and Custom Forms 2
D Create advanced search (email) via VBA with LONG QUERY (>1024 char) Outlook VBA and Custom Forms 2
G Create ordinal numbers for birthday Outlook VBA and Custom Forms 2
O Outlook 365 - How to create / copy a new contact from an existing one? Using Outlook 5
D Create new email from the received Email Body with attachment Outlook VBA and Custom Forms 10
A How to create fixed signatures for aliases that process through GMAIL? Outlook VBA and Custom Forms 0
P Can I create a Rule that sends me an email when I get a Task? Using Outlook 2
M How create a Rule to filter sender's email with more that one @ sign Using Outlook 1
B Can I create a local PST file for SPAM on a drive that is usually disconnected? Using Outlook 3
Chiba Create an appointment for all the members Outlook VBA and Custom Forms 1
S Create a clickable custom column field Outlook VBA and Custom Forms 0
O Create a custom contact form - questions before messing things up... Outlook VBA and Custom Forms 4
L automaticaly create a teams meeting with a sync Using Outlook 0
S Create A Search Folder That Looks For Message Class? Outlook VBA and Custom Forms 0
Nessa Can't create new appointment Using Outlook 1
A Create date folder and move messages daily Outlook VBA and Custom Forms 1
O Multiple email accounts - hesitate to create a new profile Using Outlook 3
G Can't create Folder Groups in Outlook 2013 Using Outlook 0
N Outlook rules don't create a copy for bcc'ed emails Using Outlook 3
F Delete/create/reset Exchange mailbox on Outlook.com Using Outlook.com accounts in Outlook 3

Similar threads

Back
Top