A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - General Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Problems with VBA to update Distribution Lists automatically



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 12th 07, 10:14 PM posted to microsoft.public.outlook
Max Zobel
external usenet poster
 
Posts: 2
Default Problems with VBA to update Distribution Lists automatically

Hello!
I have about 200 contacts and 25 distribution lists in my outlook 2003.
Now the problem is, that whenever I alter the email-address in one
of my contacts the entry in the linked distribution lists does not update
automatically. So my question is, is there a possibility to somehow
automate the process of updating the distribution-list using vba / macros?
I already discovered the DisList... object but there is no such method as
"update now".... any other way to solve that problem with VBA???

Can anybody help?

thx, Max




Ads
  #2  
Old June 12th 07, 10:40 PM posted to microsoft.public.outlook
Charles W Davis
external usenet poster
 
Posts: 132
Default Problems with VBA to update Distribution Lists automatically

You could establish categories. A contact may be in more than one category.
"Max Zobel" wrote in message
...
Hello!
I have about 200 contacts and 25 distribution lists in my outlook 2003.
Now the problem is, that whenever I alter the email-address in one
of my contacts the entry in the linked distribution lists does not update
automatically. So my question is, is there a possibility to somehow
automate the process of updating the distribution-list using vba / macros?
I already discovered the DisList... object but there is no such method as
"update now".... any other way to solve that problem with VBA???

Can anybody help?

thx, Max





  #3  
Old June 12th 07, 10:43 PM posted to microsoft.public.outlook
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default Problems with VBA to update Distribution Lists automatically

Post in a programming group. I suspect you will discover there that DL's are
so dysfunctional that no one uses them or would even attempt to program for
them. Let us know what you find.
--
Russ Valentine
[MVP-Outlook]
"Max Zobel" wrote in message
...
Hello!
I have about 200 contacts and 25 distribution lists in my outlook 2003.
Now the problem is, that whenever I alter the email-address in one
of my contacts the entry in the linked distribution lists does not update
automatically. So my question is, is there a possibility to somehow
automate the process of updating the distribution-list using vba / macros?
I already discovered the DisList... object but there is no such method as
"update now".... any other way to solve that problem with VBA???

Can anybody help?

thx, Max






  #4  
Old June 17th 07, 03:44 PM posted to microsoft.public.outlook
Charles W Davis
external usenet poster
 
Posts: 132
Default Problems with VBA to update Distribution Lists automatically

Russ, Let me introduce myself, I am "Nobody." I have used distribution lists
(DL) since 1997. With 3,012 contacts, my current DLs range in size all over
the place. 15 recipients for current Board of Trustees (most of which use
DLs). 10 recipients for Computer Club Board of Directors, 25 recipients for
fellow retirees that I keep in contact with, and multiple DLs for anywhere
from 21 to 300 recipients (my ISPs daytime max) for newsletter recipients.
Others for City Council members, County Commisioners, relatives.

The only "dysfunctional" aspect that I have found, is that following
upgrading to a new Version, manual requests for updates to a list will not
work. If the DL is created after the installation of a new Version, the
manual request for update works.

With Outlook 2007, the programmers spent a lot of time changing the DL task
bar to look "pretty," removing function, ie, the Ctrl+W (update) and Ctrl+S
(close and save). The programmers could have spent a little time checking
for DL update when a contact's e-mail address changed.

BTW, no offence taken, just wanting you to know that folks do use DLs.

Thanks,
Charles "Nobody" Davis
"Russ Valentine [MVP-Outlook]" wrote in message
...
Post in a programming group. I suspect you will discover there that DL's
are so dysfunctional that no one uses them or would even attempt to
program for them. Let us know what you find.
--
Russ Valentine
[MVP-Outlook]
"Max Zobel" wrote in message
...
Hello!
I have about 200 contacts and 25 distribution lists in my outlook 2003.
Now the problem is, that whenever I alter the email-address in one
of my contacts the entry in the linked distribution lists does not update
automatically. So my question is, is there a possibility to somehow
automate the process of updating the distribution-list using vba /
macros?
I already discovered the DisList... object but there is no such method as
"update now".... any other way to solve that problem with VBA???

Can anybody help?

thx, Max







  #5  
Old June 17th 07, 04:51 PM posted to microsoft.public.outlook
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default Problems with VBA to update Distribution Lists automatically

The overwhelming experience among users of this group is one of great
frustration with DL's. Obviously, that information is skewed somewhat
because people who find a feature working well do not post to say so.
Nevertheless, a quick search will pull up scores of users who have found
their DL's become corrupt and unusable for no apparent reason, cannot be
updated, and cannot be transported one installation to another. They also
get deleted completely with a toolbar action that should simply remove a
member of the DL, not the entire DL.

No real development has gone into DL's since they first appeared in Outlook
2000 to try to make them more reliable. The only changes made have been to
the GUI. That's a shame because they would be a truly useful feature if they
could be made reliable and robust. Since they haven't, many users have
migrated away from their use.

I hope you continue to have good luck with them. If you were using DL's in
1997 then you are obviously talking about the Active Directory in Exchange,
not DL's in a PST file, which are the subject of most posts here.
--
Russ Valentine
[MVP-Outlook]
"Charles W Davis" wrote in message
...
Russ, Let me introduce myself, I am "Nobody." I have used distribution
lists (DL) since 1997. With 3,012 contacts, my current DLs range in size
all over the place. 15 recipients for current Board of Trustees (most of
which use DLs). 10 recipients for Computer Club Board of Directors, 25
recipients for fellow retirees that I keep in contact with, and multiple
DLs for anywhere from 21 to 300 recipients (my ISPs daytime max) for
newsletter recipients. Others for City Council members, County
Commisioners, relatives.

The only "dysfunctional" aspect that I have found, is that following
upgrading to a new Version, manual requests for updates to a list will not
work. If the DL is created after the installation of a new Version, the
manual request for update works.

With Outlook 2007, the programmers spent a lot of time changing the DL
task bar to look "pretty," removing function, ie, the Ctrl+W (update) and
Ctrl+S (close and save). The programmers could have spent a little time
checking for DL update when a contact's e-mail address changed.

BTW, no offence taken, just wanting you to know that folks do use DLs.

Thanks,
Charles "Nobody" Davis
"Russ Valentine [MVP-Outlook]" wrote in message
...
Post in a programming group. I suspect you will discover there that DL's
are so dysfunctional that no one uses them or would even attempt to
program for them. Let us know what you find.
--
Russ Valentine
[MVP-Outlook]
"Max Zobel" wrote in message
...
Hello!
I have about 200 contacts and 25 distribution lists in my outlook 2003.
Now the problem is, that whenever I alter the email-address in one
of my contacts the entry in the linked distribution lists does not
update
automatically. So my question is, is there a possibility to somehow
automate the process of updating the distribution-list using vba /
macros?
I already discovered the DisList... object but there is no such method
as
"update now".... any other way to solve that problem with VBA???

Can anybody help?

thx, Max









  #6  
Old June 17th 07, 07:29 PM posted to microsoft.public.outlook
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Problems with VBA to update Distribution Lists automatically

Blast from the past: For Outlook 97 and 98, personal DL support was provided by the Personal Address Book provider.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Russ Valentine [MVP-Outlook]" wrote in message ...

I hope you continue to have good luck with them. If you were using DL's in
1997 then you are obviously talking about the Active Directory in Exchange,
not DL's in a PST file, which are the subject of most posts here.


  #7  
Old June 17th 07, 08:29 PM posted to microsoft.public.outlook
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default Problems with VBA to update Distribution Lists automatically

Yes. I remember. But not in PST files. It seemed to me that the attempt to
implement DL's in PST files was the start of their downfall.
--
Russ Valentine
[MVP-Outlook]
"Sue Mosher [MVP-Outlook]" wrote in message
...
Blast from the past: For Outlook 97 and 98, personal DL support was provided
by the Personal Address Book provider.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Russ Valentine [MVP-Outlook]" wrote in message
...

I hope you continue to have good luck with them. If you were using DL's in
1997 then you are obviously talking about the Active Directory in
Exchange,
not DL's in a PST file, which are the subject of most posts here.



  #8  
Old June 19th 07, 02:47 PM posted to microsoft.public.outlook
Charles W Davis
external usenet poster
 
Posts: 132
Default Problems with VBA to update Distribution Lists automatically

I also had the problem with the delete deleting the DL, until I remembered
prior versions used the Remove function. It is there in plain sight! It was
easy to move the DL back from the Deleted Items folder.
I still resent the removal of the keyboard shortcuts.

Thanks for listening.
"Russ Valentine [MVP-Outlook]" wrote in message
...
The overwhelming experience among users of this group is one of great
frustration with DL's. Obviously, that information is skewed somewhat
because people who find a feature working well do not post to say so.
Nevertheless, a quick search will pull up scores of users who have found
their DL's become corrupt and unusable for no apparent reason, cannot be
updated, and cannot be transported one installation to another. They also
get deleted completely with a toolbar action that should simply remove a
member of the DL, not the entire DL.

No real development has gone into DL's since they first appeared in
Outlook 2000 to try to make them more reliable. The only changes made have
been to the GUI. That's a shame because they would be a truly useful
feature if they could be made reliable and robust. Since they haven't,
many users have migrated away from their use.

I hope you continue to have good luck with them. If you were using DL's in
1997 then you are obviously talking about the Active Directory in
Exchange, not DL's in a PST file, which are the subject of most posts
here.
--
Russ Valentine
[MVP-Outlook]
"Charles W Davis" wrote in message
...
Russ, Let me introduce myself, I am "Nobody." I have used distribution
lists (DL) since 1997. With 3,012 contacts, my current DLs range in size
all over the place. 15 recipients for current Board of Trustees (most of
which use DLs). 10 recipients for Computer Club Board of Directors, 25
recipients for fellow retirees that I keep in contact with, and multiple
DLs for anywhere from 21 to 300 recipients (my ISPs daytime max) for
newsletter recipients. Others for City Council members, County
Commisioners, relatives.

The only "dysfunctional" aspect that I have found, is that following
upgrading to a new Version, manual requests for updates to a list will
not work. If the DL is created after the installation of a new Version,
the manual request for update works.

With Outlook 2007, the programmers spent a lot of time changing the DL
task bar to look "pretty," removing function, ie, the Ctrl+W (update) and
Ctrl+S (close and save). The programmers could have spent a little time
checking for DL update when a contact's e-mail address changed.

BTW, no offence taken, just wanting you to know that folks do use DLs.

Thanks,
Charles "Nobody" Davis
"Russ Valentine [MVP-Outlook]" wrote in message
...
Post in a programming group. I suspect you will discover there that DL's
are so dysfunctional that no one uses them or would even attempt to
program for them. Let us know what you find.
--
Russ Valentine
[MVP-Outlook]
"Max Zobel" wrote in message
...
Hello!
I have about 200 contacts and 25 distribution lists in my outlook 2003.
Now the problem is, that whenever I alter the email-address in one
of my contacts the entry in the linked distribution lists does not
update
automatically. So my question is, is there a possibility to somehow
automate the process of updating the distribution-list using vba /
macros?
I already discovered the DisList... object but there is no such method
as
"update now".... any other way to solve that problem with VBA???

Can anybody help?

thx, Max










  #9  
Old June 19th 07, 09:26 PM posted to microsoft.public.outlook
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default Problems with VBA to update Distribution Lists automatically

I'm sure it won't surprise you, however, that many users lose their entire
DL's because they don't realize they deleted it before they empty their
Deleted Items Folder. Invariably, they are the same users who do not back up
their data.
The removal of keyboard shortcuts is a mystery to me. I'd like to think it
was an oversight rather than deliberate, except I know it takes more work to
remove a feature than just to carry it over from one version to the next.
Odd. It's bad enough that they didn't improve DL's, but they didn't have to
make them worse.
--
Russ Valentine
[MVP-Outlook]
"Charles W Davis" wrote in message
...
I also had the problem with the delete deleting the DL, until I remembered
prior versions used the Remove function. It is there in plain sight! It was
easy to move the DL back from the Deleted Items folder.
I still resent the removal of the keyboard shortcuts.

Thanks for listening.
"Russ Valentine [MVP-Outlook]" wrote in message
...
The overwhelming experience among users of this group is one of great
frustration with DL's. Obviously, that information is skewed somewhat
because people who find a feature working well do not post to say so.
Nevertheless, a quick search will pull up scores of users who have found
their DL's become corrupt and unusable for no apparent reason, cannot be
updated, and cannot be transported one installation to another. They also
get deleted completely with a toolbar action that should simply remove a
member of the DL, not the entire DL.

No real development has gone into DL's since they first appeared in
Outlook 2000 to try to make them more reliable. The only changes made
have been to the GUI. That's a shame because they would be a truly useful
feature if they could be made reliable and robust. Since they haven't,
many users have migrated away from their use.

I hope you continue to have good luck with them. If you were using DL's
in 1997 then you are obviously talking about the Active Directory in
Exchange, not DL's in a PST file, which are the subject of most posts
here.
--
Russ Valentine
[MVP-Outlook]
"Charles W Davis" wrote in message
...
Russ, Let me introduce myself, I am "Nobody." I have used distribution
lists (DL) since 1997. With 3,012 contacts, my current DLs range in size
all over the place. 15 recipients for current Board of Trustees (most of
which use DLs). 10 recipients for Computer Club Board of Directors, 25
recipients for fellow retirees that I keep in contact with, and multiple
DLs for anywhere from 21 to 300 recipients (my ISPs daytime max) for
newsletter recipients. Others for City Council members, County
Commisioners, relatives.

The only "dysfunctional" aspect that I have found, is that following
upgrading to a new Version, manual requests for updates to a list will
not work. If the DL is created after the installation of a new Version,
the manual request for update works.

With Outlook 2007, the programmers spent a lot of time changing the DL
task bar to look "pretty," removing function, ie, the Ctrl+W (update)
and Ctrl+S (close and save). The programmers could have spent a little
time checking for DL update when a contact's e-mail address changed.

BTW, no offence taken, just wanting you to know that folks do use DLs.

Thanks,
Charles "Nobody" Davis
"Russ Valentine [MVP-Outlook]" wrote in message
...
Post in a programming group. I suspect you will discover there that
DL's are so dysfunctional that no one uses them or would even attempt
to program for them. Let us know what you find.
--
Russ Valentine
[MVP-Outlook]
"Max Zobel" wrote in message
...
Hello!
I have about 200 contacts and 25 distribution lists in my outlook
2003.
Now the problem is, that whenever I alter the email-address in one
of my contacts the entry in the linked distribution lists does not
update
automatically. So my question is, is there a possibility to somehow
automate the process of updating the distribution-list using vba /
macros?
I already discovered the DisList... object but there is no such method
as
"update now".... any other way to solve that problem with VBA???

Can anybody help?

thx, Max











 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic update problems post-update 404max Outlook Express 7 December 19th 06 03:10 AM
distribution lists won't update Josh Outlook - Using Contacts 1 July 27th 06 09:24 PM
Distribution Lists sourced from linked SharePoint Contact Lists Marcela Outlook - Using Contacts 4 July 17th 06 12:08 AM
problems with distribution lists and group replies in Outlook The Cook Outlook - Using Contacts 8 April 4th 06 03:14 PM
Why doesn't "Update Now" make changes in some distribution lists? John Helms Outlook - Using Contacts 2 January 19th 06 09:45 PM


All times are GMT +1. The time now is 03:36 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.