Le Café Central de

                 ... Deva blogs!!

  • Le Café Central de DeVa

    OOM : How to retrieve Outlook attachments ( Reference, Value, Embedded and OLE) using VBA?


    Please find the following code snippet for retrieving various Outlook attachments  - Reference, Value, Embedded and OLE using Outlook Object Model (OOM) & VBA:

    'Code Snippet : How to retrieve Outlook attachments using Visual Basic for Application (VBA)
    Dim omailitem As Outlook.MailItem
    Dim oattach As Outlook.Attachment
    Dim ofolder As Outlook.Folder
    Set ofolder = Application.Session.PickFolder
    Debug.Print "Total Items available in Folder : " & ofolder.Items.Count
    For Each Item In ofolder.Items
    Set omailitem = Item
    Debug.Print "Item Subject :" & omailitem.Subject & " Size (in bytes):" & omailitem.Size
    If omailitem.Attachments.Count > 0 Then
    For Each oattach In omailitem.Attachments
    If oattach.Type = Outlook.olByReference Then
    Debug.Print "By reference : " & oattach.FileName & " Size (in bytes) : " & oattach.Size
    ElseIf oattach.Type = Outlook.olByValue Then
    Debug.Print "By Value : " & oattach.FileName & " Size (in bytes) : " & oattach.Size
    ElseIf oattach.Type = Outlook.olEmbeddeditem Then
    Debug.Print "Embedded item : " & oattach.FileName & " Size (in bytes) : " & oattach.Size
    ElseIf oattach.Type = Outlook.olOLE Then
    Debug.Print "OLE : " & oattach.FileName & " Size (in bytes) :" & oattach.Size
    End If
    Debug.Print "-------------------"
    End If

    - olByReference The attachment is a shortcut to the location of the original file.
    - olByValue The attachment is a copy of the original file and can be accessed even if the original file is removed.
    - olEmbeddeditem The attachment is an Outlook message format file (.msg) and is a copy of the original message.
    - olOLE The attachment is an OLE document

    You can also get more info from : http://msdn.microsoft.com/en-us/library/aa220737(office.11).aspx

    Result will be like this (sample data provided for your view):

    Total Items available in Folder : 3
    Item Subject :Fw: Mormons and Roses - A "Cheers" TV Show ClipSize (in bytes):4057344
    By Value : Mormonscantsendflowers_1.wmvSize (in bytes) : 4054264
    Item Subject :Rate spectrum on exotic position JEX and JNKSize (in bytes):2537614
    By Value : JNK_JEX_IR.xls Size (in bytes) : 2525885
    Item Subject :Fw: Blue Angles in San Francisco(May be a repeat)Size (in bytes):741293
    By Value : image001.jpg Size (in bytes) : 61862
    By Value : image002.jpg Size (in bytes) : 59804
    By Value : image003.jpg Size (in bytes) : 81551
    By Value : image004.jpg Size (in bytes) : 48063
    By Value : image005.jpg Size (in bytes) : 62174
    By Value : image006.jpg Size (in bytes) : 55008
    By Value : image007.jpg Size (in bytes) : 76879
    By Value : image008.jpg Size (in bytes) : 42201
    By Value : image009.jpg Size (in bytes) : 45637
    By Value : image010.jpg Size (in bytes) : 56987
    By Value : image011.jpg Size (in bytes) : 2308
    By Value : image012.jpg Size (in bytes) : 97229
    By Value : image013.jpg Size (in bytes) : 28169

  • Le Café Central de DeVa

    Download : Microsoft 2007 Office Suite Service Pack 2


    Now, you can download Microsoft Office Suite Service Pack 2 which provides the latest updates to the 2007 Office Suite.

    It consists of,

    • Previously unreleased fixes that were made specifically for this service pack.
      • In addition to general product fixes, this includes improvements in stability, performance, and security.
      • You can find out more information in Knowledge Base Article 953195, where product-specific changes are described.
    • All of the Public Updates, Security Updates, Cumulative Updates, and Hotfixes released through February 2009.

    NOTE: Before installing this service pack, you are strongly encouraged to read 953195, which describes some big improvements introduced by SP2, and also calls out some important information that you should be aware of before installing.

    With respect to Outlook 2007...

    Microsoft Office Outlook 2007 Service Pack 2 (SP2) is a user-focused update that contains significant improvements in performance and in calendar reliability.  Also you can hear more from Janes Liles, Group Program Manager talks about the enhancements about the Service Pack 2 in the Microsoft Presspass. Per her words, "...Outlook 2007 SP2 is 26 percent faster than its predecessor on a set of common e-mail tasks and is even faster, 35 percent, with larger mailboxes. Users will experience considerable responsiveness and speed improvements on common, day-to-day operations like launching, synchronizing and searching..."

    With regards to Outlook 2007, some of the improvements were:

    • Performance improvements that apply to the following general responsiveness areas:
      • Startup: Removes lengthy operations from initial startup.
      • Shutdown: Makes Outlook exit predictably despite pending activities.
      • Folder View and Switch: Improves view rendering and folder switching.
    • Calendar improvements: Improves underlying data structures and the general reliability of calendar updates.
    • Data file checks: Greatly reduces the number of scenarios in which you receive the following error message when you start Outlook:

      The data file 'file name' was not closed properly. This file is being checked for problems.

    • Search reliability: Improves search reliability when you use SP2 with Windows Desktop Search 4 (http://www.microsoft.com/windows/products/winfamily/desktopsearch/choose/windowssearch4.mspx) .
    • Improvements to Really Simple Syndication (RSS): There are now fewer duplicated items.
    • Object Model improvements: Now contains many customer-driven fixes.
    With respect to KB's (1) (2), towards Outlook Service Pack  we have some related details regarding the known issues and behavior changes (please refer the (1) (2) "Known issues" and "Behavior ChangesP sections. Some of them were,
    • In Outlook, assume that a meeting organizer sends a meeting request to an attendee by using a POP account. Then, the attendee responds to the meeting request and types a message in the response. In this situation, the organizer receive the response, but the message contents may be lost.
    • 968773 When Outlook 2007 is running in Cached mode, users do not see some new e-mail messages.
    • The .cnt, .osd, .vbp, and .hpj file attachments were added to the Outlook blocked extension list. For more information, visit the following Microsoft Web site:Outlook's previously blocked extensions (http://office.microsoft.com/en-us/outlook/HA012299521033.aspx?pid=CH100777061033) .
    • Items in the mail message list shift temporarily while you are running an All Mail Item search in Online Mode.
    • When you use Outlook 2007 SP2 together with Outlook Live Connector 12.1, duplicate entries occur in the Calendar and in Contacts. This is true unless all clients that are connected to the account are upgraded to SP2.
    For a detailed information with respect to Outlook 2007 Improvements (Performance, Calendar and General), reliability and Time Zone related info, please refer the following support KB: http://support.microsoft.com/kb/968774/

    Please note: This Service pack will also update the following products:
    • Microsoft® Office Basic 2007
    • Microsoft® Office Enterprise 2007
    • Microsoft® Office Home and Student 2007
    • Microsoft® Office Professional 2007
    • Microsoft® Office Professional Plus 2007
    • Microsoft® Office Small Business 2007
    • Microsoft® Office Small Business Management 2007
    • Microsoft® Office Standard 2007
    • Microsoft® Office Ultimate 2007
    • Microsoft® Office Access® 2007
    • Microsoft® Office Excel® 2007
    • Microsoft® Office InfoPath® 2007
    • Microsoft® Office Outlook® 2007
    • Microsoft® Office PowerPoint® 2007
    • Microsoft® Office Publisher® 2007
    • Microsoft® Office Word 2007
    • Microsoft® Office OneNote® 2007
    • Microsoft® Office Groove® 2007

    Hope this helps.

  • Le Café Central de DeVa

    Download : Where i can download fully configured Exchange Server 2007 SP1 VHD’s?


    If you’re exchange admin or exchange developer who want to test/evaluate/create sample application(s), then you can download the following Exchange Server 2007 x64 for Hyper-V and Exchange Server 2007 SP1 VHD’s for Virtual PC, Virtual Server.

    You can use this for a limited period and try it; you can evaluate the new capabilities of Exchange Server 2007, which deliver the advanced protection your company demands, the anywhere access people throughout your organization want, and the operational efficiency you need.

    Download fully configured Exchange Server 2007 SP1 x64 (64 bit edition) VHD (works with Hyper-V):

    You can download Exchange Server 2007 x64 (64 bit edition) VHD from the following Microsoft download location: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=db31866c-2cd5-4610-8505-5f2572248618

    Note: To use this above VHD, you need to have Hyper-V enabled machines to work with this build.

    Download Exchange Server 2007 SP1 VHD (works with Virtual PC, Virtual Server):

    You can download Exchange Server 2007 SP1 VHD from the following Microsoft download location: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e99f2a96-ffbc-4323-9676-9657607c4a52

    Note: A virtualization product that supports the VHD format is required to use this virtual machine. Microsoft Virtual PC or Microsoft Virtual Server are provided for free and can be used with these VHD based virtual machines.

  • Le Café Central de DeVa

    Monitoring event sink # 30 – How to enumerate Store Event Sink registered in a inbox ?


    We can enumerate the store event sink as given below:

    'This command helps us to enumerate the list of registered store event sink's with the 
    'administrator user's inbox available in contoso.com
    C:\> cscript regevent.vbs enum "file://./backofficestorage/contoso.com/mbx/administrator/inbox" all
  • Le Café Central de DeVa

    Download : Wanna try Microsoft Exchange Server 2010 beta?



    Do you wonder how Exchange Server 2010 (beta) will be look like? You can find more information from its exclusive TechNet site: http://technet.microsoft.com/en-us/exchange/2010/default.aspx

    Microsoft Exchange Server 2010 helps you achieve new levels of reliability and performance by delivering features that help to simplify your administration, protect your communications, and delight your users by meeting their demands for greater business mobility.

    Microsoft Exchange Server 2010 Beta helps IT Professionals achieve new levels of reliability with greater flexibility, enhanced user experiences, and increased protection for business communications.

    • Flexible and reliable - Exchange Server 2010 gives you the flexibility to tailor your deployment based on your company's unique needs and a simplified way to keep e-mail continuously available for your users.
    • Anywhere access - Exchange Server 2010 helps your users get more done by giving them the freedom to securely access all their communications - e-mail, voice mail, instant messaging, and more - from virtually any platform, Web browser, or device.
    • Protection and compliance - Exchange Server 2010 delivers integrated information loss prevention, and compliance tools aimed at helping you simplify the process of protecting your company's communications and meeting regulatory requirements.

    This software is intended for evaluation purposes only.

    You must accept the license terms before you are authorized to use this software. There is no product support for this trial software. You are welcome to participate in the forums to share your trial experiences with others and to ask for advice.

    Before you install the Exchange Server 2010 Beta, we recommend that you review the summary of system requirements and technical information located in the Exchange Server 2010 Technical Documentation Library.

    You can download the Exchange Server 2010 beta by clicking the hyperlink specified in the Microsoft Download Center location.

  • Le Café Central de DeVa

    Download Microsoft Exchange Web Services (EWS) Managed API 1.0 Beta


    If you’re developer who use Microsoft Exchange Web Services to develop client applications, then this is for you to download and play around with it.

    The Microsoft Exchange Web Services (EWS) Managed API 1.0 Beta provides a managed interface for developing client applications that use Exchange Web Services. The EWS Managed API simplifies the implementation of applications that communicate with Microsoft Exchange Server 2007 Service Pack 1 (SP1) and later versions of Microsoft Exchange. Built on the Exchange Web Services SOAP protocol and Autodiscover, the EWS Managed API provides a .NET interface to EWS that is easy to learn, use, and maintain.

    It’s available for both 32 and 64 bit environments:
    For x64 (64-bit) computers, download and run EwsManagedApi.msi
    For x86 (32-bit) computers, download and run EwsManagedApi32.msi

    It can be downloaded from Microsoft Download Center.

  • Le Café Central de DeVa

    OOM & VBA : How to delete Outlook recurring Task items (whose status marked as Completed)

    '[VBA & Outlook Object Model : Code snippet to delete Outlook recurring Task items (whose status marked as Completed)]
    'Declaration part
    dim otaskitem as Outlook.Taskitem
    dim ofolder as Outlook.Folder
    'Get the Task items
    set ofolder = Application.Session.GetDefaultFolder(olFolderTasks)
    For each item in ofolder.items
    set otaskitem = Item
    'Check the status of the specific Taskitem is "Completed" or not
    if otaskitem.Status = olTaskcomplete then
    'Msgbox "Completed Tasks"
    'Msgbox "Not Completed Tasks"
    end if
Page 1 of 1 (7 items)