Getting data from Email to Excel


New Member
Jul 26, 2005
Hi all,
I'm trying to put together a backup "dashboard" in Excel.

I need a macro that does the following:

Insert a new Column at say "H" moving all columns right and in the first cell (H1) put yesterday's date.
Open email, get NEW/UNREAD emails (the date's may not be yesterday's, some of the backups finish after midnight)
Parse the data in BOTH subject AND body looking for "Success" or "Successful" (different backup software on some pc's gives different response emails, some have success in subject, others have it in body)
Get the Company Name from the subject, get the PC name from the subject
Find which row in the spreadsheet that Company Name AND PC name is and put "OK" in (Hx) where x is the Company name's and PC name's row
Mark email as READ
Then repeat for next (NEW/UNREAD) email.

Also needs to look for "Failed" in subject and body. If it find's "Fail" put "X" in (Hx) and fill the cell with red so it stands out.

Mail account is in Outlook attached to MS Exchange



Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...