Replies

Do you know of any posts on this site that demonstrate tools that I can use to retrieve the address details, when I have the name?

Thank you very much for all your help.

Thank you for that.
Now that the Clipboard has up to 24 items in it, is it possible to just clear the last item copied? or do we have to clear the whole clipboard?

Thank you for that.
Now that the Clipboard has up to 24 items in it, is it possible to just clear the last item copied? or do we have to clear the whole clipboard?

We dont’ have any duplicate names, because if someone has the same name as another person, then there is a description of the area they work in (eg “Jscher (ABC)” and “Jscher (XYZ)”. This prevents us sending e-mails to the wrong person.

I am struggling a lot with the Outlook Object Model. I have a lot of trouble writing simple code to lookup the address details of a name, or to look up all the names for a distribution list. I hope it starts to make some sense soon. If you have any sample code to lookup details, or members of the address list then this would be appreciated.

One more comment, is that when the I use the “” tag in the GetAddress dialog box, it only ever returns the name and none of the other address details.

We dont’ have any duplicate names, because if someone has the same name as another person, then there is a description of the area they work in (eg “Jscher (ABC)” and “Jscher (XYZ)”. This prevents us sending e-mails to the wrong person.

I am struggling a lot with the Outlook Object Model. I have a lot of trouble writing simple code to lookup the address details of a name, or to look up all the names for a distribution list. I hope it starts to make some sense soon. If you have any sample code to lookup details, or members of the address list then this would be appreciated.

One more comment, is that when the I use the “” tag in the GetAddress dialog box, it only ever returns the name and none of the other address details.

What if I use the GetAddress method to return only one name? Is it possible to access the DistListItem by using its name? I am having trouble using this collection.

What if I use the GetAddress method to return only one name? Is it possible to access the DistListItem by using its name? I am having trouble using this collection.

My address formatting may be different to yours. However, I think you have answered my question. The next address always begins with a CR “, “.

There appears to be no way to distinguish between CC and TO addresses though, or is there? and your result is probably limited to 255 characters also, or is it?

Thanks

My address formatting may be different to yours. However, I think you have answered my question. The next address always begins with a CR “, “.

There appears to be no way to distinguish between CC and TO addresses though, or is there? and your result is probably limited to 255 characters also, or is it?

Thanks

The code calls the GetAddress dialog with dialog of 2, which allows the user to enter multiple addresses

sAddress = Application.GetAddress _
(addressproperties:=cTags, _
useautotext:=False, _
displayselectdialog:=1, selectdialog:=2)

The result looks like this
Bear;Pooh;;;;;;;;;;;/;
, Piglet;;;;;;;;;;;;;
, Eeoor;;;;;;;;;;;

Each address is separated with a CR and a “, “. Unfortunately, it limits the result to 255 characters, which is not very helpful. Also, there seems to be no way to determine if it is returning a CC or a TO address.

The code calls the GetAddress dialog with dialog of 2, which allows the user to enter multiple addresses

sAddress = Application.GetAddress _
(addressproperties:=cTags, _
useautotext:=False, _
displayselectdialog:=1, selectdialog:=2)

The result looks like this
Bear;Pooh;;;;;;;;;;;/;
, Piglet;;;;;;;;;;;;;
, Eeoor;;;;;;;;;;;

Each address is separated with a CR and a “, “. Unfortunately, it limits the result to 255 characters, which is not very helpful. Also, there seems to be no way to determine if it is returning a CC or a TO address.

Andrew, I am having some trouble extracting the addresses from the strAddress string. Do you know what symbol or character delimits each address? I tried the CR and it almost works. But each entry has a “, ” preceding it. Also, is there a way to determine which addresses are CC, and which are TO?

Thanks!

Andrew, I am having some trouble extracting the addresses from the strAddress string. Do you know what symbol or character delimits each address? I tried the CR and it almost works. But each entry has a “, ” preceding it. Also, is there a way to determine which addresses are CC, and which are TO?

Thanks!

Andrew

Thanks for that. Someone on the Outlook board directed me to Knowledge Base Article 287563 which I need to set up to be able to view Outlook Address Books. So I can now see the Address books.

I am still interested to find out how to access the members of a distribution list, as I don’t really understand the Outlook model. If you know anything, that would be great.
Marie-Therese

Andrew

Thanks for that. Someone on the Outlook board directed me to Knowledge Base Article 287563 which I need to set up to be able to view Outlook Address Books. So I can now see the Address books.

I am still interested to find out how to access the members of a distribution list, as I don’t really understand the Outlook model. If you know anything, that would be great.
Marie-Therese