Extract values and paste it in fields

[john]

In an app I would like the user to be able to paste a Groupwise message into
several fields of a record. Since Groupwise doesn't offer good save-as or
export-options, the easiest way is that the user selects the whole message
in the Groupwise viewer and copies it to the clipboard. As an example, the
following text would be on the clipboard:

<<<
From: Cleef, R. van
To: Jack Mapel
Date: 14-09-06 12:17
Subject: RE: Betr.: Access question

Dear Jack, bla bla bla...

>>>

I would like to make a button in my form that:
1. reads the clipboard value
2. pastes "Cleef, R. van" in the field "From"
3. pastes "Jack Mapel" in the "To" field
4. etc. for Date, Subjecte, and Message.

What would be the best way to approach this? My knowledge of VB is limited.
thanks in advance,
john

[Tom van Stiphout]

On Thu, 14 Sep 2006 15:45:46 +0200, "john" <jo**@test.comwrote:

Have the user paste the text in a "Groupwise Message" field. That
alleviates you from having to write code to get the text from the
clipboard.
Read up on the following functions: Split, Left, Mid, Right, InStr
and you should be able to write the VBA code needed.

-Tom.

>In an app I would like the user to be able to paste a Groupwise message into
several fields of a record. Since Groupwise doesn't offer good save-as or
export-options, the easiest way is that the user selects the whole message
in the Groupwise viewer and copies it to the clipboard. As an example, the
following text would be on the clipboard:

<<<
From: Cleef, R. van
To: Jack Mapel
Date: 14-09-06 12:17
Subject: RE: Betr.: Access question

Dear Jack, bla bla bla...

>>>>

I would like to make a button in my form that:
1. reads the clipboard value
2. pastes "Cleef, R. van" in the field "From"
3. pastes "Jack Mapel" in the "To" field
4. etc. for Date, Subjecte, and Message.

What would be the best way to approach this? My knowledge of VB is limited.
thanks in advance,
john