populating worksheet with Outlook mail

Status
Not open for further replies.
V

VG9uZXk

Hello. I want to populate a worksheet with my Outlook inbox content (all 2007

versions with Vista). I get erros on invalid params on olFolderInbox as

indicated in code below. (I sometimes get erros on creating the initial app

object, but not as often). BTW, I run this code from Excel, and I have

created ref to outlook library.

Sub getMail()

Dim ol As Outlook.Application

Dim ns As Namespace

Dim folder As MAPIFolder

Dim ws As Worksheet

Dim i As Integer

Set ol = CreateObject("Outlook.Application")

Set ns = ol.GetNamespace("MAPI")

ns.Logon

'errors about parameter value not valid on next line:

Set folder = ns.GetDefaultFolder(olFolderIndox)

Set ws = Worksheets("Receive Mail")

For i = 1 To folder.Items.Count

With folder.Items(i)

ws.[A1].Offset(i, 0) = .SenderName

ws.[A1].Offset(i, 1) = .SenderEmailAddress

ws.[A1].Offset(i, 2) = .Subject

ws.[A1].Offset(i, 3) = .Size

ws.[A1].Offset(i, 4) = .ReceivedTime

ws.[A1].Offset(i, 5) = .Left(.Body, 100)

End With

Next i

ns.Logoff

Set ol = Nothing

End Sub
 
S

Sue Mosher [MVP]

Look at that problem statement again to find the typo. It doesn't say

olFolderInbox at all.

Sue Mosher

"Toney" <Toney> wrote in message

news:BFEF6362-373E-46B1-9FAD-C25913FDDDA1@microsoft.com...
> Hello. I want to populate a worksheet with my Outlook inbox content (all
> 2007
> versions with Vista). I get erros on invalid params on olFolderInbox as
> indicated in code below. (I sometimes get erros on creating the initial
> app
> object, but not as often). BTW, I run this code from Excel, and I have
> created ref to outlook library.

> Sub getMail()

> Dim ol As Outlook.Application
> Dim ns As Namespace
> Dim folder As MAPIFolder
> Dim ws As Worksheet

> Dim i As Integer

> Set ol = CreateObject("Outlook.Application")
> Set ns = ol.GetNamespace("MAPI")
> ns.Logon

> 'errors about parameter value not valid on next line:

> Set folder = ns.GetDefaultFolder(olFolderIndox)

> Set ws = Worksheets("Receive Mail")

> For i = 1 To folder.Items.Count
> With folder.Items(i)

> ws.[A1].Offset(i, 0) = .SenderName
> ws.[A1].Offset(i, 1) = .SenderEmailAddress
> ws.[A1].Offset(i, 2) = .Subject
> ws.[A1].Offset(i, 3) = .Size
> ws.[A1].Offset(i, 4) = .ReceivedTime
> ws.[A1].Offset(i, 5) = .Left(.Body, 100)

> End With
> Next i

> ns.Logoff
> Set ol = Nothing

> End Sub

>
 
V

VG9uZXk

Dang. This is why I should type everyting in lower cases, to help me find

these errors. This time, I probably didn't do this.

Thanks much. My code words now.

Toney

"Sue Mosher [MVP]" wrote:


> Look at that problem statement again to find the typo. It doesn't say
> olFolderInbox at all.

> > Sue Mosher
> > >

> "Toney" <Toney> wrote in message
> news:BFEF6362-373E-46B1-9FAD-C25913FDDDA1@microsoft.com...
> > Hello. I want to populate a worksheet with my Outlook inbox content (all
> > 2007
> > versions with Vista). I get erros on invalid params on olFolderInbox as
> > indicated in code below. (I sometimes get erros on creating the initial
> > app
> > object, but not as often). BTW, I run this code from Excel, and I have
> > created ref to outlook library.
> > Sub getMail()
> > Dim ol As Outlook.Application
> > Dim ns As Namespace
> > Dim folder As MAPIFolder
> > Dim ws As Worksheet
> > Dim i As Integer
> > Set ol = CreateObject("Outlook.Application")
> > Set ns = ol.GetNamespace("MAPI")
> > ns.Logon
> > 'errors about parameter value not valid on next line:
> > Set folder = ns.GetDefaultFolder(olFolderIndox)
> > Set ws = Worksheets("Receive Mail")
> > For i = 1 To folder.Items.Count
> > With folder.Items(i)
> > ws.[A1].Offset(i, 0) = .SenderName
> > ws.[A1].Offset(i, 1) = .SenderEmailAddress
> > ws.[A1].Offset(i, 2) = .Subject
> > ws.[A1].Offset(i, 3) = .Size
> > ws.[A1].Offset(i, 4) = .ReceivedTime
> > ws.[A1].Offset(i, 5) = .Left(.Body, 100)
> > End With
> > Next i
> > ns.Logoff
> > Set ol = Nothing
> > End Sub
> >


>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D populating listbox on custom form from Access Outlook VBA and Custom Forms 7
T populating multiple calendars without invites Using Outlook 1
microsvc Populating everyone's calendar with campus events Exchange Server Administration 1
T Populating listbox with MS Access table Using Outlook 2
S Custom field not populating in Custom View or Mail Merge Exchange Server Administration 2
B Populating Additional Outlook Column with Date \ Time Using Outlook 0
R My email merge/business contact manager fields are not populating BCM (Business Contact Manager) 1
T populating fields with information from the address book Outlook VBA and Custom Forms 5
M BCM History 'From' field not populating BCM (Business Contact Manager) 2
O Worksheet doesn't show on jumplist Using Outlook 1
L Open an Exel Macro Enabled Worksheet Using Outlook 4
M How to setup outlook after importing old account information - Entering email account info creates with "(1)" after the account! Using Outlook 1
P Prevent Outlook 2016 from using DASL filter Using Outlook 4
I Button PDF in Outlook Contact custom form Outlook VBA and Custom Forms 0
G VBA to save selected Outlook msg with new name in selected network Windows folder Outlook VBA and Custom Forms 1
X Outlook automation pull from PDF Using Outlook 5
O Outlook 365 - How to create / copy a new contact from an existing one? Using Outlook 3
M Gmail address associated with Outlook on new phone Using Outlook 9
D Cannot populate certain UserProperties in Outlook from Excel Outlook VBA and Custom Forms 2
F Excel VBA to move mails for outlook 365 on secondary mail account Outlook VBA and Custom Forms 1
G Outlook 2016: Want IMAP Data Files on My D: Drive and Not C: Drive Using Outlook 1
V Validating Outlook form with "OR" and "AND" Outlook VBA and Custom Forms 1
D Outlook 2016 64bit, Cannot Save in 'HTML', format Using Outlook 1
J Connect outlook to office365 exchange _without_ signing in office apps Using Outlook 4
D Outlook launch email showing new unread email in reading pane Using Outlook 11
M Convertor for Outlook Express Mail Store (.dbx) to Outlook Mail Store (.pst) Using Outlook 0
K Outlook adds space to rows in HTML email signatures viewed on mobile Using Outlook 1
L Outlook 2010 Outlook 2010 Outlook VBA and Custom Forms 2
V Outlook behaving oddly Using Outlook 2
M HTML email signature in Outlook Using Outlook 1
C What folders are needed when reinstalling Outlook 2010 Using Outlook 0
M Respond to Outlook Email Outlook VBA and Custom Forms 0
P Color Code or highlight folders in Outlook 2016 Using Outlook 2
U Outlook locking up when replying to Email Using Outlook 7
J Outlook Autocomplete (Recipients) opens upward Using Outlook 2
A "Get Add-Ins" - Which Version of Outlook to use Using Outlook 1
O Newbie question: how to sync two Outlook -Exchange and IMAP- calendars? Using Outlook 4
P Syncing Outlook & iPhone Calendars Using Outlook 4
S Unable to extract text from an Outlook email message Using Outlook 2
O Outlook on Android: after sharing / sending a news article, draft remains open. Why? Using Outlook 1
T Outlook creates a copie of every mail I send Using Outlook.com accounts in Outlook 4
O Outlook - hidden contacts? Using Outlook 2
F Outlook 365 is "Possessed" Using Outlook 2
e_a_g_l_e_p_i Can someone explain syncing with Outlook and Gmail Using Outlook 3
K Outlook Office 365 VBA download attachment Outlook VBA and Custom Forms 2
e_a_g_l_e_p_i Gmail in Outlook 2010 preview issue Using Outlook 4
I Outlook is stuck at "Updating Calendar" Using Outlook 1
AmonRa Outlook 365 calendar - too much white space Using Outlook 0
e_a_g_l_e_p_i Outlook 2010 Help setting up Gmail account in Outlook 2010 Using Outlook 3
C-S-R How to clear an Outlook (To Do) Task Flag? Using Outlook 8

Similar threads

Top