Data change request form

[Orlando]

Hi all,

I am working with Outlook 2002, using the message form as my template.
I am creating a form that should ask for a specific account number.
I want to have a button that when pressed, the current data for that account
is loaded in different fields of the message.
The data is in an Access database on a shared folder.
Is there a way to connect to the database, get the data and populate it in
the message?
After that, the user can enter the new data and send it.

I have no basic script experience. Any site that could help?

Thanks.

 

[Hollis D. Paul]

I have no basic script experience. Any site that could help?

Www.outlook-code.com and www.slipstick.com

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Mukilteo, WA USA

 

[Sue Mosher [MVP-Outlook]]

If you have no basic script experience, you're going to have a bit of a learning curve because you'll need to know:

1) VBScript basics
2) Outlook property and form control syntax basics (http://www.outlookcode.com/d/propsyntax.htm)
3) Techniques for reading data from a database. Start at http://www.outlookcode.com/d/database.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers