Outlook 2007 and file attachment conversion

[30N30W]

This may take some further explaining but the jist:

Background:

I have an app that emails audio files (attachments) to a single email
address for archiving purposes.
The attachment is in a proprietary format to save space.
I have a "player" (like sound recorder) that can open the attachment,
and then "save as" the file as .wav
I am using an email box in Outlook 2007 as the repository of all
"archived" messages

What I need to do:

When a message comes in to the Outlook inbox, if the subject line
matches a user name, I need to convert the attachment, and send it
back out to the users email address. The original attachment can stay
with the original email in the inbox.

So I would have a list of user names with outbound email addresses to
match to...

Should I use a script? VBA code? Macro? Rule?
This box receives about 2500 emails a day, but probably less than 10%
would need to be converted and resent.

Thanks for any advice....

Andrew

 

[Sue Mosher [MVP]]

I presume you mean convert to .wav? Whether that is possible at all depends
on whether your player can be accessed through programming code.

The basics of processing incoming messages with Outlook VBA are covered
here: http://www.outlookcode.com/article.aspx?id=62

 

[30N30W]

I presume you mean convert to .wav? Whether that is possible at all depends
on whether your player can be accessed through programming code.

The basics of processing incoming messages with Outlook VBA are covered
here:http://www.outlookcode.com/article.aspx?id=62

--
Sue Mosher, Outlook MVP
   Author of Microsoft Outlook 2007 Programming:
     Jumpstart for Power Users and Administrators
   http://www.outlookcode.com/article.aspx?id=54












- Show quoted text -

You are correct - I need to convert it to .wav from it's proprietary
format thru the proprietary player. How would I tell if it can be
accessed programmatically? If I click on the attachement, it will
play automatcially - could I then do a keystroke macro to halt the
play and send a "save as" to save it in .wav format? If outlook had
a macro recorder this would be a lot easier!

Thanks for the tips...I'm buying your book - I hope to learn some good
things from it!

Andrew

 

[Sue Mosher [MVP]]

You probably would need to ask the developer of the conversion component or
consult its documentation. Even a macro recorder in Outlook wouldn't provide
any clues on how to automate a non-Outlook component.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54



You are correct - I need to convert it to .wav from it's proprietary
format thru the proprietary player. How would I tell if it can be
accessed programmatically? If I click on the attachement, it will
play automatcially - could I then do a keystroke macro to halt the
play and send a "save as" to save it in .wav format? If outlook had
a macro recorder this would be a lot easier!