print phone numbers from a distribution list in outlook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I WANT TO PRINT A LIST OF NAMES AND PHONE NUMBERS FROM A DISTRIBUTION LIST IN
OUTLOOK - ANY IDEAS?
 
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.
 
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.


Russ Valentine said:
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]
WRANGLER said:
I WANT TO PRINT A LIST OF NAMES AND PHONE NUMBERS FROM A DISTRIBUTION LIST
IN
OUTLOOK - ANY IDEAS?
Click to expand...
Click to expand...
 
It isn't. See my original post.
--
Russ Valentine
[MVP-Outlook]
WRANGLER said:
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.


Russ Valentine said:
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]
WRANGLER said:
I WANT TO PRINT A LIST OF NAMES AND PHONE NUMBERS FROM A DISTRIBUTION
LIST
IN
OUTLOOK - ANY IDEAS?
Click to expand...
Click to expand...
Click to expand...
 
WRANGLER said:
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.
Click to expand...

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.
 
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.
 
Back
Top