e-mail message to tab delimited file?

[Allen Clark]

I have a situation where I have thousands of messages being generated by an
API regarding exception handling. Each exception is a formatted message with
the same format that should be able to be dumped into a tab delimited text
file for import into a database or spreadsheet so that I can better
troubleshoot what is happening with this API. Does anyone know a method that
can be run as a rule to parse the message into a tab delimited file? This
would be extremely helpful. I am also trying to prevent having to spend
thousands of dollars on a custom application or vertical market application.

Thanks in advance,
Allen

 

[Diane Poremsky [MVP]]

Does selecting several (or all) of these messages and doing a File, Save as
text provide you with a suitable format when opened in Excel? If you can
work with that format, you could automate it fairly easily. Otherwise
you'll need a bit more VBA - see outlookcode.com or the programming groups
on this server for assistance.

Using rules to move the messages to a folder and linking the folder to
Access might also meet your needs.

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Do you keep Outlook open 24/7? Vote in our poll:
http://forums.slipstick.com/showthread.php?t=22205

 

[Allen Clark]

This would almost handle the problem, however, it does not allow me to put it
into a table or CSV format for import into a database or spreadsheet for
later analysis. Does anyone know if this can be done with PowerShell?

Thanks for your reply,
Allen

Does selecting several (or all) of these messages and doing a File, Save as
text provide you with a suitable format when opened in Excel? If you can
work with that format, you could automate it fairly easily. Otherwise
you'll need a bit more VBA - see outlookcode.com or the programming groups
on this server for assistance.

Using rules to move the messages to a folder and linking the folder to
Access might also meet your needs.

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Do you keep Outlook open 24/7? Vote in our poll:
http://forums.slipstick.com/showthread.php?t=22205

I have a situation where I have thousands of messages being generated by
an
API regarding exception handling. Each exception is a formatted message
with
the same format that should be able to be dumped into a tab delimited text
file for import into a database or spreadsheet so that I can better
troubleshoot what is happening with this API. Does anyone know a method
that
can be run as a rule to parse the message into a tab delimited file? This
would be extremely helpful. I am also trying to prevent having to spend
thousands of dollars on a custom application or vertical market
application.

Thanks in advance,
Allen