I've searched through countless posts on here/elsewhere and can't get anything to work for me, so my apologies if this has been posted a million times.
I know nothing about VBA and if you're reading this, then most likely you've forgotten more than I've learned, so please bear with me.
I just started a new job that requires the data from emails to be copy/pasted one field at a time into an existing spreadsheet and I'm not doing that, it's far too manual/time consuming and I know there's got to be a better way. The emails are are the same in terms of structure from first line to last.
Example:
First Name: Andy (Needed)
Last Name: Dufresne (Needed)
Address: Not Needed
Apt. Unit: Not Needed
City: Not Needed
State: Not Needed
Zipcode: Not Needed
Phone Number: 1234567890 (Needed)
DOB: Not Needed
Email Address: Shawshank@Redemption dot com (Needed)
I only need to extract First Name, Last Name, Phone Number and Email into excel, but I'll export all and delete after if that's easier.
What do I need to do to copy/paste VBA code that works? I've tried copy/pasting code found on the internet, but they all fail and I'm sure it's my own ineptness. And I don't know what to do with the vague errors anyway.
Please save me from me, thanks.
I know nothing about VBA and if you're reading this, then most likely you've forgotten more than I've learned, so please bear with me.
I just started a new job that requires the data from emails to be copy/pasted one field at a time into an existing spreadsheet and I'm not doing that, it's far too manual/time consuming and I know there's got to be a better way. The emails are are the same in terms of structure from first line to last.
Example:
First Name: Andy (Needed)
Last Name: Dufresne (Needed)
Address: Not Needed
Apt. Unit: Not Needed
City: Not Needed
State: Not Needed
Zipcode: Not Needed
Phone Number: 1234567890 (Needed)
DOB: Not Needed
Email Address: Shawshank@Redemption dot com (Needed)
I only need to extract First Name, Last Name, Phone Number and Email into excel, but I'll export all and delete after if that's easier.
What do I need to do to copy/paste VBA code that works? I've tried copy/pasting code found on the internet, but they all fail and I'm sure it's my own ineptness. And I don't know what to do with the vague errors anyway.
Please save me from me, thanks.
