(Excel) Outlook -- Create a Mail Folder

Creates a new mail folder as a child of an existing mail folder.

Note: This example requires Chilkat v9.5.0.68 or greater.

This example applies to: Exchange Online | Office 365 | Hotmail.com | Live.com | MSN.com | Outlook.com | Passport.com

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Use your previously obtained access token here:
http.AuthToken = "MICROSOFT_GRAPH_ACCESS_TOKEN"

' This example will create a new mail folder as a child of /Inbox/abc

' Get the existing folder ID from the folder map created by this example 
Dim htFolderMap As Chilkat.Hashtable
Set htFolderMap = Chilkat.NewHashtable
Dim sbMap As Chilkat.StringBuilder
Set sbMap = Chilkat.NewStringBuilder
Dim success As Boolean
success = sbMap.LoadFile("qa_data/outlook/folderMap.xml","utf-8")
success = htFolderMap.AddFromXmlSb(sbMap)


existingFolderId = htFolderMap.LookupStr("/Inbox/abc")
If (htFolderMap.LastMethodSuccess <> True) Then
    Debug.Print "Folder ID not found"
    Exit Sub
End If

' Create a JSON request body with this content:
' 
' 	{
' 	  "displayName": "displayName-value",
' 	}

' This example will create /Inbox/abc/subFolderC
Dim jsonRequestBody As Chilkat.JsonObject
Set jsonRequestBody = Chilkat.NewJsonObject
success = jsonRequestBody.UpdateString("displayName","subFolderC")

success = http.SetUrlVar("folder_id",existingFolderId)

' Create the folder "subFolderC" at the specified location.

Set resp = http.PostJson2("https://graph.microsoft.com/v1.0/me/mailFolders/{$folder_id}/childFolders","application/json",jsonRequestBody.Emit())
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' A 201 response indicates success.
If (http.LastStatus = 201) Then
    Debug.Print "Folder created."
Else
    Debug.Print "Response status code = "; resp.StatusCode
    Debug.Print "Error: Folder not created."
End If

' Show the response in both cases..
Dim jsonResponse As Chilkat.JsonObject
Set jsonResponse = Chilkat.NewJsonObject
jsonResponse.EmitCompact = False
success = jsonResponse.Load(resp.BodyStr)
Debug.Print jsonResponse.Emit()

' A sample successful JSON response looks like this:

' 	{
' 	  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/mailFolders('AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAL8huv8AAAA%3D')/childFolders/$entity",
' 	  "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAM6JqMIAAAA=",
' 	  "displayName": "subFolderC",
' 	  "parentFolderId": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAL8huv8AAAA=",
' 	  "childFolderCount": 0,
' 	  "unreadItemCount": 0,
' 	  "totalItemCount": 0
' 	}