Excel and OUTLOOK

[Andre Croteau]

Hello,

I have posted this query in the OUTLOOK newsgroup 2 days ago, but no
responses yet. I am not sure if this can be done. I know I should not post
the same message, but I was hoping that someone in this Excel newsgroup
could help/direct me.

Thank you

Hello,

I receive a considerable amount of emails each with one Excel file
attachment, and the name of the attachment has a distinct name.

I would like to move these messages to a distinct directory in OUTLOOK (done
manually), and then apply a macro to those messages which would
automatically save the attachments from each message to a specific directory
for later use. I don't want to open the files from the email, just save the
attachment. Can this be done? I have seen how macros can help in Excel,
but don't know if it can also be done in Outlook.

Thank you in advance.

André

 

[Guest]

this likely can be done, but you'll need someone familiar with VBA in Outlook.
Maybe this thread will from Outlook | Programming-VBA will put you on the
right track:
http://www.microsoft.com/office/com...70fe&catlist=&dglist=&ptlist=&exp=&sloc=en-us

tj

 

[Bob Phillips]

Andre,

Coincidentally, I have done this very same thing for a client at work. If
you would like a copy, I can take out all the extra bits and mail it to you.

Regards

Bob

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[GregR]

Bob, I would definitely like a copy if you wouldn't mind. TIA

Greg

 

[Andre Croteau]

Hello Bob,

I tried to send you a request last night directly to your email address, but
the message bounced back!

Yes, I would very much appreciate your help in this matter. I know it will
save me lots of time.

Thank you in advance.

André

 

[Bob Phillips]

It's in the mail.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Andre,

I have sent a workbook in the mail.

Bob

Hello Bob,

I tried to send you a request last night directly to your email address, but
the message bounced back!

Yes, I would very much appreciate your help in this matter. I know it will
save me lots of time.

Thank you in advance.

André

 

[Andre Croteau]

Hello Bob,

What can I say.....simply unbelievably amazing!!!!

Thank you so much for sharing this with me.

Thank you on behalf of other newsgroup readers for all the help you have
given

Hope it's not too early to wish you the best for the upcoming Holiday
Season!

Warm regards, and thank you again

André (a French Canadian living in Australia)

 

[GregR]

Bob, can I bother you again to resend the workbbok, I deleted it by mistake.
TIA

Greg

 

[Bob Phillips]

No probs, it is on it's way.

--

HTH

RP
(remove nothere from the email address if mailing direct)