Mail import split in columns

[AliceV]

Hello,

I'm having a bit of a problem. I want to do the following and have been told it should be possible using VBA, however I have zero experience with VBA and have no clue where to start, or how to start.

I Import the mails into acces 2010. Now comes the problem the text is a memofield and I would like to see the content in columns. The bold tekst indicates the name of the column and underneath is the "answer" of the participate. The mail has always the same layout. (I haven't posted all the mail, since it's kinda long with all the questions.) Could somebody help me out how I transfer the data from this Memo-field to columns?

Thanks in advance.

Alice


Through email I'm getting the following message:

Er is een inschrijving binnengekomen via de Charm website:



Ik schrijf mij in voor::
Test

Geslacht::
Test

Voornaam::
test

Achternaam::
test

 

[spikepl]

You can code it, one example is here: http://stackoverflow.com/questions/750383/vba-parse-email-text-to-access-2000-class-instance

Or you can buy a commercial application like http://www.email2db.com/ which is able to parse email texts and put them into an Access table.

Do you have any other (than VBA) coding experience? IF so then just do some online Access tutorials to familiarize yourself with access and VBA.