Using the Namespace Object in Outlook VBA

No video

Using the Namespace Object in Outlook VBA

Рет қаралды 4,119

Күн бұрын

The namespace object allows us to access different objects in our Outlook application, making it an important stepping stone when it comes to learning the outlook object model.
Video Resources:
--------------------------------------------------
Resource: GitHub File
Link: github.com/are...
Resources:
--------------------------------------------------
Facebook Page: / codingsigma
Facebook Group: / sigmacoding
GitHub Sigma Coding: github.com/are...
Support Sigma Coding:
--------------------------------------------------
Patreon: / sigmacoding
Amazon Associates: amzn.to/3bsTI5P **
Related Topics:
--------------------------------------------------
Title: How to Use the Folder Object in Outlook VBA
Link: • How to Use the Folder ...
Title: How to Work With Emails in Outlook VBA
Link: • How to Work With Email...
Title: Using the Namespace Object in Outlook VBA
Link: • Using the Namespace Ob...
Title: Using the Appointment Item Object in Outlook VBA
Link: • Using the Appointment ...
Title: Export a Single Outlook Table to Excel
Link: • Export a Single Outloo...
**Amazon Associates Disclosure:
--------------------------------------------------
I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel.
Tags:
--------------------------------------------------
#Outlook #VBA #Namespace

Пікірлер: 6

@81lego81 5 жыл бұрын

You are so awesome. Thank you for these videos. The graphics you make for the videos are also very visually appealing. Good stuff man. :)

@SigmaCoding 5 жыл бұрын

Glad you like the videos!

@selvan1264 2 жыл бұрын

Thank you for the nice video! Could I check if you have video on how to reply or forward emails using excel VBA? Thank you much for your help time

@alessandrolazzarini270 2 жыл бұрын

Hi Sigma, Many thanks for your video Have you any suggestions to loop through Outlook mails with zipped attachments, and detach them only when a Zip file contains what I need? Many Thanks

@dildokafir5058 5 жыл бұрын

How to use late binding method from excel to get all the account names..

@SigmaCoding 5 жыл бұрын

It would look something like this: Sub GrabAccountsFromExcel() 'Declare Outlook Variables Dim oLookApp As Object Dim oLookName As Object Dim oLookAccts As Object Dim oLookAcct As Object On Error Resume Next 'Get the active instance of Outlook Set oLookApp = GetObject(, "Outlook.Application") 'If error create a new instance If Err.Number = 429 Then Set oLookApp = CreateObject("Outlook.Application") End If 'Grab the namespace Set oLookName = oLookApp.GetNamespace("MAPI") 'Grab the accounts from the Namespace Set oLookAccts = oLookName.Accounts 'Loop through each account For Each oLookAcct In oLookAccts 'Print the current user Debug.Print oLookAcct.CurrentUser Next End Sub