How to extract data from Outlook


I'm hoping someone smarter than me might know of a possible solution to automate some data entry. I get emails in the following format and I have to manually enter the data into Smartsheet via form. But, I can get a lot of these throughout the month and I'm thinking there must be a way to extract this data from Outlook. I was thinking I could somehow get the info into an Excel sheet since Outlook and Excel are both Microsoft products, but any solutions I've found on Google aren't working when I try. Anyone have any ideas on how I can get this data into either my Smartsheet or into an excel file without me having to manually enter it? Thanks in advance!

  • Name: First Last
  • Employee ID: 1234567
  • Date of Hire: 05/22/2023
  • BU Name: 91000 - Company name
  • Location: CPI City
  • Dept ID: 12K456
  • Dept Name: Department name here
  • Job Title: Job title name here
  • Supervisor ID: 123456


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!