コミュニティ

Export excel file with imported email sender name

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,

この記事は役に立ちましたか?

0人中0人がこの記事が役に立ったと言っています

コメント

5件のコメント

  • Avatar
    Samir Waikar

    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,

    0
  • Avatar
    Vladimir Dimitrijević
    Hi, Are you importing invoice from hot folder? Best regards, Vladimir
    0
  • Avatar
    Samir Waikar
    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,
    0
  • Avatar
    Samir Waikar
    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,
    0
  • Avatar
    Permanently deleted user

    Hello,

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

    0

サインインしてコメントを残してください。