Extract email addresses out of a CC line

[Jim]

I have a professor who somehow "lost" his email distribution list. However, I have his complete email distribution list in the "CC" line of every email blast he ever sent me before this problem happened.

How can I harvest the 100 or so email addresses out of the "CC" line in one of the emails he sent to me and forward them back to him? I'm using Outlook 2003.

I understand how I can do this one CC email address at a time, but there has got to be a better way. And the third party email address extractors that I read about seem to pull every address out of Outlook and not just the addresses out of a particular email.

Any good ideas here?

 

[Michael Bauer [MVP - Outlook]]

Isn't it possible to open the email and copy all the addresses from the CC
field?

--
Best regards
Michael Bauer - MVP Outlook
Use Outlook Categories? This is Your Tool:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Wed, 12 Mar 2008 20:26:37 -0400 schrieb Jim:

I have a professor who somehow "lost" his email distribution list.

However, I have his complete email distribution list in the "CC" line of
every email blast he ever sent me before this problem happened.

How can I harvest the 100 or so email addresses out of the "CC" line in

one of the emails he sent to me and forward them back to him? I'm using
Outlook 2003.

I understand how I can do this one CC email address at a time, but there

has got to be a better way. And the third party email address extractors
that I read about seem to pull every address out of Outlook and not just the
addresses out of a particular email.

 

[Jim]

Michael

You asked "Isn't it possible to open the email and copy all the addresses from the CC field?"

No - that is the problem and that's what prompted this post in the first place. Try it and you'll see what I mean.

You can copy email addresses from a CC line and paste them into the To or CC line of another email. But Outlook won't let you paste them into into the body of an email itself (which I would want to do if I were going to send his email addresses back to him).

Now, I could Reply to All and my professor would get all of his email addresses back that way, but my reply would go to his entire email distribution list.

And my understanding of email address extraction tools is that they extract every email from Outlook and not from an individual email.

So that's the prob - -

 

[Michael Bauer [MVP - Outlook]]

You can copy the CC field and insert into the body of an email. What is
being copied are display names, which might be addresses or names. For you
the latter may be worthless; but your Prof should be able to resolve the
names - except he has lost his contacts, too.

--
Best regards
Michael Bauer - MVP Outlook
Use Outlook Categories? This is Your Tool:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Fri, 14 Mar 2008 09:59:41 -0500 schrieb Jim:

Michael

You asked "Isn't it possible to open the email and copy all the addresses from the CC field?"

No - that is the problem and that's what prompted this post in the first

place. Try it and you'll see what I mean.

You can copy email addresses from a CC line and paste them into the To or

CC line of another email. But Outlook won't let you paste them into into the
body of an email itself (which I would want to do if I were going to send
his email addresses back to him).

Now, I could Reply to All and my professor would get all of his email

addresses back that way, but my reply would go to his entire email
distribution list.

And my understanding of email address extraction tools is that they

extract every email from Outlook and not from an individual email.

 

[Jim]

So, for anyone following this post - if an email sender has "lost" his email distribution list, it is apparently not possible for a receiver to extract email addresses from a CC line (or a To line for that matter) in an email that the sender sent before the "loss" and return them to him.

When you cut or copy from a CC line or a To line all you get are the display names which, in some cases, may be the email address but often is not.

 

[Russ Valentine [MVP-Outlook]]

Not accurate. Seems to work fine for most everyone else. Copying from the
To: or CC: lines in an Outlook message in current versions of Outlook will
provide all the information you need. Well documented here:
http://www.outlook-tips.net/archives/2004/20041105.htm

 

[Jim]

[quote title=russval wrote on Sun, 16 March 2008 21:09]Not accurate. Seems to work fine for most everyone else. Copying from the
To: or CC: lines in an Outlook message in current versions of Outlook will
provide all the information you need. Well documented here:
http://www.outlook-tips.net/archives/2004/20041105.htm
--
Russ Valentine
[MVP-Outlook]

Russ

You might want to re-read this thread - you've missed the issue completely. The issue is not whether or not one can create a distribution list from the email addresses in a CC line or a To line (which is what your link is all about) - it's that one can't return the email addresses in a sender's CC line back to the sender in the body of an email.

 

[Michael Bauer [MVP - Outlook]]

If it doesn't work for you, you still have the option to extract the
addresses by VBA code. You might want to open the VBA environment (alt+f11)
and look into the object browser (f2): Look for MailItem left hand and
Recipients right hand. That collection contains all the recipients. Select
the entry and click f1 for help.

--
Best regards
Michael Bauer - MVP Outlook
Use Outlook Categories? This is Your Tool:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Mon, 17 Mar 2008 01:19:29 -0400 schrieb Jim:

[quote title=russval wrote on Sun, 16 March 2008 21:09]Not accurate. Seems

to work fine for most everyone else. Copying from the

 

[Russ Valentine [MVP-Outlook]]

I did not miss the issue at all. I differed with the pronouncement you were
making to other users. Since all current versions of Outlook use both the
familiar name and email address as the display name, users can easily create
DL's from the To: or CC; fields. Why does your version differ?
--
Russ Valentine
[MVP-Outlook]

[quote title=russval wrote on Sun, 16 March 2008 21:09]Not accurate. Seems
to work fine for most everyone else. Copying from the
To: or CC: lines in an Outlook message in current versions of Outlook will
provide all the information you need. Well documented here:
http://www.outlook-tips.net/archives/2004/20041105.htm
--
Russ Valentine
[MVP-Outlook]

Russ

You might want to re-read this thread - you've missed the issue
completely. The issue is not whether or not one can create a distribution
list from the email addresses in a CC line or a To line (which is what
your link is all about) - it's that one can't return the email addresses
in a sender's CC line back to the sender in the body of an email.

 

[Jim]

Michael Bauer wrote on Mon, 17 March 2008 01:19

If it doesn't work for you, you still have the option to extract the addresses by VBA code. You might want to open the VBA environment (alt+f11) and look into the object browser (f2): Look for MailItem left hand and Recipients right hand. That collection contains all the recipients. Select the entry and click f1 for help.

Thanks Michael, but expecting a professor who "lost" all his email addresses to have a recipient from each of his distribution lists extract the addresses by VBA code and send them back to him probably just isn't practical.

It's beginning to look like there isn't a user-friendly way (for the average Joe anyway) to transfer email addresses from one Outlook client to another. Perhaps some future version of Outlook could offer email address specific functions that cut/copy/paste both the display names and the email addresses.

Jim

 

[Jim]

russval wrote on Mon, 17 March 2008 04:49

. . . Since all current versions of Outlook use both the familiar name and email address as the display name, users can easily create DL's from the To: or CC; fields. Why does your version differ?

Russ

That is certainly the default but I just went over the last five email blasts sent to me from senders who show every recipient in the CC or the To line and every one of them deviated from the default.

My hallucination is that users who send emails that way instead of setting up distribution lists aren't all that sophisticated in the first place (as Outlook users go anyway) and so make a regular practice out of making sense of Sally Whats-her-name’s mailto:[email protected] email address by changing the display name.

In fact, in my company it's our practice to always change the display name to the recipient’s complete name - particularly with customers and suppliers. It’s a sales thing and seems more professional that way.

Jim