PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook VBA Programming How to identify mail for specific user

Reply

How to identify mail for specific user

 
Thread Tools Rate Thread
Old 11-08-2004, 09:53 PM   #1
MikeC
Guest
 
Posts: n/a
Default How to identify mail for specific user


Can anyone tell me if there is a way, using VBA, to
identify messages sent to a specific Outlook user from a
specific sender? Ultimately, I will include code that
will save, to a network folder, specifically named file
attachments that arrive with these messages.

An additional objective is to automatically run this code
in background not using an Outlook client...or at least
not require the above recipient to launch Outlook in order
to run this code. I had been considering either running a
scheduled task or possibly finding a way to run this code
from the mail server. Any thoughts?
  Reply With Quote
Old 13-08-2004, 12:57 AM   #2
Sue Mosher [MVP-Outlook]
Guest
 
Posts: n/a
Default Re: How to identify mail for specific user

The Recipients collection will tell you who the message was sent to, unless
the recipient got it as a Bcc.

As for the sender, you can use SenderName. If you need the address, too, in
Outlook 2003, you can use the MailItem.SenderEmailAddress, but note that
it's subject to security prompts in certain contexts.

In earlier versions, there is no Outlook property that returns the sender's
email address. You can either use CDO (or Redemption to avoid security
prompts -- http://www.dimastr.com/redemption/) to get the From address or
use Outlook to get the Reply To address. Sample code at
http://www.outlookcode.com/d/code/getsenderaddy.htm

To get the SMTP address from an Exchange sender or recipient, use CDO or
Redemption and the PR_EMAIL (&H39FE001E) MAPI property to obtain the SMTP
address from the AddressEntry object. See
http://www.outlookcode.com/d/code/g....htm#redemption and
http://www.cdolive.com/cdo5.htm#EMailAddressOfSender for examples.

It is not appropriate to run Outlook automation code on a server or as a
scheduled task, because of the likelihood that Outlook will display modal UI
that will halt the application.


--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"MikeC" <anonymous@discussions.microsoft.com> wrote in message
news:47fa01c47fe5$3b792550$a401280a@phx.gbl...
> Can anyone tell me if there is a way, using VBA, to
> identify messages sent to a specific Outlook user from a
> specific sender? Ultimately, I will include code that
> will save, to a network folder, specifically named file
> attachments that arrive with these messages.
>
> An additional objective is to automatically run this code
> in background not using an Outlook client...or at least
> not require the above recipient to launch Outlook in order
> to run this code. I had been considering either running a
> scheduled task or possibly finding a way to run this code
> from the mail server. Any thoughts?



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off