Outlook 2007
(1)
Outlook
(1)
Excel
(1)
Vista
(1)
VBA
(1)
AddressGrabber
(1)
ContactGenie
(1)
QuickPort
(1)

Need quick way to build distribution list

Asked By Scott Rucci
04-Feb-10 11:50 AM
Hi. I need to build a distribution list quickly which has as it is
members people sending me emails (people not currently in my
contacts). But the emails are not 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

You'll have to write your own VBA code or search the Internet for

Brian Tillman [MVP-Outlook] replied to Scott Rucci
04-Feb-10 01:29 PM
You'll have to write your own VBA code or search the Internet for address
harvesters for Outlook.  Outlook itself does not have the ability.
--
Brian Tillman [MVP-Outlook]

You may want to take a look at the products offered by the folks athttp://www.

Karl Timmermans replied to Scott Rucci
04-Feb-10 02:48 PM
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
http://www.contactgenie.com

You'll need to use a utility or VBA. Seehttp://www.slipstick.

Diane Poremsky [MVP] replied to Scott Rucci
04-Feb-10 10:01 PM
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:
mailto:dailytips-subscribe-request@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

How many email accounts are in your main Outlook profile?
http://forums.slipstick.com/showthread.php?t=36602
ontacts_entry.aspfor utilities.ipstick.com/showthread.php?
Scott Rucci replied to Diane Poremsky [MVP]
08-Feb-10 10:59 AM
ontacts_entry.aspfor utilities.
ipstick.com/showthread.php?t=3D36602

Thanks for your responses.

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

Diane-
I have 4001 contacts in my main Outlook profile.
If I understand correctly, the addresses you need are in the message
Diane Poremsky [MVP] replied to Scott Rucci
08-Feb-10 12:30 PM
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 are 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:dailytips-subscribe-request@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

How many email accounts are in your main Outlook profile?
http://forums.slipstick.com/showthread.php?t=36602
,lOpen=A0Ifhouldurnipstick.com/showthread.php?
Scott Rucci replied to Diane Poremsky [MVP]
13-Feb-10 12:22 PM
,
l
Open
=A0If
hould
urn
ipstick.com/showthread.php?t=3D36602
.
re

Those are great suggestions, thank you very much.
Post Question To EggHeadCafe