Here's a challenge - VBA regarding mail

  • Thread starter Thread starter Stealth1
  • Start date Start date
S

Stealth1

ok, I'm not a pro, but this task seems like an extremely
difficult task - so hopefully someone is up to the challenge!

I have a MS Access 2003 database. I would like to use
VBA to accomplish the following tasks (keep in mind this
is originating from Access and not Outlook)...

I would like to take an email address and instead of creating a new message
to it I would like to REPLY to the last one that was received
from that address. Obviously the only real difference is that the
body of the message from the previous received message will
be included. Keep in mind I am talking about sending a message
programatically (although it needs to use Outlook as a client).
 
Am Tue, 25 Apr 2006 15:30:54 -0500 schrieb Stealth1:

If all e-mails you want to consider are in the Inbox of Outlook then you can
sort them by the Sort method retrieve all items received from that address
by the Restrict function. Take the first item received and call its Reply
function.
 
If all e-mails you want to consider are in the Inbox of Outlook then you
can
sort them by the Sort method retrieve all items received from that address
by the Restrict function. Take the first item received and call its Reply
function.
Click to expand...

And this can be done from MSAccess?
 
Am Wed, 26 Apr 2006 08:35:50 -0500 schrieb Stealth1:

Yes, it can. Add a reference onto Outlook via Tools/References.
 
Back
Top