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
D Outlook.com premium finally dying... what do I do with my domain? Using Outlook.com accounts in Outlook 3
witzker Outlook 2019 is cutting Picture Extension *.pn_ Using Outlook 3
S Is there a free version of outlook? Using Outlook 0
peterbata Shared Tasks Outlook for Mac Using Outlook 2
L Ideas for Setup with New Office 365 Family Subscription (Outlook) Using Outlook.com accounts in Outlook 3
M Issue transferring Outlook 2016 email accounts & settings onto new computer Using Outlook 8
S Excel vba code to manage outlook web app Using Outlook 8
J outlook 2007 doesn't let me choose which .pst to search Using Outlook 1
H Custom Outlook Contact Form VBA Outlook VBA and Custom Forms 1
P Outlook 2013 Calendar Archiving Using Outlook 0
D Connecting Gmail to Outlook 365 - My Setup not working Using Outlook 1
K Outlook tasks formatting Using Outlook 4
G Retention Policy for Outlook.com Deleted Items folder Using Outlook 0
S Problem Checking the available stores in my Inbox (Outlook VBA) Outlook VBA and Custom Forms 0
V Is it possible to collect statistics from Outlook forms? Outlook VBA and Custom Forms 1
Z Outlook 365 delete reminder you can’t make change to contents of this-read only folder Using Outlook 4
H I have no profile listed for Outlook! Using Outlook 9
S Outlook VBA How to adapt this code for using in a different Mail Inbox Outlook VBA and Custom Forms 0
S Macro for Loop through outlook unread emails Outlook VBA and Custom Forms 2
D Outlook 2016 how to use gmail account as source account for outlook 365 Using Outlook 9
Horsepower Contacts added from iPhone don't show up in Outlook Using Outlook 1
F Microsoft Outlook Connector 14.0.6123.5001 - Help! Using Outlook 6
A Outlook (and Office) 2019 Logging Using Outlook 2
glnz Can Word Normal.dotm interfere with Outlook? Office 2016 Using Outlook 5
D Outlook 2016 and Earlier with Office365 in 2021 Using Outlook 3
glnz Moving from Outlook 2003 to MS365 Outlook - need basics Using Outlook 4
L Outlook saved template function too limited Using Outlook 2
C Looking for feedback on new Outlook Add-in Using Outlook 0
M Outlook on 3 Computers Shows Different Total Items on Same Account Using Outlook 3
S Outlook email to configure setup for each mail Outlook VBA and Custom Forms 1
witzker print-list-of-outlook-folders with sort posibility Outlook VBA and Custom Forms 7
witzker Open Contact missing in Outlook 2019 Using Outlook 2
D.Moore VB script to Digitaly Sign newly created outlook message Outlook VBA and Custom Forms 2
B Outlook 2016 Retail C2R keeps logging since update? Using Outlook 0
M outlook 365 trying to finish my sentences Using Outlook 0
D Outlook Address Book Using Outlook 0
B Emails get stuck in Outbox of Gmail IMAP in Outlook for Windows Using Outlook 0
C Not sync folders not found after MS Outlook 365 update Using Outlook 1
V Outlook 2016 Does Outlook-2016 (64 bit) work with iCloud for Windows ? Using Outlook 5
R Microsoft Outlook 2016 - Gmail not sending, asks for password for SMTP, tried different ports Using Outlook 23
V Outlook 2016 Outlook-2016 and iCloud for Windows - Problems Using Outlook 9
O VBA Outlook Message Attachment - Array Index Out of Bounds Outlook VBA and Custom Forms 0
K Imap PC Outlook + Android phone Using Outlook 1
GregS Outlook 2016 Move Outlook to new computer? Using Outlook 4
I Outlook 2003 shows html code when To: field is empty Using Outlook 7
O The Outlook API wrongfully shows an outlook folder to have zero sub-folders Outlook VBA and Custom Forms 1

Similar threads

Top