PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook VBA Programming Web Form -to- New Contact

Reply

Web Form -to- New Contact

 
Thread Tools Rate Thread
Old 10-11-2005, 11:38 PM   #1
=?Utf-8?B?WklMTEE=?=
Guest
 
Posts: n/a
Default Web Form -to- New Contact


Hello all,
Thanks to Sue Mosher for the script to create a new contact from all sent
emails. Works like a charm, but it's not exactly what I'm looking for.

I have a web form that has specific data, and when submitted, it is sent to
me as a plain-text email. It seems as though I have found bits and pieces to
assemble the code, but just not everything all together.

What I would like is to *create a new contact* only from these emails, which
are recieved in one *specific account*, and with the data that's entered into
the subject and body of the email.

EXAMPLE:
Submitted web form arrives as plain text email.
sent to <sched@mysite.com>
Submitter's name is assigned to the "Subject" of the email so:
Full Name = "Subject"
Other data is present in the body of the email so:
Email1 = SubmitterEmail:
Email2 = BrideEmail:
Email3 = GroomEmail:
HomePhone = SubmitterPhone:
HomePhone2 = BridePhone:
BusinessPhone = ChurchPhone:
BusinessPhone2 = HallPhone:
BusinessAddress = ChurchAddress:
BusinessAddress2 = HallAddress:
(Etc.)

A few other things would round it out nicely:
1. Copy the entire body of the email to the Notes section of the
contact form.
2. Assign a Category to the contact.
3. Save it in a special Contacts Folder.

This seems like a tall order for a forum such as this. Let me know if this
is "Over The Top". Meanwhile, thankyou for considering this request.
ZILLA

--
The world is like a book, and those that never leave home read but one page.
St. Augustine of Hippo (354-430)
  Reply With Quote
Old 11-11-2005, 02:47 PM   #2
Sue Mosher [MVP-Outlook]
Guest
 
Posts: n/a
Default Re: Web Form -to- New Contact

All the pieces to do that are readily available:

1) http://www.outlookcode.com/d/code/zaphtml.htm for ways to work with incoming items]

2) http://www.outlookcode.com/codedetail.aspx?id=89 for a technique to extract data from a structured text block

3) the Application.CreateItem method to create a new contact or MAPIFolder.Items.Add to add it to a non-default contacts folder (see http://www.outlookcode.com/d/code/getfolder.htm for a procedure to walk the folder tree)

4) http://www.outlookcode.com/d/propsyntax.htm for a primer on working with Outlook item properties.

All you need to do is assemble those building blocks together to fit your particular scenario.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"ZILLA" <ZILLA@discussions.microsoft.com> wrote in message news:F8309E6D-C044-42BA-8F04-764A83D76713@microsoft.com...
> Hello all,
> Thanks to Sue Mosher for the script to create a new contact from all sent
> emails. Works like a charm, but it's not exactly what I'm looking for.
>
> I have a web form that has specific data, and when submitted, it is sent to
> me as a plain-text email. It seems as though I have found bits and pieces to
> assemble the code, but just not everything all together.
>
> What I would like is to *create a new contact* only from these emails, which
> are recieved in one *specific account*, and with the data that's entered into
> the subject and body of the email.
>
> EXAMPLE:
> Submitted web form arrives as plain text email.
> sent to <sched@mysite.com>
> Submitter's name is assigned to the "Subject" of the email so:
> Full Name = "Subject"
> Other data is present in the body of the email so:
> Email1 = SubmitterEmail:
> Email2 = BrideEmail:
> Email3 = GroomEmail:
> HomePhone = SubmitterPhone:
> HomePhone2 = BridePhone:
> BusinessPhone = ChurchPhone:
> BusinessPhone2 = HallPhone:
> BusinessAddress = ChurchAddress:
> BusinessAddress2 = HallAddress:
> (Etc.)
>
> A few other things would round it out nicely:
> 1. Copy the entire body of the email to the Notes section of the
> contact form.
> 2. Assign a Category to the contact.
> 3. Save it in a special Contacts Folder.
>
> This seems like a tall order for a forum such as this. Let me know if this
> is "Over The Top". Meanwhile, thankyou for considering this request.
> ZILLA
>
> --
> The world is like a book, and those that never leave home read but one page.
> St. Augustine of Hippo (354-430)

  Reply With Quote
Old 11-11-2005, 04:51 PM   #3
=?Utf-8?B?WklMTEE=?=
Guest
 
Posts: n/a
Default Re: Web Form -to- New Contact

Just call me "LT" ... Learning Things. OK, I guess it's time to really dive
in. I'm up to my ankles and already over my head.

Seriously, thanks Sue for your generosity. My research on this subject has
taken my to a lot of places, and I think you've contributed to every one of
them. You, are a gift.

Let's see if I can get the pieces of the puzzle together.
ZILLA
--
The world is like a book, and those that never leave home read but one page.
St. Augustine of Hippo (354-430)


"Sue Mosher [MVP-Outlook]" wrote:

> All the pieces to do that are readily available:
>
> 1) http://www.outlookcode.com/d/code/zaphtml.htm for ways to work with incoming items]
>
> 2) http://www.outlookcode.com/codedetail.aspx?id=89 for a technique to extract data from a structured text block
>
> 3) the Application.CreateItem method to create a new contact or MAPIFolder.Items.Add to add it to a non-default contacts folder (see http://www.outlookcode.com/d/code/getfolder.htm for a procedure to walk the folder tree)
>
> 4) http://www.outlookcode.com/d/propsyntax.htm for a primer on working with Outlook item properties.
>
> All you need to do is assemble those building blocks together to fit your particular scenario.
>
> --
> Sue Mosher, Outlook MVP
> Author of Configuring Microsoft Outlook 2003
> http://www.turtleflock.com/olconfig/index.htm
> and Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "ZILLA" <ZILLA@discussions.microsoft.com> wrote in message news:F8309E6D-C044-42BA-8F04-764A83D76713@microsoft.com...
> > Hello all,
> > Thanks to Sue Mosher for the script to create a new contact from all sent
> > emails. Works like a charm, but it's not exactly what I'm looking for.
> >
> > I have a web form that has specific data, and when submitted, it is sent to
> > me as a plain-text email. It seems as though I have found bits and pieces to
> > assemble the code, but just not everything all together.
> >
> > What I would like is to *create a new contact* only from these emails, which
> > are recieved in one *specific account*, and with the data that's entered into
> > the subject and body of the email.
> >
> > EXAMPLE:
> > Submitted web form arrives as plain text email.
> > sent to <sched@mysite.com>
> > Submitter's name is assigned to the "Subject" of the email so:
> > Full Name = "Subject"
> > Other data is present in the body of the email so:
> > Email1 = SubmitterEmail:
> > Email2 = BrideEmail:
> > Email3 = GroomEmail:
> > HomePhone = SubmitterPhone:
> > HomePhone2 = BridePhone:
> > BusinessPhone = ChurchPhone:
> > BusinessPhone2 = HallPhone:
> > BusinessAddress = ChurchAddress:
> > BusinessAddress2 = HallAddress:
> > (Etc.)
> >
> > A few other things would round it out nicely:
> > 1. Copy the entire body of the email to the Notes section of the
> > contact form.
> > 2. Assign a Category to the contact.
> > 3. Save it in a special Contacts Folder.
> >
> > This seems like a tall order for a forum such as this. Let me know if this
> > is "Over The Top". Meanwhile, thankyou for considering this request.
> > ZILLA
> >
> > --
> > The world is like a book, and those that never leave home read but one page.
> > St. Augustine of Hippo (354-430)

>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off