Outlook 2007 and file attachment conversion

  • Thread starter 30N30W
  • Start date Views 3,859
3

30N30W

#1
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
 
S

Sue Mosher [MVP]

#2
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

"30N30W" <30n30w@gmail.com> wrote in message

news:5ccbe5b3-02e2-43b5-8290-059a184f67b4@13g2000prl.googlegroups.com...
> 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
 
3

30N30W

#3
On Sep 7, 1:53 pm, "Sue Mosher [MVP]" <sue...@turtleflock.com> wrote:
> 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
>    >      >    
> "30N30W" <30n...@gmail.com> wrote in message

> news:5ccbe5b3-02e2-43b5-8290-059a184f67b4@13g2000prl.googlegroups.com...

>
> > 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-




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
 
S

Sue Mosher [MVP]

#4
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

"30N30W" <30n30w@gmail.com> wrote in message

news:21a997f3-1d59-45eb-a81c-6282ba45325d@p10g2000prm.googlegroups.com...

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!
 

Similar threads

Top