PC Review
Forums
Newsgroups
Microsoft Outlook
Microsoft Outlook VBA Programming
Web Form -to- New Contact
Forums
Newsgroups
Microsoft Outlook
Microsoft Outlook VBA Programming
Web Form -to- New Contact
![]() |
Web Form -to- New Contact |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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) |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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) |
|
|
|
#3 |
|
Guest
Posts: n/a
|
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) > |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

