Create "Record/Form" from fields in email

  • Thread starter Thread starter Funkybassman
  • Start date Start date
F

Funkybassman

Our department is receiving an Email each tim a "Customer" fills in
form online. Each item on the web page is converted to a field and sen
on a single line of text i.e.

dateofbooking: 29/01/2009
journeydate1: 30/01/2009
departuretime1: 1643

As the resulting email is long and difficult to read I would like to b
able to put it into a more readable format, even recreate the origina
form.

I Assume It will need to be a macro or visual basic. I will be using
bog standard installation of Outlook 2003 ... I will not be able t
install any other software/plugin so needs to be a MS office thin
only

Any help would be greatfully appreciate
 
Thanks for taking the time to reply

I guess I need some help in pointing me in the right direction ... Don
some VB6 programming with Databases several years ago and need some ide
as to the best way to turn the email into somthing more readable I wa
thinking Id need to convert each of the lines of text into a field in
temporary database record then create a form and use the record filed
to populate this.

Not sure what to do first

T on Y


'Michael Bauer [MVP - Outlook said:
;290328']What's your question?

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Wed, 4 Feb 2009 22:19:45 +0000 schrieb Funkybassman:
-
Our department is receiving an Email each tim a "Customer" fills in a
form online. Each item on the web page is converted to a field an
sent
on a single line of text i.e.

dateofbooking: 29/01/2009
journeydate1: 30/01/2009
departuretime1: 1643

As the resulting email is long and difficult to read I would like t
be
able to put it into a more readable format, even recreate th
original
form.

I Assume It will need to be a macro or visual basic. I will be usin
a
bog standard installation of Outlook 2003 ... I will not be able to
install any other software/plugin so needs to be a MS office thing
only

Any help would be greatfully appreciated
Click to expand...
 
I think you need to decide first what a "more readable" format is. For
instance, you could create an HTML file, export it to Excel, or to Access.
Do you want to do more with the data?

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Sat, 7 Feb 2009 10:36:02 +0000 schrieb Funkybassman:
Thanks for taking the time to reply

I guess I need some help in pointing me in the right direction ... Done
some VB6 programming with Databases several years ago and need some idea
as to the best way to turn the email into somthing more readable I was
thinking Id need to convert each of the lines of text into a field in a
temporary database record then create a form and use the record fileds
to populate this.

Not sure what to do first

T on Y


'Michael Bauer [MVP - Outlook said:
;290328']What's your question?

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Wed, 4 Feb 2009 22:19:45 +0000 schrieb Funkybassman:
-
Our department is receiving an Email each tim a "Customer" fills in a
form online. Each item on the web page is converted to a field and
sent
on a single line of text i.e.

dateofbooking: 29/01/2009
journeydate1: 30/01/2009
departuretime1: 1643

As the resulting email is long and difficult to read I would like to
be
able to put it into a more readable format, even recreate the
original
form.

I Assume It will need to be a macro or visual basic. I will be using
a
bog standard installation of Outlook 2003 ... I will not be able to
install any other software/plugin so needs to be a MS office thing
only

Any help would be greatfully appreciated-
Click to expand...
Click to expand...
 
"I think you need to decide first what a "more readable" format is."

The answer is "Anything that is better than what we get". At presen
the E-Mail Contains 68 lines of text each of which is a uniqe field
and the whole thing is difficult to read, I was assuming I coul
recreate the web form as a VBA From and populate the text boxes wit
fields from the email.

"For instance, you could create an HTML file, export it to Excel, or t
Access."

Whatever is done needs to be very easy to use by some very "Uncompute
Literate" people in our department, this is why I assumed a VBA for
within outlook

"Do you want to do more with the data?"

No, the original data is stored somewhere else in the country!! (No, w
dont have access to it which is why we get the Email) and we dont nee
to keep it

Hope this makes sense

T on
 
"Anything that is better than what we get"

That's subjective. I'm sorry, I can't help for this.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Sun, 8 Feb 2009 16:30:01 +0000 schrieb Funkybassman:
 
Back
Top