Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Query about Outlook and Excel

  • 13-03-2014 4:43pm
    #1
    FutureGuy
    Moderators, Computer Games Moderators Posts: 15,237 Mod ✭✭✭✭


    Hello all,
    I've been tasked with implementing an error tracking system in an excel sheet. The error reports are sent to us via Outlook and need to be manually documented.

    I'm wondering if a e-mail could be structured so that it could automatically export the data to an excel sheet?

    Sorry about the vague nature - this is not my forte :)

    Any other ideas would be appreciated!


Comments

  • #2
    homer911
    Registered Users, Registered Users 2 Posts: 5,145 ✭✭✭homer911


    Yes, this can be done all right

    To be clear, is the error message in the email or attached to it?

    Is there structure to the message or is it unstructured?

    Are the errror messages readily identifable by a subject line or exclusive email sender address?

    By combining Outlook rules with VB code, you can get it to do just about anything..


  • #3
    Thoie
    Registered Users, Registered Users 2 Posts: 6,344 ✭✭✭Thoie


    Infopath to the rescue!

    If you already have Excel and Outlook, there's a strong chance your company already has Infopath licenses too (it may already be installed on your machine, take a look).

    In Infopath you can create a mail template that people can use to enter their errors (e.g. fields for the product that's causing the error, date found, name of finder, description of error, whatever). They then email the form to whoever, and that person can export the info to a variety of places easily.

    Read this:
    http://office.microsoft.com/en-ie/infopath-help/introduction-to-sending-and-receiving-infopath-e-mail-forms-with-outlook-HA010164546.aspx


  • #4
    FutureGuy
    Moderators, Computer Games Moderators Posts: 15,237 Mod ✭✭✭✭FutureGuy


    Thoie wrote: »
    Infopath to the rescue!

    If you already have Excel and Outlook, there's a strong chance your company already has Infopath licenses too (it may already be installed on your machine, take a look).

    In Infopath you can create a mail template that people can use to enter their errors (e.g. fields for the product that's causing the error, date found, name of finder, description of error, whatever). They then email the form to whoever, and that person can export the info to a variety of places easily.

    Read this:
    http://office.microsoft.com/en-ie/infopath-help/introduction-to-sending-and-receiving-infopath-e-mail-forms-with-outlook-HA010164546.aspx

    It's currently unstructured and in the body of the mail but I can structure it in a manner that would work.


Advertisement