Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using the following code, with NO reference to outlook:
Dim objOutlook As Object Dim objMailItem As Object Dim myCreatedEmails() As Object Sub CreateAndDisplayEmails() Set objOutlook = CreateObject("Outlook.Application") Erase myCreatedEmails For i = 1 To 3 Set objMailItem = objOutlook.CreateItem(0) With objMailItem .To = "Tester" & i .Subject = "Tester" & i End With ReDim myCreatedEmails(k) '##### falls down on next line ##### myCreatedEmails(k) = objMailItem k = k + 1 Next i For k = 1 To UBound(myCreatedEmails) myCreatedEmails(k).Display Next k End Sub ....I've marked where it already falls down and I assume even if this line is fixed then it'll fall down later on on the line "myCreatedEmails(k).Display" The above must be pretty bl##dy close!...can anyone help? Help appreciated Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Always display items AND Include hidden items in totals | Excel Discussion (Misc queries) | |||
xla creating new menu items | Excel Programming | |||
Dynamic PageField Items | Excel Programming | |||
Pivot Table calculated items with dynamic file source | Excel Programming | |||
Dynamic Selection of Pivottable Drop Down Items | Excel Programming |