Hi antfarm,

Answer to both questions is yes.

You can probably make things a bit easier for yourself by sending the
formmail survey data to some sort of text datafile. Then import that to
Excel.

Keep in mind importing XML data into Excel is now very easy.

Or, if the client already has emails in the format below, use the OFFSET
method that I described in the thread "Convert data from rows to columns"
earlier in this newsgroup.

Ed Ferrero
http://edferrero.m6.net


I am a web designer with very little experience in the intricacies of
Excel, my problem is that I have a client who wants to import the
general data emailed to him from his formmail survey on his web page,
into a pre formatted Excel template - so it is easier to digest and
send away.

The data looks something like this;

formtype: Registration page

redirect: http://www.anything.com.au/thanks.html

first-name: Joe

homephone: 632-4351603

4_months_commitment: Yes

submit: Submit registration

nationality: Filipino

languages-spoken: English

gender: Male

age: 38

marital-status: Married
----------------------------

I just want to know whether this is
a) possible
b) easy enough to learn

Any tips or advice welcome. Thanks


--
antfarm
------------------------------------------------------------------------
antfarm's Profile:
http://www.excelforum.com/member.php...o&userid=24661
View this thread: http://www.excelforum.com/showthread...hreadid=382394