A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need quick way to build distribution list



 
 
Thread Tools Display Modes
  #1  
Old February 4th, 2010, 03:37 PM posted to microsoft.public.outlook.contacts
Scott Rucci
external usenet poster
 
Posts: 3
Default Need quick way to build distribution list

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
  #2  
Old February 4th, 2010, 06:29 PM posted to microsoft.public.outlook.contacts
Brian Tillman [MVP-Outlook]
external usenet poster
 
Posts: 2,485
Default Need quick way to build distribution list

"Scott Rucci" wrote in message
...

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.
--
Brian Tillman [MVP-Outlook]

  #3  
Old February 4th, 2010, 07:48 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 682
Default Need quick way to build distribution list

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

"Scott Rucci" wrote in message
...
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



  #4  
Old February 5th, 2010, 03:01 AM posted to microsoft.public.outlook.contacts
Diane Poremsky [MVP]
external usenet poster
 
Posts: 17,338
Default Need quick way to build distribution list

You'll need to use a utility or VBA. See
http://www.slipstick.com/addins/contacts_entry.asp for utilities.

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

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


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

"Scott Rucci" wrote in message
...
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


  #5  
Old February 8th, 2010, 03:59 PM posted to microsoft.public.outlook.contacts
Scott Rucci
external usenet poster
 
Posts: 3
Default Need quick way to build distribution list

On Feb 4, 10:01*pm, "Diane Poremsky [MVP]" wrote:
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:


EMO - a weekly newsletter about Outlook and Exchange:


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

"Scott Rucci" wrote in message

...



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.
  #6  
Old February 8th, 2010, 05:30 PM posted to microsoft.public.outlook.contacts
Diane Poremsky [MVP]
external usenet poster
 
Posts: 17,338
Default Need quick way to build distribution list

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:


EMO - a weekly newsletter about Outlook and Exchange:


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

"Scott Rucci" wrote in message
...
On Feb 4, 10:01 pm, "Diane Poremsky [MVP]" wrote:
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:


EMO - a weekly newsletter about Outlook and Exchange:


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

"Scott Rucci" wrote in message

...



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.


  #7  
Old February 13th, 2010, 05:22 PM posted to microsoft.public.outlook.contacts
Scott Rucci
external usenet poster
 
Posts: 3
Default Need quick way to build distribution list

On Feb 8, 12:30*pm, "Diane Poremsky [MVP]" wrote:
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:


EMO - a weekly newsletter about Outlook and Exchange:


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

"Scott Rucci" wrote in message

...



On Feb 4, 10:01 pm, "Diane Poremsky [MVP]" wrote:
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:


EMO - a weekly newsletter about Outlook and Exchange:


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


"Scott Rucci" wrote in message


....


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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.