"Dave Peterson" wrote in message
...
Just some thoughts that you can ignore.

Too many words!

I've found that the longer the instructions, the more they're ignored.

Put your instructions in MSWord, add some screen prints and add some white
space
to make it easier to read.

Good stuff, someone actually addressing the OP's origiunal question - we had
all forgotten.



And maybe you could modify your code so that instead of using references,
you
could use late binding.

Do all your developing with the references so you can get the VBE's nice
intellisense, but before you release it, change your declarations to a
more
generic "as object".

And change all the constants to their actual values:

A different suggestion, declare all Excel/App/VBA constants (such as
vbReadOnly, xlHidden) as constants in your code, and then you can leave that
bit of code alone, still referencing through a constant. Like this

Const olBCC As Long = 3
Sub Macro1()
Dim olApp As Object

Set olApp = CreateObject("Outlook.Application")
Debug.Print olBCC
End Sub