View Single Post
  #4  
Old August 23rd 07, 05:12 PM posted to microsoft.public.outlook.program_vba
Doug
external usenet poster
 
Posts: 10
Default Copying new message to public folder

Thanks so much! I'm new to Outlook VBA & didn't know that could be done, but
I was able to Google up a couple of examples.

--Doug

"Michael Bauer [MVP - Outlook]" wrote in message
.. .


Why don't you use the ItemAdd event of the SentItems folder?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:

http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Wed, 22 Aug 2007 08:27:56 -0700 schrieb Doug:

We have a collection of public folders (typically about 100 of them) for
project-related email. We currently ask staff to manually save
project-related mail in the appropriate folder. I've written a macro that
makes this easy to do for incoming mail. But for sent mail, I can't
figure
how to best do it.

I tried hooking Application_ItemSend. From there I can copy the email to

the
public folder no problem. But unfortunately the message hasn't been sent
yet, so the message shows up as "Not Yet Sent".

I can probably accomplish what I want by CC to the public folder, but to

do
that I have to get the folder's email address, and then I have to contend
with Outlook's security prompts or get Redemption, which will complicate

the
deployment.

I would welcome any other suggestions...thanks!

--Doug



Ads