
Outlook body to Excel
Hi, there's someone here who can help me
I want to be able to get parts of my text from my Outlook body automatically into Excel.
In the summer, my email body looks like this.
That's all I need in bold.
CURRENT WEATHER REPORT FROM: Vejr rapport Holstebro ny
Conditions: Dry
Temperature: 20.2 °C
Trend: +0.8 °C /hr
Average windspeed: 0.0 m/s
Current speed: 0.0 m/s
Direction: SW 225 °
Barometer: 950.1 hPa
Pressure trend -0.8hPa/hr
Humidity: 40 %
Dew point: 6.2 °C
Todays rain: 0.0 mm
Monthly rain: 35.7 mm
Yearly rain: 447.3 mm
Maximum temperature: 20.2 °C at time: 2:25 PM
Maximum heat index temperature: 20.2 °C at time: 2:25 PM
Minimum temperature: 9.2 °C at time: 7:21 AM
Maximum gust today: 0.0 m/s SW at time: 12:18 AM
Max gust last 10 mins:: 0.0kmh
Current Windchill: 20.2 °C
Indendørs temp.: 27.2 °C
Indendørs luft.: 50 %
Created by "Weather Display" version 10.37S Build 111 18:03:19 15-09-2021
Time of Weather report: 14:30:07 Date of report: 26-09-2021
In the winter, my email body looks like this.
CURRENT WEATHER REPORT FROM: Vejr rapport Holstebro ny
Conditions: Dry
Temperature: 2.7 0C
Trend: +0.1 0C /hr
Average windspeed: 0.0 m/s
Current speed: 0.0 m/s
Direction: SW 225 0
Barometer: 938.5 hPa
Pressure trend +0.1hPa/hr
Humidity: 61 %
Dew point: -4.1 0C
Todays rain: 0.0 mm
Monthly rain: 4.5 mm
Yearly rain: 120.6 mm
Maximum temperature: 2.7 0C at time: 12:00 AM
Minimum temperature: 2.6 0C at time: 12:07 AM
Maximum gust today: 0.0 m/s SW at time: 4:23 PM
Max gust last 10 mins:: 0.0kmh
Current Windchill: 2.7 0C
Indendxrs temp.: 26.1 0C
Indendxrs luft.: 35 %
Created by "Weather Display" version 10.37S Build 111 23:52:42 09-03-2021
Time of Weather report: 00:10:06 Date of report: 07-04-2021
Here is the excel file that it should be transferred to.
Microsoft 365 and Office | Development | Other
