Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Update of a Mailing List when Changes performed

Posted on 2008-10-13
8
Medium Priority
?
280 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
[X]
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
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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 400 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
Are you looking for the options available for exporting EDB files to PST? You may be confused as they are different in different Exchange versions. Here, I will discuss some options available.
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

618 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