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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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

"pearlmaster8" wrote in message
...
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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/