none
how do i exporting e-mail contents into excel using a macro code or VBA RRS feed

  • Question

  • We are holding an event and they are registering for the event online. We have the forms being sent directly to outlook to a folder named "softball" I am trying to now get that info in the e-mail to sort automatically into an excel spreadsheet.

    Here is a sample of what the email will look like:

    The submitted value of field named "Name" is:

    -------------------------------------------------------

    Karen

    -------------------------------------------------------

    The submitted value of field named "Age" is:

    -------------------------------------------------------

    Over 21

    -------------------------------------------------------

    The submitted value of field named "Club Number" is:

    -------------------------------------------------------

    2222

    -------------------------------------------------------

    The submitted value of field named "Club" is:

    -------------------------------------------------------

    PRC

    -------------------------------------------------------

    The submitted value of field named "Cellular Number" is:

    -------------------------------------------------------

    555-555-5555

    -------------------------------------------------------

    The submitted value of field named "Email Address" is:

    -------------------------------------------------------

    test @ test .com

    -------------------------------------------------------

    The submitted value of field named "Guest's Name(1)" is:

    -------------------------------------------------------

    Can anyone help me with the code that I would need to use. I have never used VBA, and macros before. Thanks!

    Thursday, April 4, 2013 6:18 PM

All replies