I have an existing Macro in Outlook that basically scans an entire Mailbox
for Messages within a given data Range, dumps the data (date, email address
and email message body) into an excel file and then converts the excel to
..htm and places the .htm file output on a Network drive.

I would like to create a second macro - utilizing part of the code from the
first macro to read all emails and put the email addresses ONLY into a excel
file.

My problem is, when I launch outlook and then go to TOOLS/MACRO - I see my
original Macro and when I Overtype the name and click CREATE to create a new
Macro, I get this error: Compile error - User Type not defined - the code
from my original Macro is displayed in the Code window and this line is
highlighted:

Dim xlApp As Excel.Application

I guess what I don't understand is - How to I create a new Macro from
scratch ????

When I Typed in a new Macro name, I expected to see an empty code window.

DO I need to create a new module or a whole new project??? Any guidance
or help would be much appreciated.

signed,
a VBA Newbie