A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Reading Pane in vba



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old July 16th 07, 12:07 PM posted to microsoft.public.outlook.program_vba
_-Andy-_
external usenet poster
 
Posts: 10
Default Reading Pane in vba

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  
Old July 16th 07, 01:22 PM posted to microsoft.public.outlook.program_vba
_-Andy-_
external usenet poster
 
Posts: 10
Default Reading Pane in vba

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  
Old July 16th 07, 02:57 PM posted to microsoft.public.outlook.program_vba
_-Andy-_
external usenet poster
 
Posts: 10
Default Reading Pane in vba

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  
Old July 16th 07, 08:36 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Reading Pane in vba

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  
Old July 17th 07, 08:23 AM posted to microsoft.public.outlook.program_vba
_-Andy-_
external usenet poster
 
Posts: 10
Default Reading Pane in vba

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  
Old July 17th 07, 08:46 AM posted to microsoft.public.outlook.program_vba
_-Andy-_
external usenet poster
 
Posts: 10
Default Reading Pane in vba

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  
Old July 17th 07, 01:16 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Reading Pane in vba

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  
Old July 17th 07, 02:16 PM posted to microsoft.public.outlook.program_vba
_-Andy-_
external usenet poster
 
Posts: 10
Default Reading Pane in vba

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  
Old July 17th 07, 02:34 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Reading Pane in vba

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  
Old July 18th 07, 10:53 AM posted to microsoft.public.outlook.program_vba
_-Andy-_
external usenet poster
 
Posts: 10
Default Reading Pane in vba

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 11:09 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.