Hi RobDog,

I am reviving this thread since I have a question about this code.

I'm not going to lie, I am a complete NEWB when it comes to linking MS apps. And since you are a GOD when it comes to this stuff, I am going to ask some very newb questions about the code you have posted. (So please go easy on me )

I have added the code above (the code with the 3 parts to it) to a module in Outlook. There in lies my first question - where do I place this code? The Form_Open() sub makes me think that the code should be placed in a form module, if not what does it refer to? At any rate, I have tried the code in both a module and form code and have come across this error: "Run-time eorr 3709: The connection cannot be used to perform this operation. It is either closed or invalid in this context."
This refers to this line of code:
VB Code:
  1. goRs.Open sSQL, CnnA, adOpenKeyset, adLockOptimistic, adCmdText

I have set the following references set:
- VBA
- MS Outlook 11.0 Object Library
- OLE
- MS Office 11.0 Object Library
- MS Forms 2.0 Obj Library
- MS ADO (multi-dim) 2.8 Library
- MS ADO 2.0 Library

I tried to set more ADO Libraries but I would get a "Name conflicts with existing module, project, or object library" Error. Are there any other references that I need to set?

Any idea why the code is not working??
As always, your help is very much appreciated!!