Results 1 to 2 of 2

Email import into Excel

Threaded View

  1. #1
    Registered User
    Join Date
    04-12-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Email import into Excel

    Hi,

    After searching the web and this forum for a while, I don't seem to be able to find a solution.

    Our customers fill our a form on our website and I receive these filled out forms by email. I receive one email per form filled out.

    They look like that:

    DATE SUBMITTED: 12/04/2010 3:04:38 PM

    NAME: xxx
    PREFERRED METHOD OF CONTACT: Email
    ADDRESS: xxx
    CITY: xxx
    STATE: xxx
    COUNTRY:
    POST CODE: xxxx
    PHONE: xxxx
    FAX: xxxx
    EMAIL: xxx@xxx.com

    I AM A: xxx

    I WOULD LIKE INFORMATION FOR: xxx

    POSTCODE FOR NEAREST STOCKIST: xxx

    DETAILS OF ENQUIRY: xxx

    WHERE DID YOU HEAR ABOUT US: xxx
    I need to import some of this data into excel and displayed like follow:

    A1: I AM A
    B1: PREFERRED METHOD OF CONTACT
    C1: STATE
    D1: WHERE DID YOU HEAR ABOUT US
    A2: XXX
    B2: XXX
    C2: XXX
    D2: XXX

    So the first row would be the column headings and the following rows would be each details from each email.

    Any help? Is it even possible?
    Last edited by vcellier; 04-12-2010 at 04:57 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1