How to extract data from Outlook

BFuller

Hello,

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

Paul Newcome

You are going to need to leverage the API for this one.

Andrée Starå

Hi @BFuller

I hope you're well and safe!

You could either use Zapier or a similar service combined with a Parser to collect the data and submit it to Smartsheet, or you could maybe use what I can, an Import solution sheet, and you would copy the information and paste it in the import solution. Then it could be transferred to where you need it.

Make sense?

Would any of those options work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!