Hello all,

I'm a new member of the forum and I could not find an answer to my problem yet. Here it is:

There is a mailchain containing a questionnaire and answers like this:
__________________________________________
text
text

Hello,

please find the filled in questionnaire below.

What caused the issue?
There was a power outage.
How was the issue resolved?
The supplier restored it.
Is the issue permanently solved?
yes
What could be done to avoid the issue from reoccurring?
Add additional protection
Category
Technical failure

text
text
text
_________________________________________

I want to extract the answers to cells in Excel automatically.

Is it possible to create a formula or VBA code to do this? Hope you can help.

Greetings