Need quick way to build distribution list

S

Scott Rucci

Hi. I need to build a distribution list quickly which has as it's
members people sending me emails (people not currently in my
contacts). But the emails aren't coming from the individuals, they are
coming from a form on my website.

So
- all the emails come from the same address (my web form)
- all emails are formatted the same
- all contain an email address for someone who filled out the form

I'd like some kind of drag and drop or automated way to "dump" all
those addressed into a list so I can reply to them en masse.

Anyone know of a way to do this using Outlook? Thanks in advance.

HP m7760n
core2 6400 2.13GHz, 3 GB RAM
Win Vista Home Premium SP2
Outlook 2007 (12.0.6514.5000) SP2
 
B

Brian Tillman [MVP-Outlook]

Hi. I need to build a distribution list quickly which has as it's
members people sending me emails (people not currently in my
contacts). But the emails aren't coming from the individuals, they are
coming from a form on my website.

So
- all the emails come from the same address (my web form)
- all emails are formatted the same
- all contain an email address for someone who filled out the form

I'd like some kind of drag and drop or automated way to "dump" all
those addressed into a list so I can reply to them en masse.

Anyone know of a way to do this using Outlook? Thanks in advance.

You'll have to write your own VBA code or search the Internet for address
harvesters for Outlook. Outlook itself doesn't have the ability.
 
K

Karl Timmermans

You may want to take a look at the products offered by the folks at
http://www.egrabber.com (AddressGrabber in particular)

Karl--
____________________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - QuickPort/DataPort/Exporter/Toolkit/Duplicate Contact Mgr
"Contact import/export/data management tools for Outlook '2000/2010"
http://www.contactgenie.com
 
S

Scott Rucci

You'll need to use a utility or VBA. Seehttp://www.slipstick.com/addins/contacts_entry.aspfor utilities.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips:http://www.outlook-tips.net/
Outlook & Exchange Solutions Center:http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

How many email accounts are in your main Outlook profile?http://forums.slipstick.com/showthread.php?t=36602




Hi. I need to build a distribution list quickly which has as it's
members people sending me emails (people not currently in my
contacts). But the emails aren't coming from the individuals, they are
coming from a form on my website.
So
- all the emails come from the same address (my web form)
- all emails are formatted the same
- all contain an email address for someone who filled out the form
I'd like some kind of drag and drop or automated way to "dump" all
those addressed into a list so I can reply to them en masse.
Anyone know of a way to do this using Outlook? Thanks in advance.
HP m7760n
core2 6400 2.13GHz, 3 GB RAM
Win Vista Home Premium SP2
Outlook 2007 (12.0.6514.5000) SP2- Hide quoted text -

- Show quoted text -

Thanks for your responses.

Karl-
I have used Outlook grabber in the past, but I'm not sure it would
have the level of automation I need. Have to investigate. I looks like
leads Grabber might, but it's a $300 software, can't do that.

Diane-
I have 4001 contacts in my main Outlook profile.
 
D

Diane Poremsky [MVP]

If I understand correctly, the addresses you need are in the message body,
correct?

How are your excel and word skills? You could dump the messages into excel
and grab the addresses. I'd start with select all, file, save as txt. Open
the text file in Excel. If you are lucky (and the messages are short and
sweet) you can do a sort and all the addresses will be grouped together. If
you're unlucky, try using formulas to pull the addresses into a column or
use macros in word to remove/replace the extra text. Either of these should
work - but if this is going to be an ongoing project, leads grabber may turn
out to be a good investment.


--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

How many email accounts are in your main Outlook profile?
http://forums.slipstick.com/showthread.php?t=36602

Scott Rucci said:
You'll need to use a utility or VBA.
Seehttp://www.slipstick.com/addins/contacts_entry.aspfor utilities.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips:http://www.outlook-tips.net/
Outlook & Exchange Solutions Center:http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

How many email accounts are in your main Outlook
profile?http://forums.slipstick.com/showthread.php?t=36602




Hi. I need to build a distribution list quickly which has as it's
members people sending me emails (people not currently in my
contacts). But the emails aren't coming from the individuals, they are
coming from a form on my website.
So
- all the emails come from the same address (my web form)
- all emails are formatted the same
- all contain an email address for someone who filled out the form
I'd like some kind of drag and drop or automated way to "dump" all
those addressed into a list so I can reply to them en masse.
Anyone know of a way to do this using Outlook? Thanks in advance.
HP m7760n
core2 6400 2.13GHz, 3 GB RAM
Win Vista Home Premium SP2
Outlook 2007 (12.0.6514.5000) SP2- Hide quoted text -

- Show quoted text -

Thanks for your responses.

Karl-
I have used Outlook grabber in the past, but I'm not sure it would
have the level of automation I need. Have to investigate. I looks like
leads Grabber might, but it's a $300 software, can't do that.

Diane-
I have 4001 contacts in my main Outlook profile.
 
S

Scott Rucci

If I understand correctly, the addresses you need are in the message body,
correct?

How are your excel and word skills? You could dump the messages into excel
and grab the addresses.  I'd start with select all, file, save as txt. Open
the text file in Excel. If you are lucky (and the messages are short and
sweet) you can do a sort and all the addresses will be grouped together.  If
you're unlucky, try using formulas to pull the addresses into a column or
use macros in word to remove/replace the extra text.  Either of these should
work - but if this is going to be an ongoing project, leads grabber may turn
out to be a good investment.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips:http://www.outlook-tips.net/
Outlook & Exchange Solutions Center:http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

How many email accounts are in your main Outlook profile?http://forums.slipstick.com/showthread.php?t=36602




You'll need to use a utility or VBA.
Seehttp://www.slipstick.com/addins/contacts_entry.aspforutilities.
--
Diane Poremsky [MVP - Outlook]
Outlook Tips:http://www.outlook-tips.net/
Outlook & Exchange Solutions Center:http://www.slipstick.com/
Outlook Tips by email:
mailto:[email protected]
EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]
How many email accounts are in your main Outlook
profile?http://forums.slipstick.com/showthread.php?t=36602

Hi. I need to build a distribution list quickly which has as it's
members people sending me emails (people not currently in my
contacts). But the emails aren't coming from the individuals, they are
coming from a form on my website.
So
- all the emails come from the same address (my web form)
- all emails are formatted the same
- all contain an email address for someone who filled out the form
I'd like some kind of drag and drop or automated way to "dump" all
those addressed into a list so I can reply to them en masse.
Anyone know of a way to do this using Outlook? Thanks in advance.
HP m7760n
core2 6400 2.13GHz, 3 GB RAM
Win Vista Home Premium SP2
Outlook 2007 (12.0.6514.5000) SP2- Hide quoted text -
- Show quoted text -
Thanks for your responses.
Karl-
I have used Outlook grabber in the past, but I'm not sure it would
have the level of automation I need. Have to investigate. I looks like
leads Grabber might, but it's a $300 software, can't do that.
Diane-
I have 4001 contacts in my main Outlook profile.- Hide quoted text -

- Show quoted text -

Those are great suggestions, thank you very much.
 

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