Read email body and move values to excel sheet

Joined
May 22, 2017
Messages
1
Reaction score
0
Hello Expert,

I'm a system administrator, and on daily bases I have to check health status of different servers in our Network.

I'm using script to pull those details and send an email to respective team to keep track of.

My question is :

I receives 40 mails regarding server health status. And I have to open each and every mail to pull values from it and fill it in excel and send it to other teams .So I want to automate this task using Outlook vba.

Eg:
From:[email protected]
Subject: health chk for svr1_date
Body:

Uptime:xyz value
Opsagent:up
Ping : up
Processing: normal

So I want to fetch these values and put it into Excel .

Any help is appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top