Followup question re: Outlook and Excel

[phoenix26]

I have a followup question regarding an archived thread.

thread707-1124624

When I try the code in the thread, I encounter the following error while compiling in VBA.

"Invalid outside procedure"

I am using Excel 2003 and when the error occurs, it sets the cursor at the SET OLAPP line.

Would someone help me explain what I am doing wrong?

 

[xlbo]

well have you put the code inside a sub procedure ??

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question