Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I kick off an async Access app from Outlook

Status
Not open for further replies.

SBendBuckeye

Programmer
May 22, 2002
2,166
US
I have a project to help automate a multistep process which is initiated by a trigger email in Outlook which also contains an attached Excel file which is the input data into the process.

When the trigger email arrives, the attachment is saved off to a specified network drive where it needs to be validated.

I know I could control Excel from the Outlook VB code, but I don't want to tie up the process as some of the Excel files contain several thousand rows. What I would like to do instead is the following:

A. Outlook saves the attachment to specified path
B. Outlook triggers Access application through automation
passing file name information
C. Outlook code ends

D. Access starts up with parameters passed by Outlook
E. Access validates Excel file
F. Access sends email user notification message
G. Access code ends

A couple questions regarding the above scenario:

1. Is this the best way to do it
2. Assuming it is a viable option, how do you pass the
parameters from Outlook to Access - via command line or
is there another better way

Any help, suggestions and/or constructive criticism welcomed! Have a great day!


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top