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

Alt+F11 to open the Outlook VBA editor. Place your macro code in a code
module there with the declaration as Public Sub. Your Sub must take no
incoming arguments for it to be a macro.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"jpotucek" wrote in message
...

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

Thanks. When I do alt/f11 to bring up VBE - the code window is displaying
code for an existing Macro. on the left hand side, it shows
Project1(ProjectName)
-Microsoft Outlook Objects
This Outlook Session
-Modules
Module1

I don't want to edit this existing Module1 code.. I want to start fresh...
what am I missing here??


"Ken Slovak - [MVP - Outlook]" wrote:

Alt+F11 to open the Outlook VBA editor. Place your macro code in a code
module there with the declaration as Public Sub. Your Sub must take no
incoming arguments for it to be a macro.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"jpotucek" wrote in message
...

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

Insert, Module.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"jpotucek" wrote in message
...
Thanks. When I do alt/f11 to bring up VBE - the code window is
displaying
code for an existing Macro. on the left hand side, it shows
Project1(ProjectName)
-Microsoft Outlook Objects
This Outlook Session
-Modules
Module1

I don't want to edit this existing Module1 code.. I want to start
fresh...
what am I missing here??


"Ken Slovak - [MVP - Outlook]" wrote:

Alt+F11 to open the Outlook VBA editor. Place your macro code in a code
module there with the declaration as Public Sub. Your Sub must take no
incoming arguments for it to be a macro.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"jpotucek" wrote in message
...

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