Running Outlook Macro in Excel For sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Okay, so here's the deal..
I recieve over 100 customized forms a day from 13 different types of forms.
Each type of form has its own unique subject which is disabled so its the
same. These forms are submitted to a public email address, which goes to a
public folder so we can review them and make the required changes. I wrote a
Macro that sorts this public folder, it places all the emails with a part of
the subject line, into a folder named the same thing. This way, its easy to
see who should take care of what.

Now, I need to automate this. I use SQL server to automate everything. I
usually have it open Excel and fire a marco. I need to know if I should use
SQL server to run outlook instead, if this is possible. Please let me know.

Also, If not, how can I declare MAPIfolder objects in excel. The complier
says it is not a valid object (in VBA excel), but it works in outlook.
Thanks for your help in advanced.
 
Outlook isn't suitable to automate from a server-based application. If you want to write your macros in Excel, instead of Outlook, choose Tools | References and add a reference to the Microsoft Outlook library.
 
Back
Top