References In Excel

  • Thread starter Thread starter pearlmaster8
  • Start date Start date
P

pearlmaster8

I am working on a macro that copies and pastes all emails from a folder
into an excel workbook. I think I have a solution, however the site
that gave me advice claimed that I needed to insert a reference to the
Outlook library. I went to Tools->References to add, but the selection
is disabled. What do I need to install, and from what cd's to get this
to work? Any advice on copying from e-mails in Outlook to Excel will
also be appreciated. Thank you.
 
when in the Visual Basic Editor, make sure you have a module open. If you
have no modules in the Excel file, then add one. Then you can go to
Tools->References. If it is still greyed out, hit the Stop button, and then
try.

-akshay
 
Back
Top