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.
Similar threads
Thread starter Title 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
L Duplicate calendar entries in Outlook 365 Using Outlook 3
V Outlook 2021 Can anyone explain why my Outlook views keep changing?! Using Outlook 2
AlphonseG Outlook 365 Outlook Crashes on setting SaveSentMessageFolder Outlook VBA and Custom Forms 4
S Outlook 2021 How to customize colors Outlook 2021 & Office 2021 on PC Using Outlook 0
D Outlook 2007 Recovering E-Mails Using Outlook 0
G Stop Outlook 365 adding meetings to calendar Using Outlook 0
HarvMan Using Emojis in Outlook 365 Using Outlook 3
T Outlook 2019 Not Using Auto Compete After Deletion of 365 Using Outlook 1
D Gmail mail is being delivered to a different email inbox in Outlook App 2021 Using Outlook 2
Albert McCann Outlook 2021 Outlook Display of HTML Email from two senders is glitchy Using Outlook 0
richardwing Outlook 365 VBA to access "Other Actions" menu for incoming emails in outlook Outlook VBA and Custom Forms 0
J Unable to delete folders in Outlook 2019 / Windows Using Outlook 1
K Outlook for Mac problems Using Outlook 0
D Outlook app 2021 & iCloud PST issues Using Outlook 2
M c# vsto Outlook.ApplicationEvents_11_NewMailEx Outlook VBA and Custom Forms 1
J Event/Meeting in Outlook Does Not Align with SharePoint Calendar Using Outlook 5
Christopher M Is it me, or is Outlook 365 BUGGY? Using Outlook 3
U Outlook on the iPhone cannot approve filtered Emails Using Outlook 0
J GoDaddy migrated to Office365 - Outlook Wont Add Account Exchange Server Administration 21
K Outlook 365 After migrating to Outlook 365, some contacts display in emails with prefixes Using Outlook 1
J Outlook Rules VBA Run a Script - Multiple Rules Outlook VBA and Custom Forms 0
Horsepower Cannot delete gmail in iPhone Outlook outbox Using Outlook 1
F Outlook 2019 Outlook 2019 Add and Sync to New computer Comcast server Using Outlook 2
M Understanding Outlook Identities Using Outlook 1
kburrows Outlook or Phone Combining Contacts? Using Outlook 0
P Outlook 2013 search no longer works Using Outlook 2
M Accessing ALL Outlook contact fields Outlook VBA and Custom Forms 3
C Outlook (desktop app for Microsoft365) restarts every time I save my VBA? Using Outlook 0
R MailTips and older Outlook versions Using Outlook 0
A iCloud Outlook Add In is causing Outlook 2021 to crash and got disabled Using Outlook 9
C How to import Outlook calendar? Using Outlook 1
HarvMan Outlook 365 loses "outlook.com" exchange server settings Using Outlook 1
HarvMan Outlook.com Account Using Outlook 3
D Office 365 Outlook desktop app prompts for all account passwords on startup Using Outlook 6
D Alerts in outlook Using Outlook 1
richardwing Auto forward email that is moves into a specific outlook folder Outlook VBA and Custom Forms 5
L Recommendations for Utility to Backup Outlook 365 Account Settings Using Outlook 2
J Recommendations for Outlook Duplicate Email Remover Using Outlook 6
O Outlook - How to embed font ? (If at all possible) Using Outlook 2
Z New minimum Outlook for Windows version requirements for Microsoft 365/Exchange Online Using Outlook.com accounts in Outlook 26
T How to configure Outlook for two users on a single Windows account Using Outlook 3
R Outlook 2021 Having problem setting up outlook 2021 with windows 11. I have 3 gmail accounts and I want the 3 gmail, emails to merge into the same outlook input. Using Outlook.com accounts in Outlook 0
e_a_g_l_e_p_i Outlook 2021 all appointments not showing in calendar Using Outlook 2
S Outlook 365 Can I change the possible range of highlighting colours when writing an Outlook email? Using Outlook 1
B Outlook 213 keeps crashing. I just found out there are DMP files. How can I tell Why? Using Outlook 2
H Outlook 2016 related mails in outlook Outlook VBA and Custom Forms 13

Similar threads

Top