Export excel file with imported email sender name

  • 76 Views
  • Last Post 13 March 2018
samir waikar posted this 23 February 2018

Hi all,

Can anyone give me solution urgently on how to export file with email sender name. For eg. If i received invoices from partulcar email ID 123@xyz.com, 456@pqr.com, then export file need to be 123invoices.xls, 456invoices.xls like that.

Suggestions are welcome. 

Thanks,

Order By: Standard | Newest | Votes
samir waikar posted this 23 February 2018

The value of email ID will be imported online (may be web station) or somewhere from other sources and not stored in a field.

 For eg. If i received invoices from partulcar email ID 123@xyz.com, 456@pqr.com . How to do it.?

And if stored in a field , how to export int that case also let me know.

Appreciate your answers...

Thanks,

Vladimir Dimitrijevic posted this 23 February 2018

Hi,

Are you importing invoice from hot folder?

Best regards, Vladimir

samir waikar posted this 23 February 2018

Yes, email IDs will be configured Through hot folder and need to export xls file with sender name so that will come to know that files are from particular email ID. For eg. 123@xyz.com will have 123invoices.com, 456@pqr.com will have 456invoices.xls like that.. Solutions will be appreciated. Thanks,

samir waikar posted this 24 February 2018

Hot folder gives the path of the hard drive or something like it and that too within a column of excel file, but email IDs are configured through MAPI or POP3, and need to be renamed the export file with email sender and not a column within a excel file. Like 123@xyz.xom then file will be 123invoices.com. It should not create a field for every document and should not export with a separate column within a excel, rather to be renamed complete export file with sender name. Solutions appreciated, Thanks,

Ekaterina posted this 13 March 2018

Hello,

Could you please see this topic http://www.capturedocs.com/thread/parse-filename/ ? Does the proposed solution meet your requirements?

Close