Automatic eMail sent from Microsoft Project

[Guest]

Can VBA for MS Project 2002 Pro be used to automate the sending of eMail to
project resources at a specified time prior to starting a task by using
Microsoft Outlook?

thanks,
glenn

 

[Guest]

If you set a reference in the Project VBA editor to the Microsoft Outlook
Object Library, you can easily automate sending e-mail messages. If you want
these e-mails sent at a specific time, you may have to rely on trapping a
reminder set via a flag on a message, a task, or an appointment in the
calendar. However, this requires Outlook being open at the specified
reminder time.

There may be other ways to do this, but it depends on exactly how you want
this done.

 

[Sue Mosher [MVP-Outlook]]

Also, you'll run into Outlook's security prompts if you try to send
messages. See http://www.outlookcode.com/d/sec.htm

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers