Question

How we can read any specific Microsoft Outlook email and excelsheet attachment with data from email to add this excel data in FME Workbench to process ahead and generate the required output as reports.

  • 8 May 2023
  • 1 reply
  • 24 views

How we can read any specific Microsoft Outlook email and excelsheet attachment with data from email to add this excel data in FME Workbench to process ahead and generate the required output as reports.


1 reply

Userlevel 3
Badge +13

Hello @actualabhijeet​, thanks for posting! Unfortunately, I don't think FME Form has a way of naturally picking up email traffic. A user attempted to do a similar thing withpython, but it looks like they used FME Flow in the end (see comment thread).

 

To get emails into FME Form, you may need to manually save the emails as text files (Text File Reader) and also download the attachments (Excel Reader). However, this sounds like a wonderful use case for FME Flow. Hope this helps, Kailin

Reply