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

Excel questions

  • 09-05-2011 4:39pm
    #1
    dreamers75
    Registered Users, Registered Users 2 Posts: 20,558 ✭✭✭✭


    Hi

    Simple question, can a spreadsheet read an automated email and update a cell with a quantity based on the email.

    Ie i get several emails everyday with X orders for X, Y orders for Y.

    I only need the 1st X and Y to be entered into a cell.

    Possible?


Comments

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


    Is the data you want in the email or attached to it?

    If in the email, is the format standard from one day to the next? Is the subject line the same/similar

    If attached to the email, is the file name consistent or date stamped? Is the file format consistent?

    Answers to these questions will dictate the best approach


  • #3
    dreamers75
    Registered Users, Registered Users 2 Posts: 20,558 ✭✭✭✭dreamers75


    homer911 wrote: »
    Is the data you want in the email or attached to it?

    If in the email, is the format standard from one day to the next? Is the subject line the same/similar

    If attached to the email, is the file name consistent or date stamped? Is the file format consistent?

    Answers to these questions will dictate the best approach


    Cheers for the reply.

    Format is "YYYY monitor has run and XXX items are on order", all emails have the exact same subject and body of text where the only change is the YYYY and XXX. YYYY being the item and XXX being the quantity.

    The only actual difference is the time the system sends the email.


  • #4
    HivemindXX
    Registered Users, Registered Users 2 Posts: 1,208 ✭✭✭HivemindXX


    It is possible but it's relatively complicated. Perhaps there's an easy way but if there is I don't know it.

    The method I would use to do this is to create a VBA routine that opens your mailbox and checks for mails with a subject line you have defined. If any mails that match are found they are opened and the numbers you want are picked out (the format of the mail must be clearly defined) and put in to the cells.

    You must also deal with the problem of reading the same mail more than once. One solution would be to delete the mail or move it to another folder. Another solution would be to record the timestamp of the mail and ignore any mail with that exact time stamp in future (this is not a great solution obviously).

    You would trigger this by pressing a button on the Excel sheet.

    The web site below has a lot of information on automating Excel and Outlook using VBA. It doesn't directly show how to do what you want but it will give an idea of what needs to be done. If you don't do programming this won't be much use though.
    http://www.codeforexcelandoutlook.com/


Advertisement