Solved

Error coming up when using "GetItemFromID"

Posted on 2012-03-31
10
724 Views
Last Modified: 2012-04-06
Hi Team,

I am trying to run the given below code and I am not able to proceed further as it is giving me some error.  It had run for a couple of times, but stoped working all of a sudden.

Given below is the code.

Private Sub cmdViewEmail_Click()
    Dim olFolder As Outlook.MAPIFolder
    Dim olConversationIndex As String
   
    olConversationIndex = [Form_qryEmails&Comments subform].Conservation_Index
    Set olFolder = GetOlFolder("\\Mailbox - Operations Collections\Inbox")
   
    Set Test = olFolder.Session.GetItemFromID("0101CD0EB640F8EC9BCA09902E4383A0DE3146196E1A9683932700800178B580")
    Test.Display
   
End Sub


Given below is the error I get when I try to run the above code.

Error Screen shot.
I also did some further testing and it seems to work for certain emails and does work for certain emails.  Please note the folder has only emails, no calander or task etc..

Thanks,
Sandesh.
0
Comment
Question by:Sandesh555
10 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 37792548
Are you sure that an Item with that ID exists?
0
 
LVL 2

Expert Comment

by:adamnl
ID: 37793041
If they exist, are they in \Mailbox - Operations Collections\Inbox ?
0
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 500 total points
ID: 37793374
Also, I don't see a declaration for Test.  Is it supposed to be a MailItem?

And in this line:  olConversationIndex = [Form_qryEmails&Comments subform].Conservation_Index

you have "Conservation_Index" and "olConversationIndex".  Shouldn't they both be Conversation?
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:Sandesh555
ID: 37794550
Hi Team,

Each and every mail item that I have captured in my database exits and In case of the given coding, sorry for the confusion.  I had included only a part of the code and did not remove all the not related lines.  Here is the code again.

Private Sub cmdViewEmail_Click()
    Dim olFolder As Outlook.MAPIFolder
   
    Set olFolder = GetOlFolder("\\Mailbox - Operations Collections\Inbox")
   
    Set Test = olFolder.Session.GetItemFromID("0101CD0EB640F8EC9BCA09902E4383A0DE3146196E1A9683932700800178B580")
    Test.Display
   
End Sub

GetOlFolder() here is a small function which converts the given Outlook folder path into a proper MAPI Folder path.

I did try to declare Test as a MailItem, but was getting same error.  Please note I problem here is that this code is working for a few emails and does not work for a few emails.

Thanks,
Sandesh.
0
 
LVL 2

Expert Comment

by:adamnl
ID: 37797568
What is the difference between the mails for which it does work and the mails for which it does not?
0
 

Author Comment

by:Sandesh555
ID: 37799713
Not much all of them are emails sent and recived by the customer.
0
 

Author Comment

by:Sandesh555
ID: 37799853
HI Team,

I did some testing and found out that all the emails that have been sent from my domain is coming up in the dispaly, but all the emails that have been sent by external team is not wokring.

I am also giving you  the question were I got this solution.

http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_27655636.html

Thanks,
Sandesh.
0
 

Author Comment

by:Sandesh555
ID: 37802882
Hi Team,

After doing some additinal testing I found that the first time I use this code.  It works for all emails.  But later it starts to work only on emails sent from my domain.

I think we jsut need to clear some memory somewere.  All I need to know is what is it that I need to clear.

Thanks,
Sandesh.
0
 

Author Comment

by:Sandesh555
ID: 37803007
Hi Team,

I have found the solution locally, though another developer.

thanks for looking into the same.

Thanks,
Sandesh.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question