event managment

Phil · Joined: 26 Feb 2008 Posts: 2

We have a non-profit summer school for about 500 pupils. We have an online form on our website which emails us sign-up details in the format:

SURNAME:
dskfjkds

NAME:
hsahdjkashd

AGE:
12

ADDRESS:
fdsfjhdsjkf

jdshfjkdshf

jdsfkljdsklfj

and lots more info, like parent's names, contact details, transport details, lunches, allergies, payements, etc. We could just print it, but it is really messy because the information doesn't fit on one page and the font is too small. Plus, once it's on paper it can't be manipulated further.

So, what smart things can Outlook 2002 do with that sort of email body? Can we put that into an Outlook contact form or address book form without copy/pasting it? Can we get it into a datbase?

For the life of me, I can't see what Outlook can do with the information in the email body, unless I pay an extortionate amount of money for a plugin which parses the email?

Also, I discovered that the email addresses supplied in the body cannot be clicked on and added to a contact/address book. Is that normal? The 'from' field has to be mailto:website@ourdomain.com, so we need to easily retrieve the users address from the body of the messege; any ideas?

Cheers

Archived from group: microsoft>public>outlook>general

dlw · Joined: 12 Aug 2007 Posts: 24

those on-line forms are usually storing the data in some sort of backend
database format, maybe you can get it from there instead of the body of the
email?
If not, you really need to do that in the future, the format you are getting
it in is not very useable.

"Phil" wrote:

>
> We have a non-profit summer school for about 500 pupils. We have an online form on our website which emails us sign-up details in the format:
>
> SURNAME:
> dskfjkds
>
> NAME:
> hsahdjkashd
>
> AGE:
> 12
>
> ADDRESS:
> fdsfjhdsjkf
>
> jdshfjkdshf
>
> jdsfkljdsklfj
>
> and lots more info, like parent's names, contact details, transport details, lunches, allergies, payements, etc. We could just print it, but it is really messy because the information doesn't fit on one page and the font is too small. Plus, once it's on paper it can't be manipulated further.
>
> So, what smart things can Outlook 2002 do with that sort of email body? Can we put that into an Outlook contact form or address book form without copy/pasting it? Can we get it into a datbase?
>
> For the life of me, I can't see what Outlook can do with the information in the email body, unless I pay an extortionate amount of money for a plugin which parses the email?
>
> Also, I discovered that the email addresses supplied in the body cannot be clicked on and added to a contact/address book. Is that normal? The 'from' field has to be mailto:website@ourdomain.com, so we need to easily retrieve the users address from the body of the messege; any ideas?
>
> Cheers
>

Phil · Joined: 26 Feb 2008 Posts: 2

> maybe you can get it from there instead of the body of the
email?

Thanks for your reply.

If I did find a way to get the web-form information stored into an SQL database (I'd need to learn some php to do that I think), could Outlook then connect to the database and copy the data into one of its own custom forms?

Cheers.

Outlook event reminders Hello, I have a siuation where one of our users creates a reoccuring event and when the reminder comes up before the event the user will either dismiss or snooze the event. The event will initally dissappear but within a minute the reminder is back. We ha

Prevent an event loop when saving Task item in event handler I'm using the event handler code below to modify the Subject of a Task whenever I manually change its Due Date. The Save method in the code triggers another ItemChange event. I use a boolean public variable to avoid an event loop (examples in VBA help d

BeforeDelete Event Hi everybody, I want to execute some code before a contact item will be deleted. This is my code: Sub MsgBox "Test" End Sub But it doesn't function, because there is no message box. Why? Regards Daniel

ItemSend Event Dear Friends, I have the following question: I use OL2003 and have 3 email accounts. What I need to do is to move the sent email to a subfolde based on the account I am using. Is this possible with ItemSend Event or there is any other solution? How can I

Calendar Event Hello All, I'm trying to do the following: I want to be able to trap a new appointment BEFORE it gets saved (after user selects save). The point is to be able to add some logic to what can go in a calendar. The Outlook object model doesn't appear to have