I'm new to the forum so please excuse in case this question may have been raised beforehand.
I'm new to VBA but would like to automate a process which I am currently doing manually. As this may become relevant, I am working with Office 2016 Professional Plus .
On a daily basis, I'm receiving standardized emails from clients.The body of the email is always the same and contains variables that I would like to add into a spreadsheet. As the email address is dedicated to those emails, there won't be other emails in the inbox.
The email is basically set up in the following way:
First Name: XYZ
Last Name: XYZ
Question with yes or no as an answer option
Currently I am copying the respective field into the columns of my excel Sheet whereas
A: First Name
B: Last Name
D: Phone Number
E: Yes or no
Before going too deep into this, I am wondering if this is something which can in principle be automated and if so, would someone be able to give me a helping hand for this?
Thank you in advance