Automating retrieving email addresses from 306 received emails?

  • Thread starter StargateFanFromWork
  • Start date
S

StargateFanFromWork

Good Morning!

A colleague just came by my desk. Here at the office, we've received 306
emails so far that need responding to. The problem is that we'll be
receiving emails such as this over the next few days where we'll need to
respond to these public enquiries. We'll b.c.c. the public so that email
addresses are not visible to the recipients but my colleague was dismayed
and hoped he wouldn't have to open each message to retrieve the email
address.

Can anyone recommend the best way to handle this type of thing? We'll have
to have a timely turn-around and we're pressed to do all sorts of tasks so
we really need to automate this somehow.

We'd greatly appreciate any advice.

Thank you! :blush:D
 
S

StargateFanFromWork

Hi, what I meant by that was that for those 306 messages, we'd still have to
open each one even if to just right-click to send to a personal address book
or contacts, or what have you.

Your vba sample sounds interesting but we definitely do _not_ need to
_always_ b.c.c. and address all the time. We would need to be able to
invoke a script, if there was such a thing, that would b.c.c. and address
_just_ a selection messages in a folder. We would also be willing to create
a temporary folder and to dump the message in it and then run a script to
b.c.c. the contents of said folder to a new message. That would be fine.
But none of the options mentioned on
http://www.slipstick.com/addins/mail.htm#compose seem to do anything
remotely like this.

Do you or anyone else know of anything that might? A script we write up
ourselves is preferable, too.

The only other suggestion recvd is to export to an Excel file, remove extra
info and to merge the data. Still seems tricky for the average Outlook user
here with potential of error that would not be present as if we used a
script.

Still, any insight appreciated. Thanks! :blush:D

Diane Poremsky said:
what do you mean by open each email to retrieve the addresses?

there is a VBA sample at outlookcode.com that will always bcc and address
and there are addins you can buy that do the same thing, but with better
control. http://www.slipstick.com/addins/mail.htm#compose

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/






StargateFanFromWork said:
Good Morning!

A colleague just came by my desk. Here at the office, we've received 306
emails so far that need responding to. The problem is that we'll be
receiving emails such as this over the next few days where we'll need to
respond to these public enquiries. We'll b.c.c. the public so that email
addresses are not visible to the recipients but my colleague was dismayed
and hoped he wouldn't have to open each message to retrieve the email
address.

Can anyone recommend the best way to handle this type of thing? We'll
have
to have a timely turn-around and we're pressed to do all sorts of tasks so
we really need to automate this somehow.

We'd greatly appreciate any advice.

Thank you! :blush:D
 
D

Diane Poremsky [MVP]

It sounds like you need two routines - one to save addresses to the contacts
folder and one for BCC.

This will do BCC - http://www.outlookcode.com/d/code/autobcc.htm. If you can
bunch the messages together to send, you can enable and disable the routine
as needed.

To add addresses to the contacts folder, you can try
http://www.outlookcode.com/d/code/autoaddrecip.htm or look for sample code
that you can run on a folder and save the addresses.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/






StargateFanFromWork said:
Hi, what I meant by that was that for those 306 messages, we'd still have
to
open each one even if to just right-click to send to a personal address
book
or contacts, or what have you.

Your vba sample sounds interesting but we definitely do _not_ need to
_always_ b.c.c. and address all the time. We would need to be able to
invoke a script, if there was such a thing, that would b.c.c. and address
_just_ a selection messages in a folder. We would also be willing to
create
a temporary folder and to dump the message in it and then run a script to
b.c.c. the contents of said folder to a new message. That would be fine.
But none of the options mentioned on
http://www.slipstick.com/addins/mail.htm#compose seem to do anything
remotely like this.

Do you or anyone else know of anything that might? A script we write up
ourselves is preferable, too.

The only other suggestion recvd is to export to an Excel file, remove
extra
info and to merge the data. Still seems tricky for the average Outlook
user
here with potential of error that would not be present as if we used a
script.

Still, any insight appreciated. Thanks! :blush:D

Diane Poremsky said:
what do you mean by open each email to retrieve the addresses?

there is a VBA sample at outlookcode.com that will always bcc and address
and there are addins you can buy that do the same thing, but with better
control. http://www.slipstick.com/addins/mail.htm#compose

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/






StargateFanFromWork said:
Good Morning!

A colleague just came by my desk. Here at the office, we've received 306
emails so far that need responding to. The problem is that we'll be
receiving emails such as this over the next few days where we'll need
to
respond to these public enquiries. We'll b.c.c. the public so that email
addresses are not visible to the recipients but my colleague was dismayed
and hoped he wouldn't have to open each message to retrieve the email
address.

Can anyone recommend the best way to handle this type of thing? We'll
have
to have a timely turn-around and we're pressed to do all sorts of tasks so
we really need to automate this somehow.

We'd greatly appreciate any advice.

Thank you! :blush:D
 
S

StargateFanFromWork

I'll send this to my IT people. No way can I figure this out on my own.
But in this case, as it's for the team, they'll be able to handle this.

One last question, I noticed a couple of different versions of Outlook.
Will these codes work in Outlook 2000?

Thanks! :blush:D

Diane Poremsky said:
It sounds like you need two routines - one to save addresses to the contacts
folder and one for BCC.

This will do BCC - http://www.outlookcode.com/d/code/autobcc.htm. If you can
bunch the messages together to send, you can enable and disable the routine
as needed.

To add addresses to the contacts folder, you can try
http://www.outlookcode.com/d/code/autoaddrecip.htm or look for sample code
that you can run on a folder and save the addresses.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/






StargateFanFromWork said:
Hi, what I meant by that was that for those 306 messages, we'd still have
to
open each one even if to just right-click to send to a personal address
book
or contacts, or what have you.

Your vba sample sounds interesting but we definitely do _not_ need to
_always_ b.c.c. and address all the time. We would need to be able to
invoke a script, if there was such a thing, that would b.c.c. and address
_just_ a selection messages in a folder. We would also be willing to
create
a temporary folder and to dump the message in it and then run a script to
b.c.c. the contents of said folder to a new message. That would be fine.
But none of the options mentioned on
http://www.slipstick.com/addins/mail.htm#compose seem to do anything
remotely like this.

Do you or anyone else know of anything that might? A script we write up
ourselves is preferable, too.

The only other suggestion recvd is to export to an Excel file, remove
extra
info and to merge the data. Still seems tricky for the average Outlook
user
here with potential of error that would not be present as if we used a
script.

Still, any insight appreciated. Thanks! :blush:D

Diane Poremsky said:
what do you mean by open each email to retrieve the addresses?

there is a VBA sample at outlookcode.com that will always bcc and address
and there are addins you can buy that do the same thing, but with better
control. http://www.slipstick.com/addins/mail.htm#compose

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/






Good Morning!

A colleague just came by my desk. Here at the office, we've received 306
emails so far that need responding to. The problem is that we'll be
receiving emails such as this over the next few days where we'll need
to
respond to these public enquiries. We'll b.c.c. the public so that email
addresses are not visible to the recipients but my colleague was dismayed
and hoped he wouldn't have to open each message to retrieve the email
address.

Can anyone recommend the best way to handle this type of thing? We'll
have
to have a timely turn-around and we're pressed to do all sorts of
tasks
so
we really need to automate this somehow.

We'd greatly appreciate any advice.

Thank you! :blush:D
 
D

Diane Poremsky [MVP]

I think so - if they don't, you can post a question about it on the
outlookcode.com forum.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/






StargateFanFromWork said:
I'll send this to my IT people. No way can I figure this out on my own.
But in this case, as it's for the team, they'll be able to handle this.

One last question, I noticed a couple of different versions of Outlook.
Will these codes work in Outlook 2000?

Thanks! :blush:D

Diane Poremsky said:
It sounds like you need two routines - one to save addresses to the contacts
folder and one for BCC.

This will do BCC - http://www.outlookcode.com/d/code/autobcc.htm. If you can
bunch the messages together to send, you can enable and disable the routine
as needed.

To add addresses to the contacts folder, you can try
http://www.outlookcode.com/d/code/autoaddrecip.htm or look for sample
code
that you can run on a folder and save the addresses.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/






StargateFanFromWork said:
Hi, what I meant by that was that for those 306 messages, we'd still have
to
open each one even if to just right-click to send to a personal address
book
or contacts, or what have you.

Your vba sample sounds interesting but we definitely do _not_ need to
_always_ b.c.c. and address all the time. We would need to be able to
invoke a script, if there was such a thing, that would b.c.c. and address
_just_ a selection messages in a folder. We would also be willing to
create
a temporary folder and to dump the message in it and then run a script to
b.c.c. the contents of said folder to a new message. That would be fine.
But none of the options mentioned on
http://www.slipstick.com/addins/mail.htm#compose seem to do anything
remotely like this.

Do you or anyone else know of anything that might? A script we write
up
ourselves is preferable, too.

The only other suggestion recvd is to export to an Excel file, remove
extra
info and to merge the data. Still seems tricky for the average Outlook
user
here with potential of error that would not be present as if we used a
script.

Still, any insight appreciated. Thanks! :blush:D

what do you mean by open each email to retrieve the addresses?

there is a VBA sample at outlookcode.com that will always bcc and address
and there are addins you can buy that do the same thing, but with better
control. http://www.slipstick.com/addins/mail.htm#compose

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/






Good Morning!

A colleague just came by my desk. Here at the office, we've
received
306
emails so far that need responding to. The problem is that we'll be
receiving emails such as this over the next few days where we'll
need
to
respond to these public enquiries. We'll b.c.c. the public so that
email
addresses are not visible to the recipients but my colleague was
dismayed
and hoped he wouldn't have to open each message to retrieve the
email
address.

Can anyone recommend the best way to handle this type of thing? We'll
have
to have a timely turn-around and we're pressed to do all sorts of tasks
so
we really need to automate this somehow.

We'd greatly appreciate any advice.

Thank you! :blush:D
 
S

StargateFanFromWork

Thanks! :blush:D

Diane Poremsky said:
I think so - if they don't, you can post a question about it on the
outlookcode.com forum.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/






StargateFanFromWork said:
I'll send this to my IT people. No way can I figure this out on my own.
But in this case, as it's for the team, they'll be able to handle this.

One last question, I noticed a couple of different versions of Outlook.
Will these codes work in Outlook 2000?

Thanks! :blush:D

Diane Poremsky said:
It sounds like you need two routines - one to save addresses to the contacts
folder and one for BCC.

This will do BCC - http://www.outlookcode.com/d/code/autobcc.htm. If
you
can
bunch the messages together to send, you can enable and disable the routine
as needed.

To add addresses to the contacts folder, you can try
http://www.outlookcode.com/d/code/autoaddrecip.htm or look for sample
code
that you can run on a folder and save the addresses.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/






Hi, what I meant by that was that for those 306 messages, we'd still have
to
open each one even if to just right-click to send to a personal address
book
or contacts, or what have you.

Your vba sample sounds interesting but we definitely do _not_ need to
_always_ b.c.c. and address all the time. We would need to be able to
invoke a script, if there was such a thing, that would b.c.c. and address
_just_ a selection messages in a folder. We would also be willing to
create
a temporary folder and to dump the message in it and then run a
script
to
b.c.c. the contents of said folder to a new message. That would be fine.
But none of the options mentioned on
http://www.slipstick.com/addins/mail.htm#compose seem to do anything
remotely like this.

Do you or anyone else know of anything that might? A script we write
up
ourselves is preferable, too.

The only other suggestion recvd is to export to an Excel file, remove
extra
info and to merge the data. Still seems tricky for the average Outlook
user
here with potential of error that would not be present as if we used a
script.

Still, any insight appreciated. Thanks! :blush:D

what do you mean by open each email to retrieve the addresses?

there is a VBA sample at outlookcode.com that will always bcc and address
and there are addins you can buy that do the same thing, but with better
control. http://www.slipstick.com/addins/mail.htm#compose

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/






Good Morning!

A colleague just came by my desk. Here at the office, we've
received
306
emails so far that need responding to. The problem is that we'll be
receiving emails such as this over the next few days where we'll
need
to
respond to these public enquiries. We'll b.c.c. the public so that
email
addresses are not visible to the recipients but my colleague was
dismayed
and hoped he wouldn't have to open each message to retrieve the
email
address.

Can anyone recommend the best way to handle this type of thing? We'll
have
to have a timely turn-around and we're pressed to do all sorts of tasks
so
we really need to automate this somehow.

We'd greatly appreciate any advice.

Thank you! :blush:D
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top