Opening an Access table from Outlook 2000

[Joanne]

My client wants to schedule appointments from within
Outlook 2000 and update appointment info in an Access
database. They also want to use custom fields in Outlook
to update client address informatino at the time they are
creating the appointment and then shoot the updated info
to the Access database as well.

I am accustomed to developing in VBA in Access. So far in
Outlook I have created the custom fields. I have
developed the code to open the table etc in Access in an
Oulook macro but I can't seem to execute the macro. Or
maybe it would be better to do it in VBScript. Basically,
I could use an example (or something similar) of how to do
what I need to do. I know how to do all the bits and
pieces, but I can't see how to put it all together to work.

Thanks in advance!
Joanne

 

[Guest]

I did get the macro to execute. I had leftover parameters
declared from something else I tried earlier. So anyway,
now the macro works.

So now I am trying to figure out how to grab data from my
user defined custom fields on my Outlook form.

Thanks!

 

[Sue Mosher [MVP-Outlook]]

What happens when you try to execute the macro?

 

[Joanne]

I did get the macro to execute. I had leftover parameters
declared from something else I tried earlier. So anyway,
now the macro works.

So now I am trying to figure out how to grab data from my
user defined custom fields on my Outlook form.

Thanks!

 

[Sue Mosher [MVP-Outlook]]

UserProperties("propname") -- See
http://www.outlookcode.com/d/propsyntax.htm