Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Update of a Mailing List when Changes performed

Posted on 2008-10-13
8
275 Views
Last Modified: 2012-05-05
Hi Experts

Following is my mailing list setup:

Each European Country has a mailing list, with its unique contacts.
Europe is set up in 10 different Zones which contain several country-mailing lists.

Now my problem is, when an e-mail address changes, which often happens, the mailing lists don't update. So when I change the e-mail address of a contact in Italy, I have to update the contact manually in the Italy mailing list and in addition to that I have to update i.e. deleting and re-adding the Italy mailing list in the respective zone.

Is there a way to do this automatically?

Looking forward to the reply. Thank you very much

Ronnie
0
Comment
Question by:Ronnie_Bischof
  • 4
  • 4
8 Comments
 

Author Comment

by:Ronnie_Bischof
ID: 22701320
An addition to my question above: The Mailing lists are in the public contact folder on a SBS2003 Server
0
 
LVL 76

Expert Comment

by:David Lee
ID: 22746694
Hi, Ronnie.

The simplest way to solve this problem is to stop using distribution lists.  Use categories instead.  If each item contact had two categories set, one for the country and the other for the zone, then staff could mail to an entire country or zone by mailing to the respective category.  Best of all, no one would have to keep mailing lists updated.  
0
 

Author Comment

by:Ronnie_Bischof
ID: 22756505
Thanks for the reply. I have no set the category for the eg. Austria broker to GRP_Austria and to GRP_Europe_Zone5 but as they are all in seperate folders: Sales Contacts --> Europe --> Austria, and in addition in a public contact folder, so what is the smartest way to send the e-mails to the Zone5, as there is eg. Austria, Germany etc. in there.

I like the idea of setting up categories very much, just need to find a smart way to use them then, and I have not found out that one yet.

Thanks for your reply
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 76

Expert Comment

by:David Lee
ID: 22763631
Before answering I need to make sure I understand.  Are you saying that each country is in its own folder?  For example, Germany and Austria, both countries in Zone 5 are each in separate public folders?
0
 

Author Comment

by:Ronnie_Bischof
ID: 22765400
Hey BlueDevilFan

The Setup with the folders is as follows:

Sales Contacts
    Africa
    Europe
        Austria
        Belgium
        Bulgary
        etc.
    Asia
    etc.

Until now I had in the folder Europe the Mailing Lists for the different Zones.
If it is not possible to do what we are trying to achieve with this setup I can change it, but it would be like the last resort as it would be a lot of work :-)

Thanks for your help

Cheers

Ronnie
0
 
LVL 76

Accepted Solution

by:
David Lee earned 100 total points
ID: 22771569
Hi, Ronnie.

What I proposed won't work with that structure.  I was thinking the structure was like this

Sales Contacts
  Africa
  Europe
    Zone 1 (contains Austria and Germany)
    Zone 2 (contains Belgium, Luxembourg, and Netherlands)
  Asia

If the contacts in Zone 1 were tagged with the categories "Zone 1" and "Austria" or "Germany", then when viewing by category a person could send to everyone in the zone, or everyone in either Germany or Austria by selecting the category and clicking Actions > Create > New Message to Contact.  If access to the contracts is controlled by permissions and not everyone has access to all the contact folders, then the structure you have now is good.  But, if everyone has access to the contacts, then the current structure isn't as efficient as putting all the contacts into a single folder and using categories or another field to view/use them.  For example, consider a structure where we have a single folder for all sales contacts.  Each contact in the folder has at least three categories: continent, zone, country name.  If we set the view to "By Category" then we get the same effect as having folders.  Expand the Asia category and you see all contacts in Asia.  Expand a zone and you see all contacts in that zone.  Expand a country and see all contacts in that country.  Don't want to view them by category?  No problem.  Create views for whatever grouping you want to see.  Not only can you view the contacts in more ways, you've also flattened the folder structure making them easier to navigate, eliminated the need for maintaining distribution lists (you can send to any group or multiple groups at once just be selecting them), and reduced space usage on your Exchange server (your admin will love you).
0
 

Author Closing Comment

by:Ronnie_Bischof
ID: 31407095
Thanks for the good Ideas and support. The explanation was easy to understand and brought across in a nice way (doesn't always happen).

Will set this up tomorrow and instruct my coworkers about the new structure.

Thanks for your help
0
 
LVL 76

Expert Comment

by:David Lee
ID: 22772018
You're welcome.  Glad I could help out.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
Find out what you should include to make the best professional email signature for your organization.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question