print phone numbers from a distribution list in outlook

[Guest]

I WANT TO PRINT A LIST OF NAMES AND PHONE NUMBERS FROM A DISTRIBUTION LIST IN
OUTLOOK - ANY IDEAS?

 

[Russ Valentine [MVP-Outlook]]

First turn off your Caps key.
Second, post a clear question. Since DL's do not include phone numbers, no
one could even figure out what you mean.

 

[Guest]

OK caps key is off - sorry! I will try to be very clear. I have many
contacts in my address book. I have a group of those contacts which is a
distribution list. Each contact has phone numbers and addresses. I am
thinking that there should be a way to get a print out of the contacts that
are in the distribution list including their names and phone numbers.

I hope this is clear.

First turn off your Caps key.
Second, post a clear question. Since DL's do not include phone numbers, no
one could even figure out what you mean.

--
Russ Valentine
[MVP-Outlook]

I WANT TO PRINT A LIST OF NAMES AND PHONE NUMBERS FROM A DISTRIBUTION LIST
IN
OUTLOOK - ANY IDEAS?

 

[Russ Valentine [MVP-Outlook]]

It isn't. See my original post.
--
Russ Valentine
[MVP-Outlook]

OK caps key is off - sorry! I will try to be very clear. I have many
contacts in my address book. I have a group of those contacts which is a
distribution list. Each contact has phone numbers and addresses. I am
thinking that there should be a way to get a print out of the contacts
that
are in the distribution list including their names and phone numbers.

I hope this is clear.

First turn off your Caps key.
Second, post a clear question. Since DL's do not include phone numbers,
no
one could even figure out what you mean.

--
Russ Valentine
[MVP-Outlook]

I WANT TO PRINT A LIST OF NAMES AND PHONE NUMBERS FROM A DISTRIBUTION
LIST
IN
OUTLOOK - ANY IDEAS?

 

[Brian Tillman]

OK caps key is off - sorry! I will try to be very clear. I have many
contacts in my address book. I have a group of those contacts which
is a distribution list. Each contact has phone numbers and
addresses. I am thinking that there should be a way to get a print
out of the contacts that are in the distribution list including their
names and phone numbers.

I hope this is clear.

I think it's clear. If it's possible at all (which I don't know), it can be
done only if you write the add-in to do it. There's no built-in way for
Outlook to accomplish that. You should consider asking in a programming
group like microsoft.public.outlook.program_vba.

While I'm not conversant enough with Excel to say whether what I'm about to
propose is possible, I do know Excel is fairly powerfile in its abilities.
I can conceive of you being able to do the job in Excel. Export the DL to a
text file (i.e., open the DL and click FIle>Save As). The export the
Contacts folder and a CSV file, including the E-mail address field and the
appropriate phone number field (the one you want to see). Open both of
those files in Excel and use Excel's automation to scan the E-mail addresses
in the DL sheet, matching each to the E-mail address in the Contacts sheet,
grabbing the phone number when it finds a match and adding it to the first
sheet. Then print that sheet when it completes.

 

[Russ Valentine [MVP-Outlook]]

Ouch. That's quite a chore even if it would even work.
The problem of course is that DL's do not contain the information the OP
wants to print and there is no way to link DL members back to their original
Contact Record.
If it takes this much trouble, another alternative would be to use a better
and more robust way to group Contacts, such as Categories or separate
Contact subfolders. That way access is retained to all the Contact data
contained in the Contact Record and the user isn't stuck using a grouping
feature that doesn't work well in the first place.

 

[Brian Tillman]

Ouch. That's quite a chore even if it would even work.

Not on OpenVMS, however.