Handling client data from web forms service

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I havea a client registration form on a web forms service. CLient data is
sent to me via email in plain text that looks like this:

*** Text Database Entry ***
"Your Name","Your Email Address","Your Boat's Name","Type of Vessel","Boat
Manufacturer","Length","Primary Boating Area","How did you hear about
Smile-123","Please Notify Me of All New Galleries Are Added"
"Mark Johnson","(e-mail address removed)","Reel Mistress","Cabin
Power","Proline","30\' and under","Good Luck Point -.Barnegat Inlet","Print
Advertisement","Yes, "



1. I don't need a full contact manager for this AND access is also overkill.
I My ultimate purpose is to have a list of boatnames to match to photos, send
proofs via email, send general annoucnements to clients who have asked for
them, track contacts so that I know if I have already snet a notification or
not, and for which photo. Which tool is going to be most appropriate?

2. In general, how do I get that data into a "database", i.e.access, excel,
or contact manager in outlook? I have written in VB before.
 
I havea a client registration form on a web forms service. CLient data is
sent to me via email in plain text that looks like this:

*** Text Database Entry ***
"Your Name","Your Email Address","Your Boat's Name","Type of Vessel","Boat
Manufacturer","Length","Primary Boating Area","How did you hear about
Smile-123","Please Notify Me of All New Galleries Are Added"
"Mark Johnson","(e-mail address removed)","Reel Mistress","Cabin
Power","Proline","30\' and under","Good Luck Point -.Barnegat Inlet","Print
Advertisement","Yes, "

1. I don't need a full contact manager for this AND access is also overkill.
I My ultimate purpose is to have a list of boatnames to match to photos, send
proofs via email, send general annoucnements to clients who have asked for
them, track contacts so that I know if I have already snet a notification or
not, and for which photo. Which tool is going to be most appropriate?

2. In general, how do I get that data into a "database", i.e.access, excel,
or contact manager in outlook? I have written in VB before.
Click to expand...

Outlook's VB is probably your best bet.

There should be plenty of examples of how to have a VB functions
respond to a new Email event.

When that happens you can check if its one of these emails based on
the From field. If so you can parse the text in the body of the email
to get the fields you want and then create a Business Contact,
populate the Name and email fields, set the Lead field to true, and
add the email to the new conatct's history.

That said, working in VB and interacting with Outlook's object model
is not trivial, so you may want to get some help.
 
Back
Top