R
RebekahK20_pontiac
I have a database created by getting external data (outlook folder) and
creating a table.
- I sure hope this updates each time the table is opened... if not I need to
fix that as well....
In this table the field 'Contents' contains the entire body of the email. I
need to pull out several key peices of information. This is a system
generated email so it is always in the same format.
I need to pull out the Task ID, The Route, Route Owner, and a url link to the
Route. Not everything is seperated by commas but usually spaces.
Example:
Business Object: Inbox Task IT-0112053
'Inbox Task' 'IT-0112053' has been automatically assigned to 'Group - Vendor
Tech' by the completion of 'Inbox Task' 'IT-0101461' owned by 'mdringler'.
This task is part of 'Route' 'R-0007366'
which is owned by 'mdringler'
I have tried the following in daze of cunfusion and get an 'Invalid Procedure
Call' error...
"Route"=Mid([Contents],InStr([Contents],"Route")+6,InStr([Contents],"which")-
InStr([Contents],"Route")-6)
i think my mind is on auto pilot today or i have just been staring at this so
long i'm lost.
Please help guide me back to the land of the fully functioning.
Thank you in advance
creating a table.
- I sure hope this updates each time the table is opened... if not I need to
fix that as well....
In this table the field 'Contents' contains the entire body of the email. I
need to pull out several key peices of information. This is a system
generated email so it is always in the same format.
I need to pull out the Task ID, The Route, Route Owner, and a url link to the
Route. Not everything is seperated by commas but usually spaces.
Example:
Business Object: Inbox Task IT-0112053
'Inbox Task' 'IT-0112053' has been automatically assigned to 'Group - Vendor
Tech' by the completion of 'Inbox Task' 'IT-0101461' owned by 'mdringler'.
This task is part of 'Route' 'R-0007366'
which is owned by 'mdringler'
I have tried the following in daze of cunfusion and get an 'Invalid Procedure
Call' error...
"Route"=Mid([Contents],InStr([Contents],"Route")+6,InStr([Contents],"which")-
InStr([Contents],"Route")-6)
i think my mind is on auto pilot today or i have just been staring at this so
long i'm lost.
Please help guide me back to the land of the fully functioning.
Thank you in advance