Hi
In Outlook I would like to trigger the Attach file window (Paperclip) to a set folder location based on the value in the templates .oft UserDefinedField called JID (JobID)
Each JID (JobID ) has a folder for documents in the server e.g for JID12345 = path Y:\JobFolders\JID12345
I have worked out the code to open the template & populate the UserDefinedField but I can’t figure out/find any documentation on
1. The command to fire the Attach file window
2. Pass a Str to the Attach file window to the desired folder
Thanks
Stewart
Access&Outlook2010
In Outlook I would like to trigger the Attach file window (Paperclip) to a set folder location based on the value in the templates .oft UserDefinedField called JID (JobID)
Each JID (JobID ) has a folder for documents in the server e.g for JID12345 = path Y:\JobFolders\JID12345
I have worked out the code to open the template & populate the UserDefinedField but I can’t figure out/find any documentation on
1. The command to fire the Attach file window
2. Pass a Str to the Attach file window to the desired folder
PHP:
Private Sub TriggerAttachmentsWindowTest_Click()
Dim myOlApp As Outlook.Application
Dim MyItem As MailItem
Set myOlApp = Outlook.Application
Set MyItem = myOlApp.CreateItemFromTemplate("C:\JobTrackerFE\Templates\Outlook\NewQuote.oft")
MyItem.UserProperties("JID") = JID
MyItem.Display
Set myOlApp = Nothing
Set MyItem = Nothing
End Sub
Thanks
Stewart
Access&Outlook2010