Cmd to fire "Attach File Window" with Location from UserDefinedField value (1 Viewer)

FAB1

Registered User.
Local time
Today, 15:02
Joined
Jul 27, 2007
Messages
40
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

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
 

Users who are viewing this thread

Top Bottom