![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Hellow,
I want to check if the ReadingPane is On in vba. How can i do this? i found a method ShowReadingPane but i can't find an example on how to use it. It's supposed to be a part of a Tableview? Anyone has some suggestions? Thanks in advance |
Ads |
#2
|
|||
|
|||
![]()
It seems that i found it
![]() If Explorers.Item(1).IsPaneVisible(olPreview) = True Then That's at least one possibility. I use this for a locking mechanisme for files in public folders in outlook. But it locked also in preview mode :s no it doesn't but i can't lock it anymore now :s It's in the event ReadAttachment Is there an Event DoubleClick?? On Jul 16, 1:07 pm, _-Andy-_ wrote: Hellow, I want to check if the ReadingPane is On in vba. How can i do this? i found a method ShowReadingPane but i can't find an example on how to use it. It's supposed to be a part of a Tableview? Anyone has some suggestions? Thanks in advance |
#3
|
|||
|
|||
![]()
I need something else
How can i turn the Preview (Reading) Pane off and on? Again i need to know how to call the ShowReadingPane method :s Anyone please? On Jul 16, 2:22 pm, _-Andy-_ wrote: It seems that i found it ![]() If Explorers.Item(1).IsPaneVisible(olPreview) = True Then That's at least one possibility. I use this for a locking mechanisme for files in public folders in outlook. But it locked also in preview mode :s no it doesn't but i can't lock it anymore now :s It's in the event ReadAttachment Is there an Event DoubleClick?? On Jul 16, 1:07 pm, _-Andy-_ wrote: Hellow, I want to check if the ReadingPane is On in vba. How can i do this? i found a method ShowReadingPane but i can't find an example on how to use it. It's supposed to be a part of a Tableview? Anyone has some suggestions? Thanks in advance- Hide quoted text - - Show quoted text - |
#4
|
|||
|
|||
![]()
Outlook version?
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "_-Andy-_" wrote in message oups.com... I need something else How can i turn the Preview (Reading) Pane off and on? Again i need to know how to call the ShowReadingPane method :s Anyone please? On Jul 16, 2:22 pm, _-Andy-_ wrote: It seems that i found it ![]() If Explorers.Item(1).IsPaneVisible(olPreview) = True Then That's at least one possibility. I use this for a locking mechanisme for files in public folders in outlook. But it locked also in preview mode :s no it doesn't but i can't lock it anymore now :s It's in the event ReadAttachment Is there an Event DoubleClick?? On Jul 16, 1:07 pm, _-Andy-_ wrote: Hellow, I want to check if the ReadingPane is On in vba. How can i do this? i found a method ShowReadingPane but i can't find an example on how to use it. It's supposed to be a part of a Tableview? Anyone has some suggestions? Thanks in advance- Hide quoted text - - Show quoted text - |
#5
|
|||
|
|||
![]()
Outlook 2007
I thought maybe if i would disable the preview addins that it wouldn't lock anymore but it still does :s It still triggers the AttachmentRead Event https://msdn2.microsoft.com/en-us/li...ffice.11).aspx If you need any more info just ask On Jul 16, 9:36 pm, "Sue Mosher [MVP-Outlook]" wrote: Outlook version? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "_-Andy-_" wrote in ooglegroups.com... I need something else How can i turn the Preview (Reading) Pane off and on? Again i need to know how to call the ShowReadingPane method :s Anyone please? On Jul 16, 2:22 pm, _-Andy-_ wrote: It seems that i found it ![]() If Explorers.Item(1).IsPaneVisible(olPreview) = True Then That's at least one possibility. I use this for a locking mechanisme for files in public folders in outlook. But it locked also in preview mode :s no it doesn't but i can't lock it anymore now :s It's in the event ReadAttachment Is there an Event DoubleClick?? On Jul 16, 1:07 pm, _-Andy-_ wrote: Hellow, I want to check if the ReadingPane is On in vba. How can i do this? i found a method ShowReadingPane but i can't find an example on how to use it. It's supposed to be a part of a Tableview? Anyone has some suggestions? Thanks in advance- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#6
|
|||
|
|||
![]()
I use Outlook 2007
And i tried to disable the preview addin for some items but i get the same effect. The AttachmentRead event still gets triggered :s https://msdn2.microsoft.com/en-us/li...ffice.11).aspx If you need more info let me know On Jul 16, 9:36 pm, "Sue Mosher [MVP-Outlook]" wrote: Outlook version? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "_-Andy-_" wrote in ooglegroups.com... I need something else How can i turn the Preview (Reading) Pane off and on? Again i need to know how to call the ShowReadingPane method :s Anyone please? On Jul 16, 2:22 pm, _-Andy-_ wrote: It seems that i found it ![]() If Explorers.Item(1).IsPaneVisible(olPreview) = True Then That's at least one possibility. I use this for a locking mechanisme for files in public folders in outlook. But it locked also in preview mode :s no it doesn't but i can't lock it anymore now :s It's in the event ReadAttachment Is there an Event DoubleClick?? On Jul 16, 1:07 pm, _-Andy-_ wrote: Hellow, I want to check if the ReadingPane is On in vba. How can i do this? i found a method ShowReadingPane but i can't find an example on how to use it. It's supposed to be a part of a Tableview? Anyone has some suggestions? Thanks in advance- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#7
|
|||
|
|||
![]()
The generic method is Explorer.ShowPane, e.g.
application.ActiveExplorer.ShowPane olPreview, False Or, for a table view, set the ShowReadingPane property to False. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "_-Andy-_" wrote in message ups.com... I use Outlook 2007 And i tried to disable the preview addin for some items but i get the same effect. The AttachmentRead event still gets triggered :s https://msdn2.microsoft.com/en-us/li...ffice.11).aspx If you need more info let me know On Jul 16, 9:36 pm, "Sue Mosher [MVP-Outlook]" wrote: Outlook version? "_-Andy-_" wrote in ooglegroups.com... I need something else How can i turn the Preview (Reading) Pane off and on? Again i need to know how to call the ShowReadingPane method :s Anyone please? On Jul 16, 2:22 pm, _-Andy-_ wrote: It seems that i found it ![]() If Explorers.Item(1).IsPaneVisible(olPreview) = True Then That's at least one possibility. I use this for a locking mechanisme for files in public folders in outlook. But it locked also in preview mode :s no it doesn't but i can't lock it anymore now :s It's in the event ReadAttachment Is there an Event DoubleClick?? On Jul 16, 1:07 pm, _-Andy-_ wrote: Hellow, I want to check if the ReadingPane is On in vba. How can i do this? i found a method ShowReadingPane but i can't find an example on how to use it. It's supposed to be a part of a Tableview? Anyone has some suggestions? Thanks in advance- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#8
|
|||
|
|||
![]()
Sorry about the double post i forgot i answered already and it didn't
show. i have some code sample : Private Sub objDocumentItem_BeforeAttachmentPreview(ByVal Attachment As Outlook.Attachment, ByRef Cancel As Boolean) preview = True 'This event will be triggered if the preview pane is on End Sub Private Sub objDocumentItem_BeforeAttachmentRead(ByVal Attachment As Outlook.Attachment, ByRef Cancel As Boolean) Dim strUserName As String Dim olParent As Outlook.DocumentItem Set olParent = Attachment.Parent If preview Then If basLocking.IsLockedDocument(olParent, strUserName) Then preview = False 'if the document is locked it means that someone is busy with it End If End If End Sub Private Sub objDocumentItem_AttachmentRead(ByVal Attachment As Outlook.Attachment) Dim intUserResponse As Integer Dim strClass As String Dim strUserName As String Dim olParent As Outlook.DocumentItem Dim rc As Long, h As Long On Error GoTo ERROR_objDocumentItem_AttachmentRead Set olParent = Attachment.Parent strClass = olParent.MessageClass If preview Then 'It won't do anything special because it will be shown only so it shouldn't be locked or unlocked. Else 'Opens the document in Word or Excel and sets the locking mechanism End if preview = false end sub This code works like it should Only problem is every time when i want to edit a document (so doubleclick on it) i get an error saying that if i want to save my changes i should take "save as". The first time the document won't open. but the second time i try it. It opens and i can start editing. When i save it Outlook crashes and wants to restart itself so i have no other option then to do that. Anyone has some suggestions? Maybe it's best to just turn the preview pane off if it's a document? but how do i do that in code??? On Jul 17, 9:46 am, _-Andy-_ wrote: I use Outlook 2007 And i tried to disable the preview addin for some items but i get the same effect. The AttachmentRead event still gets triggered :shttps://msdn2.microsoft.com/en-us/library/aa209976(office.11).aspx If you need more info let me know On Jul 16, 9:36 pm, "Sue Mosher [MVP-Outlook]" wrote: Outlook version? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "_-Andy-_" wrote in ooglegroups.com... I need something else How can i turn the Preview (Reading) Pane off and on? Again i need to know how to call the ShowReadingPane method :s Anyone please? On Jul 16, 2:22 pm, _-Andy-_ wrote: It seems that i found it ![]() If Explorers.Item(1).IsPaneVisible(olPreview) = True Then That's at least one possibility. I use this for a locking mechanisme for files in public folders in outlook. But it locked also in preview mode :s no it doesn't but i can't lock it anymore now :s It's in the event ReadAttachment Is there an Event DoubleClick?? On Jul 16, 1:07 pm, _-Andy-_ wrote: Hellow, I want to check if the ReadingPane is On in vba. How can i do this? i found a method ShowReadingPane but i can't find an example on how to use it. It's supposed to be a part of a Tableview? Anyone has some suggestions? Thanks in advance- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#9
|
|||
|
|||
![]()
Sorry, but I don't understand what you're trying to accomplish with this code. Maybe you could give us an overview?
i get an error saying that if i want to save my changes i should take "save as". This is perfectly normal if you opened an attachment from the reading pane. Such an attachment is always read-only. Therefore, if you want to save the changes, you must tell Outlook where you want to save them in the file system. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "_-Andy-_" wrote in message ups.com... Sorry about the double post i forgot i answered already and it didn't show. i have some code sample : Private Sub objDocumentItem_BeforeAttachmentPreview(ByVal Attachment As Outlook.Attachment, ByRef Cancel As Boolean) preview = True 'This event will be triggered if the preview pane is on End Sub Private Sub objDocumentItem_BeforeAttachmentRead(ByVal Attachment As Outlook.Attachment, ByRef Cancel As Boolean) Dim strUserName As String Dim olParent As Outlook.DocumentItem Set olParent = Attachment.Parent If preview Then If basLocking.IsLockedDocument(olParent, strUserName) Then preview = False 'if the document is locked it means that someone is busy with it End If End If End Sub Private Sub objDocumentItem_AttachmentRead(ByVal Attachment As Outlook.Attachment) Dim intUserResponse As Integer Dim strClass As String Dim strUserName As String Dim olParent As Outlook.DocumentItem Dim rc As Long, h As Long On Error GoTo ERROR_objDocumentItem_AttachmentRead Set olParent = Attachment.Parent strClass = olParent.MessageClass If preview Then 'It won't do anything special because it will be shown only so it shouldn't be locked or unlocked. Else 'Opens the document in Word or Excel and sets the locking mechanism End if preview = false end sub This code works like it should Only problem is every time when i want to edit a document (so doubleclick on it) i get an error saying that if i want to save my changes i should take "save as". The first time the document won't open. but the second time i try it. It opens and i can start editing. When i save it Outlook crashes and wants to restart itself so i have no other option then to do that. Anyone has some suggestions? Maybe it's best to just turn the preview pane off if it's a document? but how do i do that in code??? On Jul 17, 9:46 am, _-Andy-_ wrote: I use Outlook 2007 And i tried to disable the preview addin for some items but i get the same effect. The AttachmentRead event still gets triggered :shttps://msdn2.microsoft.com/en-us/library/aa209976(office.11).aspx How can i turn the Preview (Reading) Pane off and on? Again i need to know how to call the ShowReadingPane method :s Anyone please? On Jul 16, 2:22 pm, _-Andy-_ wrote: It seems that i found it ![]() If Explorers.Item(1).IsPaneVisible(olPreview) = True Then That's at least one possibility. I use this for a locking mechanisme for files in public folders in outlook. But it locked also in preview mode :s no it doesn't but i can't lock it anymore now :s It's in the event ReadAttachment Is there an Event DoubleClick?? On Jul 16, 1:07 pm, _-Andy-_ wrote: Hellow, I want to check if the ReadingPane is On in vba. How can i do this? i found a method ShowReadingPane but i can't find an example on how to use it. It's supposed to be a part of a Tableview? |
#10
|
|||
|
|||
![]()
Mm it seems that sometimes the reply doesn't get shown in the
discussiongroup or not that fast :s i put a reply on yesterday sorry if this will be the same post again. i added some events that will be triggered Private Sub objDocumentItem_BeforeAttachmentPreview(ByVal Attachment As Outlook.Attachment, ByRef Cancel As Boolean) preview = True 'This will get triggered if the preview pane / reading pane is on. End Sub Private Sub objDocumentItem_BeforeAttachmentRead(ByVal Attachment As Outlook.Attachment, ByRef Cancel As Boolean) Dim strUserName As String Dim olParent As Outlook.DocumentItem Set olParent = Attachment.Parent If preview Then 'This will get triggered between the BeforeAttachmentPreview and AttachmentRead event. It will check if the document is locked. If basLocking.IsLockedDocument(olParent, strUserName) Then 'if it's locked the locking mechanism will handle it preview = False End If End If End Sub Private Sub objDocumentItem_AttachmentRead(ByVal Attachment As Outlook.Attachment) Dim intUserResponse As Integer Dim strClass As String Dim strUserName As String Dim olParent As Outlook.DocumentItem Dim rc As Long, h As Long On Error GoTo ERROR_objDocumentItem_AttachmentRead Set olParent = Attachment.Parent strClass = olParent.MessageClass If preview Then 'this works like it should i can see the preview without the document being locked. 'It won't do anything special because it will be shown only so it shouldn't be locked or unlocked. Else 'Opens the document in Word or Excel and sets the locking mechanism 'This will go off if the document is doubleclicked in Outlook. 'This will generate an error saying the file is already been viewed by some application (Outlook) 'The second time i try to open a document it will open but i still get an error saying that all changes will be lost if i don't save as ... 'If i still save it on the original file it will save but Outlook will crash :s 'I'm assuming this is because outlook had opened the file in preview and it couldn't handle the new document being saved. End if preview = false end sub Maybe the best solution is to check if it's a document that is selected and turn the preview / reading pane off and if it's a normal email to turn the pane on. But how do i do that? I couldn't find that yet :s Greetings, Andy On 17 jul, 09:46, _-Andy-_ wrote: I use Outlook 2007 And i tried to disable the preview addin for some items but i get the same effect. The AttachmentRead event still gets triggered :shttps://msdn2.microsoft.com/en-us/library/aa209976(office.11).aspx If you need more info let me know On Jul 16, 9:36 pm, "Sue Mosher [MVP-Outlook]" wrote: Outlook version? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "_-Andy-_" wrote in ooglegroups.com... I need something else How can i turn the Preview (Reading) Pane off and on? Again i need to know how to call the ShowReadingPane method :s Anyone please? On Jul 16, 2:22 pm, _-Andy-_ wrote: It seems that i found it ![]() If Explorers.Item(1).IsPaneVisible(olPreview) = True Then That's at least one possibility. I use this for a locking mechanisme for files in public folders in outlook. But it locked also in preview mode :s no it doesn't but i can't lock it anymore now :s It's in the event ReadAttachment Is there an Event DoubleClick?? On Jul 16, 1:07 pm, _-Andy-_ wrote: Hellow, I want to check if the ReadingPane is On in vba. How can i do this? i found a method ShowReadingPane but i can't find an example on how to use it. It's supposed to be a part of a Tableview? Anyone has some suggestions? Thanks in advance- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reading Pane | bfarr | Outlook - General Queries | 1 | February 23rd 07 01:39 PM |
Reading Pane Settings | Paul Rocca | Outlook and VBA | 2 | February 22nd 07 09:43 AM |
Reading Pane Not Available | Bob Newman | Outlook - General Queries | 2 | December 26th 06 03:11 PM |
View - Reading Pane | DRVMODSS | Outlook - Using Forms | 1 | December 15th 06 10:03 PM |
Reading Pane | TerryM | Outlook - Installation | 1 | May 14th 06 01:59 AM |