Maintain Outlook Distribution List from Access

Status
Not open for further replies.
S

SoCal Rick

Hi,

I have Outlook distribution lists of up to 1,000 members. The membership

changes (to some degree) each month. I have a MS Access database which

compares the list of people who were on the list last month to the list of

people who should be in the distribution list this month. It identifies

people to remove from the distribution list and people to add to the

distribution list. Is there a good way to use MS Access VBA to automatically

make these changes to the distribution lists?

For example, last month Tony (and 145 other people) were part of the

1stComplaintHandler Email list, but have moved to other responsibilities, so

shouldn't recevie any more email for that group. At the same time, Joan (and

43 other people) have joined the group that handles 1st Complaints, so they

should be added to the email group "1stComplaintHandler".

Any help is greatly appreciated (suggestions or even articles to read...)

Thank you

SoCal Rick
 
S

Sue Mosher [MVP]

Maintaining DLs is a nightmare in the making. I don't recommend using them

at all, except for small, relatively static ones.

You could, in theory, write Access VBA code using the Outlook object model

to work with the properties and methods of the DistListItem object and do

updates. (Whether you'll be interrupted by security prompts depends on your

Outlook version, which you should always mention when posting to an Outlook

forum.) However, better solutions for mass mailings exist, including Word

mail merge directly from your database.

Sue Mosher

"SoCal Rick" <SoCalRick> wrote in message

news:88644659-B6DC-474B-A747-C2CB94F24D41@microsoft.com...
> Hi,
> I have Outlook distribution lists of up to 1,000 members. The membership
> changes (to some degree) each month. I have a MS Access database which
> compares the list of people who were on the list last month to the list of
> people who should be in the distribution list this month. It identifies
> people to remove from the distribution list and people to add to the
> distribution list. Is there a good way to use MS Access VBA to
> automatically
> make these changes to the distribution lists?
> For example, last month Tony (and 145 other people) were part of the
> 1stComplaintHandler Email list, but have moved to other responsibilities,
> so
> shouldn't recevie any more email for that group. At the same time, Joan
> (and
> 43 other people) have joined the group that handles 1st Complaints, so
> they
> should be added to the email group "1stComplaintHandler".
> Any help is greatly appreciated (suggestions or even articles to read...)
> Thank you
> SoCal Rick
 
S

SoCal Rick

Hi Sue,

First, thank you for responding to my question.

The Outlook version we use is Outlook 2003(11.8313.8221) SP3. I do most of

my work in Excel and Access, so I don't have much experience with Outlook.

An option available, but I haven't tried it with this quantity, is to

maintain the mailing lists in the Access database. When the user wants to

send a message to everyone on this list, they could have a prompt for the

message and other critical information, then I could open an instance of

Outlook and fill in the "To" and "CC" based on the database. This would

avoid maintaining the DLs in Outlook, however, it would limit the users of

these special lists to people who have access to the MS Access database.

Since there are only a couple of people, this is doable.

I should explain how this is used. We get a download of temporary

assignments for a few thousand people every month. We classify these people

into groups based on information from the database. Then we compare the

results to the prior month's results to determine changes in assignment. We

print out lists of changes and someone has the task of going into Outlook and

modifying the contacts accordingly.

My thought was there must be a way to simplify this so once the updated

information is available, we could automatically update it. When you

mentioned using mail merge in Word, it drove me to think of sending the email

directly from the Access database. This is something I do for some of our

users now, but the mail lists are not very big (up to 20 receipients).

So your thoughts or directions to look at other sources are extremely

valuable to me and I do appreciate your time and expertise.

Thank you,

Rick
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
elzahy maintain email on outlook 2010 Using Outlook 1
J Maintain Distribution List Using Outlook 3
V Maintain name of removed attachments - how to? Using Outlook 9
C active/passive broadband connections to maintain various IT services Exchange Server Administration 2
J Outlook 2010 Outlook/Win7 Client logging Event ID 36887 Using Outlook 0
R How to get the Items object of the default mailbox of a specific account in a multiple account Outlook? Outlook VBA and Custom Forms 0
T Why does outlook 2010 convert only some forum notifications to plain text? Using Outlook 2
M In Outlook Calendar remove the buttons: 'Today' and '<' (Back a day) and '>' (Forward a day) that are below the Ribbon and above the calendar display. Using Outlook 0
J Moved many emails to Outlook external folder, need to delete on Gmail server Using Outlook 13
P Scheduling a meeting in Outlook Outlook Wishlist 4
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
R Outlook 2019 Using Outlook 0
N Outlook Has Become Sluggish Using Outlook 14
HarvMan Outlook 365 Calendar Using Outlook 12
A calendar invites sent from Microsoft Outlook to Mac Outlook is not working Calendar Printing Assistant 2
L Outlook 2016 Contacts missing in Outlook 365 Using Outlook 1
R seperate read layout to design in outlook 2016..Help!! Outlook VBA and Custom Forms 3
A Outlook replies not using "delivered to" address in From Using Outlook 1
GregS Why is Outlook 2016 mail in Outlook.com? Using Outlook 1
G Recurring tasks break links Outlook 2016 Using Outlook 5
L Outlook saved email templates Using Outlook 1
P Outlook for Mac - emails are not sent out beginning last week Using Outlook 1
V Gmail in Outlook Using Outlook 0
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
S Verwendung von Outlook 2007 Using Outlook 0
T "Words In Recipient's Address" Rule Causes Outlook To Stop Processing Rules Using Outlook 3
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 3
T Pictures degrade each time an Outlook item is edited and re-saved Using Outlook 1
Y Outlook 2013 Stop Outlook from automatically assigning categories to Tasks Using Outlook 0
A How to get body of all emails in outlook 2016 to view in blue color Using Outlook 1
J Edit auto-complete list in Outlook 2016+/365? Using Outlook 0
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
S Outlook not receiving mail Using Outlook 1
GregS Outlook 365 blocked by Google popup Using Outlook 2
T upgrade from outlook.com to Outlook Using Outlook 2
R Outlook Autoforward rule do not work for NDR messages Using Outlook 1
Commodore Outlook (2013) issues with icloud.com mail Using Outlook 0
N Extract Outlook emails to excel Outlook VBA and Custom Forms 2
D Add date next to day name in Outlook Today calendar view Using Outlook 1
D iCloud Add-in not working in Outlook 2013 and Outlook 2016 After Windows Upgrade & iCloud Upgrade Using Outlook 2
GregS Outlook 2016 iPhone won't download Outlook 2016 Mail. Using Outlook 0
E How to display "Change Folder" in Change Default Email Delivery Location in Exchange Outlook 2016 Using Outlook 1
M Extract all links from Outlook email, send to Excel Using Outlook 2
O Synchronising contacts Outlook 365 with Google v.v. Using Outlook 4
B Outlook 2003 email sending & receiving suddenly stopped working Using Outlook 3
C Put Day of Year into Outlook Calendar Outlook VBA and Custom Forms 2
David in Mississippi New (Feb 2020) install of Outlook 365 - Cannot specify PST for different accounts Using Outlook 0
M Outlook 2010 Problem with OutLook 2010 32 bit, after Windows Auto Update Using Outlook 3
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
B Outlook and iPhone Sync Using Outlook 3
Similar threads


















































Top