View Single Post
  #1  
Old March 21st 08, 05:56 PM posted to microsoft.public.outlook.program_vba
[email protected]
external usenet poster
 
Posts: 4
Default incoming message rule to kick off vba with a variable

I'm new to programming VBA for Oulook but not Access, but here's what
I am trying to do:

I do business with about 25 branches of a particular company.
The branches are identified like this: ABC01, ABC03, ABC23, ABC58,
etc, all 5 digits.

I 'd like to send a message to my "Worker machine" (a box that runs
Access and Outlook) that says in the subject "SendTo ABC03" and it
would start an application (access) with a macro named ABC03 which
would pull the recordset and e-mail the report. I have the back half
of that already done.
What I need is a way to pass the ABC03 from the subject line into the
start application variable to call the proper macro.

I could do this with 25 rules, but I thought there might be an easier
way to do it using VBA.
Ads