linking excel to Outlook

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Hi,

We have distribution lists created geographically. We have master list of
all contacts, along with other ancillary info not necessarily applicable to
an Outlook contact record. Is it possible to update an email address -- or
delete a row -- in excel and have the distribution list in Outlook reflect
that edit or deletion. If so, can you point me to any info?

Office 2003.

thanks
 
Hi Kevin,

for changes in Excel you can use the WorkSheet_Change event. Not sure
how it works, I think you´ll get the event after a change is made. If so
then you´d need the e-mail address value before it was changed for
comparing it with the DL. Probably I´d store the e-mail address twice in
the Worksheet, once visible for the user and once unvisible. The latter
could be used to find that entry in the DL and could be updated in the
end by code.

For getting the entry from the DL you´d need to loop through all items
with GetMember function, then compare the returned Recipient object´s
Address property with the address from XL.
 
Am Thu, 11 Aug 2005 11:55:32 -0500 schrieb jimboy:

Yes, just add a reference to the Outlook library to your Excel project.
Please open the object browser (F2), switch from <All Libraries> to
Outlook, select DistListItem in the left pane, and AddMember in the
right one, and then press F1 for help. A sample is available there.
 
I am trying to create DistList in Outlook programmatically, using name-email
pairs stored in excel file. There are about 600 entries to be added to the
list. But my code hangs after about 145 entries or so. Is there a limit to a
number of entries that a DL can hold ? Is this limit set by the mail server
or by Outlook ? Can anoyboy help me this please ?

Lost.

-Thanks.
 
Personal DLs in Exchange mailbox or public folders have a size limit. It's usually around 120 members, but that can vary depending on the actual data in the DL. The size cannot be increased. You can consider nesting DLs, which is supported, but I'd recommend that you reconsider the need for a DL in the first place.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top