SBendBuckeye
Programmer
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!
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!