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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|