WHY OH WHY! ... creating a dynamic array of outlookmail items, then display them.
How does it "fall down"? That is, what error do you get?
Just a guess, but it looks like you would lose previous myCreatedEmails
entries as you run through your For/Next loop because you used ReDim
instead of ReDim Preserve. ReDim by itself clears the array.
WhytheQ wrote:
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
|