Can somebody tell me what I need?

[hendis]

Hi, everyone! TIA to anybody that can help...

I'm not sure that I'm in the right place, so I'm going to ask some kind
person to send me where I need to go to solve this problem...

I was given a project by the "powers that be" where I work. It seems
that when someone registers for our "giveaway" at our website, a form
is generated with the registrant's information in a 12-line table,
which is then emailed (as an attachment) to our marketing director. She
needs to extract one line (the email address of the registrant) from
that form. This would be a simple task if it was just one registration,
but we get several hundred a day.

Currently, I'm
opening each attachment
pasting the form into Word (Doc1)
converting the table to text (Table|Convert|TableToText)
pasting the needed info (email address) into Word (Doc2)
Repeat using next submission...

Needless to say, we've got a long, slow process. This wouldn't be bad
if we had 1 or 2 to take care of... but what about 375+?

We'd like to do this with software, if at all possible. It would even
be better if we could do this automatically within Outlook, since that
is the location where the emails are originally received. (We're using
OL 2002)

I'll be honest -- I don't know if I need to do this as a script, batch
file or macro initiated by Outlook rules or try to develop a standalone
program, or something else entirely.

I'd like a few suggestions, please...

Thanks

hendis

 

[Michael Bauer [MVP - Outlook]]

Am 15 Sep 2006 12:56:46 -0700 schrieb hendis:

For an Exchange environment you could write an Event Sink, for Outlook it
could also be some VBA methods.

The main point is, you need to be able to recognize the e-mail address. If
the mail looks like this e.g.:

....
e-mail: ...@....
.....

then you could search for "e-mail: " with the Instr function. the function
returns the start position; add its length then you have the start position
of the following address. From that position on search for the end of the
line (the vbCRLF characters) with Instr again. Now you can calculate the
length of the e-mail address and extract it with the Mid function.

 

[Sue Mosher [MVP-Outlook]]

You could do this with an Outlook add-in or VBA code or any number of other methods, I'm sure. See http://www.outlookcode.com/d/code/zaphtml.htm for various ways to process incoming messages and http://www.outlookcode.com/codedetail.aspx?id=89 for a sample of extracting text from a structured text block.

If you want to look at off-the-shelf tools, see http://www.slipstick.com/addins/extract.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers