Menu
  • HOME
  • TAGS

Open an .OST file in Outlook 2013

Tag: outlook-vba,outlook-2010,outlook-2013

I want to open an OST file in Outlook 2013. I understand the difference between ost and pst. The reason I need to do this is that after a harddrive failure, I am unable to look at how a user had their local archive set up. I was hoping I could look at a recovered copy of their .OST and see how each of their folders was set to archive.

Can anyone point me in the right direction? I am reading differing opinions on whether an OST file can be accessed. TIA

Best How To :

If you want to access OST file, then you have to convert it into PST file first as PST files are the ones that can be imported into Outlook, not OST file. To do the same, you can use any OST to PST Converter. You can give a shot to Stellar OST to PST converter for the same - http://www.stellarphoenixrecovery.com/ost-extractor.php

Outlook 2010 VBA code to show alias of recipient

email,outlook,alias,outlook-vba

With all your help I was able to solve this by capturing recipient address entry, adding it as a new item, showing alias, then deleting the recipient: Sub ReadRecpDetail() Dim myOlApp As Outlook.Application Dim myItem As Outlook.mailItem Dim myRecipient As Outlook.recipient Dim recipient As Outlook.recipient Dim SMTPaddress As String Dim...

Outlook VBA Items.Count wierdness

vba,outlook,outlook-vba

Use the Sort method of the Items class to sort the collection of items by the specified property. Sort only affects the order of items in a collection. It does not affect the order of items in an explorer view. Sub SortByRecievedDate() Dim myNameSpace As Outlook.NameSpace Dim myFolder As Outlook.Folder...

Outlook VBA - set sentonbehalf and Refresh ActiveInspector

vba,email,outlook,outlook-vba

To make the From label show the right value, you need to set the PR_SENT_REPRESENTING_EMAIL_ADDRESS property (DASL name http://schemas.microsoft.com/mapi/proptag/0x0065001F) using MailItem.PropertyAccessor.SetProperty. UPDATE: As a test, you can try to run the following script from OutlookSpy - create a new message in Outlook, click "Script" button on the OutlookSpy Ribbon in...

Outlook 2010 ignores font-family

html,css,outlook-2010,newsletter,fontfamily

taking an answer from the golden days of HTML4(and earlier) Specify the font size, font face and color of text: <font size="3" color="red">This is some text!</font> <font size="2" color="blue">This is some text!</font> <font face="verdana" color="green">This is some text!</font> Using font face usually solved outlook woes for me. Basically when developping...

Macro to run outlook rule every 5 minutes

vba,outlook-vba

You need to use a timer to be able to run the code periodically. See Outlook VBA - Run a code every half an hour for more information and sample code.

VBA Like Operator

vba,pattern-matching,outlook-vba,sql-like

Look for the exceptions, then compare with the wildcard: Select Case UCase$(Left$(subject, 3)) Case "RE:", "AW:": '// is reply Case Else If subject Like "*XXX*YYY*" Then MsgBox "Hello" End If End Select ...

Save emails daily incorporating if filename are duplicates

vba,outlook,outlook-vba

To save with Date Time Seconds & Subject you could do sName = Format(dtDate, "MM-DD-YYYY", vbUseSystemDayOfWeek, _ vbUseSystem) & Format(dtDate, "-hhnnss", _ vbUseSystemDayOfWeek, vbUseSystem) & "-" & sName & ".msg" ...

VBA Script to move emails to folders created daily

vba,outlook,outlook-vba,outlook-2010

To process incoming emails you need to handle the NewMailEx event or create a rule which can run a VBA macro sub. The VBA macro sub should look like the following one: public sub test(mail as MailItem) ' do whatever you need end sub In the code you can check...

E-mailing selected Range in Excel/Outlook

excel,vba,excel-vba,outlook-vba,automated-deployment

First off, you have not declared SendRange As a range. The line: Dim SendRange, rng As Range declares SendRange As a variant and rng As a range. change this to: Dim SendRange As Range, rng As Range Second, change the line: Set Sendrng = Worksheets("ValLog").Range("B5:K12").Select to: Set Sendrng = Worksheets("ValLog").Range("B5:K12")...

Automation in PowerShell/VBScript/Other : Reminder via mail/other based on date value in excel

vba,email,excel-vba,powershell,outlook-vba

Ideally the computer isn't shut down, else you'd have to use WoL to wake it up. You should create a scheduled task which runs even when the user isn't logged on: Below is sample script for your reference, I'm not actually adding the values to the email body - you...

Using Excel VBa to send Outlook e-mails

vba,excel-vba,outlook-2010

Look at Ron de Bruin's site for great ways of creating emails. The linked page shows how to get Excel to do the hard work of turning a range into an HTML email.

Save emails to daily folders

vba,outlook,outlook-vba

It seems like you are missing the dash between the filename and the last folder. After adding & "\" behind strFolder = "C:\IT Documents\" & daymonthyr & strNewFolder it works for me....

Combining functions for auto attachment

vba,outlook,outlook-vba

What I actually would do instead is: Sub AddAttachment(Item As Outlook.MailItem) Dim myOlApp As Outlook.Application Dim myItem As Outlook.MailItem Dim myAttachments As Outlook.Attachments Set myOlApp = CreateObject("Outlook.Application") Set myItem = myOlApp.CreateItemFromTemplate("C:\Templates\test upload file.oft") Set myAttachments = myItem.Attachments myAttachments.Add "C:\TEST\" & Format(Date, "yymmdd") & "ABCDE.txt" myItem.Send End Sub Hope this helps...

Is it possible to reload outlook Office.ComAddIn list?

c#,outlook,outlook-addin,outlook-2010

The Update method of the COMAddins collection is used to refresh the list of COM add-ins from the Windows registry. But why do you need to create a new Outlook application instance in the code? Do you develop an Outlook add-in? If so, you can use the Application property of...

VBA to forward email with its attachment in Outlook 2010

email-attachments,outlook-vba

There is no need to use the Explorer object in the code: Sub ForwardEmail(item As Outlook.MailItem) Dim oMail As MailItem On Error GoTo Release If item.Class = olMail Then Set oMail = item.Forward oMail.Subject = oMail.Subject oMail.HTMLBody = "Have a nice day." & vbCrLf & oMail.HTMLBody oMail.Recipients.Add "email address here"...

Get email address from email body in outlook vba

vba,email,excel-vba,outlook-vba

So, I managed to figure this one out: When some emails bounce back, they seem to fail to include a "To" field, so Outlook does not consider that a MailItem. Since olMail had been declared as an Outlook.MailItem, when iterating through the Items collection, it would exit the sub once...

VBA Outlook TypeLib.GUID “Object required”

vba,outlook-vba

Problem solved with this bit. Don't understand much how it works but it does the job....

Automatically insert email signature into Outlook Meeting Invite

vba,outlook,outlook-addin,outlook-vba

Outlook 2010 and newer include the form designer. File -> Options -> Customize Ribbon, then, in the Right Side pane, click to turn on the Developer Tab. From there you can design Meeting Request template to your specification. Then, to use it, you will select: New -> Meeting Request Using...

Public folders in vba

vba,word-vba,outlook-vba

You need not specify the user. Sub AddContactsFolder() Dim myNameSpace As Outlook.Namespace Dim myFolder As Folder Dim myNewFolder As Folder Dim TopPublicFolder As Folder Set myNameSpace = Application.GetNamespace("MAPI") Set TopPublicFolder = myNameSpace.GetDefaultFolder(olPublicFoldersAllPublicFolders) Set myFolder = TopPublicFolder.Folders("Prototech").Folders("Avd. 150 R&D") Set myNewFolder = myFolder.Folders.Add("AAAAA") End Sub ...

Missing Outlook MailItem Properties in Application_ItemSend

outlook,outlook-vba

Sender related properties are populated only after the message is actually sent and moved to the Sent Items folder. By the time Application.ItemSend event fires, the message is still unsent. The earliest you can access the sent message with all the properties populated is in the Items.ItemAdd event on the...

Save only emails of today

vba,email,outlook,outlook-vba

Seems like you intended to use the Item.ReceivedTime to create your folder, but after you pull this value into dtDate, it never gets used. Perhaps try the following instead: strNewFolder = Format(dtDate, "mm-dd-yyyy") ^^ ...

Outlook mail with excel: Issue with body text and variable

excel,vba,outlook-vba

The .body property of the mailItem does not append additional infomation into the body, it entirely REPLACES the information in the body. So when you set it the first time with the "Hello" portion, the email body contains this information. When you set it again in your loop, it now...

Open an .OST file in Outlook 2013

outlook-vba,outlook-2010,outlook-2013

If you want to access OST file, then you have to convert it into PST file first as PST files are the ones that can be imported into Outlook, not OST file. To do the same, you can use any OST to PST Converter. You can give a shot to...

Outlook Add Items quits working - Items_ItemAdd(ByVal Item As Object)

vba,outlook-vba,outlook-2010

your code works find, if you are trying to get the msg box to pop then Move this line code MsgBox ("It Worked!") next to If TypeName(item) = "MailItem" Then MsgBox ("It Worked!") here is complete code tested on Outlook 2010 Private WithEvents Items As Outlook.Items Private Sub Application_Startup() Dim...

Why can't I access subfolders of a shared mailbox?

outlook-vba

Is "Download shared folders" check box checked on the Advanced tab of your Exchange account properties dialog? Try to uncheck it....

Outlook VBA how to improve speed when looking thru a folders list

vba,outlook-vba

You have too many dots in the loop for one. Here's a general VBA speed post of mine. When setting properties or calling methods, each is a function call in the CPU. That means stack setup overhead. Function calls are slower than inline code. Use loops rather than functions in...

I have a list of email addresses in excel that i need to send emails to. The subject and body are in cells besides the email address

excel-vba,excel-2010,outlook-vba

Mail_Object.CreateItem(o) Shouldn't that be Mail_Object.CreateItem(0) 0 and not o In the below code, you are not required to set a reference to MS Outlook Object Library. I am using Late Binding with MS Outlook. Try this (Untested) I have commented the code so you shall not have a problem...

Auto Reply with notes, email body and add CC

vba,outlook-vba,outlook-2010

Try Recipient not Recipients Dim olRecipient As Outlook.Recipient ...

Copying Outlook email body to .csv

vba,csv,outlook,outlook-vba,outlook-2010

Switch the Chr(58)) to varItem = Split(varText(i), Chr(9)) Look at VBA Chr...

VBA not Recognizing MAPI

excel,vba,excel-vba,outlook,outlook-vba

Namespace() will be valid in Outlook VBA since there is an intrinsic Application variable that points to the Outlook.Application object and the variable is global. i.e. all of its properties and methods are available without specifying "Application.*" In case of Excel VBA, Application points to an instance of the Excel.Application...

Process zip attachments outlook vba script

vba,outlook,outlook-vba

The Attachment class provides the Size property which returns a Long indicating the size (in bytes) of the attachment. To get the uncompressed size you need to save the attached file on the disk and then extract the content. The SaveAsFile method of the Attachment class saves the attachment to...

How to capture “Print Tab” click event at the backstage in Outlook 2010 ?

outlook,outlook-addin,outlook-2010,office-addins

The command tag will not play any role in case of backstage UI controls. You can repurpose only controls on the ribbon (not backstage). See Temporarily Repurpose Commands on the Office Fluent Ribbon for more information. A possible solution would be to consider hiding the built-in UI and rebuilding it...

How to provide padding/margin on a text on top of an image in Outlook 2010, Outlook 2007, Outlook 2013?

html,css,outlook,html-email,outlook-2010

div padding is ignored in outlook. Your best bet is to insert a table inside the div and then pad the TDs inside of it. There were some other errors in your code, that i made changes to in the below, but this works in Outlook. I would also recommend...

How to apply softedges to an Outlook email photo

excel,excel-vba,outlook-vba

You can use the Word object model model to modify the email body. The WordEditor property of the Inspector class returns an instance of the Word Document class which represents the message body. You can read more about all possible ways in the Chapter 17: Working with Item Bodies in...

VBA outlook application.wait not working

vba,outlook,outlook-vba

You can create a Sub that will mimic the Application.Wait, something like. Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) 'For 64-Bit 'Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Public Sub Pause(intSeconds As Variant) ' Comments: Waits for a specified number of seconds ' Params...

vba macro outlook attachments send then move

vba,outlook,outlook-vba,outlook-2010

It is not clear where you run the VBA macro code (Outlook, Word, Excel and etc.). Anyway, there is no need to create a new Outlook Application instance in the Outlook VBA macro: '// Create the Outlook session. Set objOutlook = CreateObject("Outlook.Application") Instead, you can use the Application property, for...

Add a “CC recipient” to Outlook 2010 VBA

outlook,outlook-vba

set oRecip = oMail.Recipients.Add("email address here") oRecip.Type = olCC or oMail.CC = "email address here" ...

My outlook VBA code can't find a specific folder

vba,outlook,folder,outlook-vba

Figured it out thanks to the following link: Get MAPI Folder in Outlook from Folder Path. By right clicking on the folder I could see the actual location was on William and not directly on the folder. So the right code is: Set objFolder = objnSpace.folders("William").folders("#MemoScan")...

Is it possible to select a folder based on it's name rather then on it's path? VBA - Outlook

vba,outlook,folder,outlook-vba

The Namespace class provides the Stores property which returns a Stores collection object that represents all the Store objects in the current profile. The Store class provides the GetRootFolder method which returns a Folder object representing the root-level folder of the Store. You can use the GetRootFolder method to enumerate...

How to call the quit/close event in outlook 2007 VBA

vba,outlook,outlook-vba

Set myOlApp = CreateObject("Outlook.application") There is no need to create a new Outlook instance. You should use the Application property availble in Outlook VBA. Private Sub Application_Quit() MsgBox "Goodbye, " & Application.GetNamespace("MAPI").CurrentUser End Sub Take a look at the Getting Started with VBA in Outlook 2010 article in MSDN....

How to send outlook email automatically using Excel UserForm?

email,excel-vba,outlook-vba,sendkeys

You need to use the Send method of Outlook items instead. The Send method sends an item using the default account specified for the session. In a session where multiple Microsoft Exchange accounts are defined in the profile, the first Exchange account added to the profile is the primary Exchange...

How to test if the email is a regular email or reply?

vba,outlook-vba,outlook-2013

You note that the problem happens when you encounter a message which is either a reply or a forward. One thing both of those have in common is a prefix on the subject, like "RE: something" or "FW: something else". Note the colon in the prefix. I don't see you...

ThisOutlookSession code Working in one account but not working in another Account when copying the code. VBA Outlook 2007

vba,outlook,outlook-vba

Got it fixed! I tried to generate a new OTM file at the second user but I kept getting the error that outlook was still open/OTM was still in use. So I opened up Task Manager and ended Outlook. Suddenly, the quit event seems to work.. ...

Retrieve Outlook details based on alias name Excel VBA

excel,vba,excel-vba,outlook,outlook-vba

Alias as in Windows login alias? Try Namespace.ResolveName - GAL provider will resolve based on the login alias.