Getting Emails (or at least subject line) into an excel file, possubly with SharePoint

SandsB

Well-known Member
Joined
Feb 13, 2007
Messages
616
I have emails that are sent by about 30 people in my group. The Outlook emails are basically several rows of an Excel file pasted into the body of the email. We use this as a way to have everybody enter the same info in the same way for a particular process - sort of like a form. What I'd like to do is, but don't think I can, have these same emails directed to a SharePoint list so they just show up on my SharePoint web site whenever they're created. The problem is that only attachments in emails to a SharePoint email address will show up in the list, not emails that don't have attachments. I've read this so I believe it to be true.

So, does anybody know a non-SharePoint trick for getting the subject line of Outlook emails into an Excel file. I don't want ALL my emails to go into the file so I'd need to somehow filter it by looking for a string that only these emails have: "REPLNo"
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,123,336
Messages
5,601,023
Members
414,421
Latest member
tonybear1994

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top