Link to home
Start Free TrialLog in
Avatar of DRITTS
DRITTSFlag for Afghanistan

asked on

Need a way to Auto Accept Messages from a particular person with a specfic subject

I was wondering if there is a way to Auto Accept Messages From a particular user with a specfic subject. I have created a public folder  Calendar for our IT Dept. As our organization grows we need a better way of keep track of New Hires and those have been let go. I created the folder as a way to keep track of these updates. The Director will create an apointment in the calendar and then send the requests to myself (sysadmin) and to the Help Desk/Desktop support folks. As long as all parties accept the messages the events will be entered into their calendars. I am concerned that this won't always happen. Therefore, I would like a way for this to be autmated so these messages are always accepted. I don't see anything built into Outlook. I assume this will require a macro of some kind. I am not a VB developer. Any thoughts?
SOLUTION
Avatar of David Lee
David Lee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of DRITTS

ASKER

Thanks, this exactly what I am looking for.
However, when restart Oulook and enable the Macro I get a runtime error 13 on the following line:
 Set olkFolder = Session.GetDefaultFolder(olFolderInbox)

Any thoughts?
My fault.  Replace line 13 with this
    Set olkFolder = Session.GetDefaultFolder(olFolderInbox).Items
 
Avatar of DRITTS

ASKER

Okay, the error went away. Using my Outlook profile I edited the 2 fields you specified. For the the sender I used a test account and for the subject I used New Hire. I ran a few tests, but it is not Autmatically Accepting meetings. I am also not seeing any Outlook Security messages.
When you launched Outlook were you prompted to enable macros?  
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Well, it's almost exactly the same code I posted with the exception that it doesn't appear to test for the sender, meaning it'll accept appointments from anyone that sends a message with the correct subject.  You'd said you only want them from one user.  Since testing for the sender is the only significant difference I can see, I can only assume that my code wasn't working because the sender name didn't match.
Avatar of DRITTS

ASKER

Yes, that was the orginal idea. It was going to come from 1/maybe 2 senders. However, since the subject is so specific I realized it didn't make sense for me to have that included. I am not sure why the orginal code you sent didn't work. I tested it with a using a few clients, but I could have made some other error along the way. Either way your input and code was essential. Thank you for your help.