Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming Add-Ins / April 2004

Tip: Looking for answers? Try searching our database.

Mining info from outlook emails

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mark Hill - 06 Apr 2004 23:23 GMT
Hi all;

I have a unique problem.
I own a web site with a "contact us" page with the following fields :

Name:
Company:
Email:
Fax:
Country:
Address:
Comments:

My clients fill in the contact page and the data is sent to me via email.
As a result, I now have 2000 contact emails, all in a single folder inside
Outlook 2K3.

I'd like to be able to create HTML product announcements and automatically
send them off to all the people in this contact folder.

I imagine it's possible to mine the information from these messages and
populate an outgoing message (Word etc) that would subsequently be sent via
email to the appropriate recipient.

Any suggestions other than hand typing them all into an Access database ?

Mark Hill
MarkHill@PAOnline.com
Judy Gleeson - 07 Apr 2004 01:34 GMT
Try email merging Outlook contact details.  Select the contacts you want to
mail (use the Phone List view and sort by the field you need e.g. Country)
The click Tools, Mailmerge.  Add to the bottom of the screen, then select
merge to email.  A subject field will appear at the bottom of the screen.
Put a subject in it.  Once you've done this, click OK.

Word will start up automatically.  Type Hi then select (firstname) from the
available merge fields.  You'll need the mailmerge toolbar showing.  Other
fields such as (company) can be added to your email letter.  There's an ABC
icon in Word that shows your merged data on screen. There's an icon to merge
to email.  Off it goes!

This is an easy way to merge to a bunch of people.  We can send an email to
all Training Managers in our city, who have Outlook, but aren't clients.
Then we select a different bunch of people and send a different email.  Just
make more Contacts fields to hold  the data you need to store about people.

Mark, test it internally so you know how it works!

Regards

Judy Gleeson
Acorn Training and Consulting

> Hi all;
>
[quoted text clipped - 24 lines]
> Mark Hill
> MarkHill@PAOnline.com
Mark Hill - 07 Apr 2004 14:48 GMT
Thanks for your help Judy, but I think you may have misunderstood my
request.

The contact info I have is not located in my contacts folder, it's contained
in individual emails from thousands of people who have filled in my web
based "contact us" form. Once they've filled in the form, my web site
automatically sends me the email containing all their info.
As a result, I have a folder with >2000 emails, each containing fields of
data as noted below.
My goal is to mine the data from each of these emails to create a
centralized database that I can use for mail-merge applications.

FYI .... I also have Outlook 2K3 Business Contact Manager installed, in
addition to all the tools associated with Office Pro 2K3.

Thanks again for your help.

Mark Hill

> Try email merging Outlook contact details.  Select the contacts you want to
> mail (use the Phone List view and sort by the field you need e.g. Country)
[quoted text clipped - 49 lines]
> > Mark Hill
> > MarkHill@PAOnline.com
Graeme - 08 Apr 2004 17:51 GMT
Hello Mark, outside the scope of this list but how is your webform set-up?

On the registration page on our website we send a mail with the form fields
(as per your example) but also save the details to a CSV file on the web
server. Every week we download the file and it is in a state ready for mail
merge.

Regards
Graeme
=====================================
Websetters - home of the WS:Outlook AddIn
the only limits are those of vision...
www.websetters.co.uk
=====================================

> Thanks for your help Judy, but I think you may have misunderstood my
> request.
[quoted text clipped - 79 lines]
> > > Mark Hill
> > > MarkHill@PAOnline.com
Mark Hill - 09 Apr 2004 20:44 GMT
Thanks Graeme

I'll ask my server group.
Maybe (hopefully) they'll have a nice CSV file that I can import.
Wouldn't that be nice !!!

Mark

> Hello Mark, outside the scope of this list but how is your webform set-up?
>
[quoted text clipped - 102 lines]
> > > > Mark Hill
> > > > MarkHill@PAOnline.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.