How to build a RecordSet

B

brittonsm

I'm looping through mail items in a folder and would like to build
them into a recordset or store them into an array that I can then copy
to Excel once I finish going through all the mail messages.

I get 100+ emails every night from the Engineering system for new part
numbers and need to load all of them into a spreadsheet so I can
process them through another system.

Ideas?

Thanks,

-Steve
 
J

Jan Hyde (VB MVP)

brittonsm <[email protected]>'s wild thoughts were
released on Mon, 27 Oct 2008 08:49:01 -0700 (PDT) bearing
the following fruit:
I'm looping through mail items in a folder and would like to build
them into a recordset or store them into an array that I can then copy
to Excel once I finish going through all the mail messages.

I get 100+ emails every night from the Engineering system for new part
numbers and need to load all of them into a spreadsheet so I can
process them through another system.

Ideas?
Click to expand...

Why not update Excel as you process the e-mails?
 
Top