Is it possible to email data into a spreadsheet

[MrTeeny]

I'm able to have the sheet email data to me but is it possible to have an email enter data via outlook.

For example could I set excel to search the received mail and read headings. My sheet is continuously being updated so worksheet event can trigger any searches if it's possible

Thanks

 

[Logit]

.
I did a NET search for "vba copy email body into worksheet" and turned up alot of websites with instructions, sample code, etc.
These sites have resources for copying the email body (presumed to be a table ?) and paste that into a worksheet.

On another note :

If the email has a sheet attached to it, you can always download the attachment to a designated folder, then use a macro to copy the contents of the specific worksheet
to the workbook you desire. Sort of taking a few extra steps to accomplish the same thing as the websites above are instructing.

 

[MrTeeny]

Thanks, I found outlook has it's own VBA editor so should be able to kick off a script when an email arrives with the correct subject title.

Only thing I'm stuck with now is how to have that script just add to an open workbook, found lots of scripts for creating workbooks but nothing for how to access an already open workbook.