Populate Outlook 2003 Custom Form from Access 2003

[Guest]

BACKGROUND
I have an Access 2003 database that contains information on the location of
other Access 2003 databases on our servers and the size of those databases. I
am using VBA to open a custom form in Outlook 2003 to email to the users who
have databases out on the various servers to gather information concerning
their databases, such as: the purpose for having the database, benefits
having the database offers, etc. I am using VBScript via a button on the form
to collect the information and send it to a SQL Server 2000 database to be
evaluated.

PROBLEM
The problem I am having is that there is certain information contained in
the Access 2003 database (username, filename, filepath, size) that I would
like to dynamically populate the custom form with, but I am not sure how to
do that. I am not even sure if you can modify the custom form before sending
it?? Ideally, I would like to create some text boxes that I will poopulate
with the username, filename, filepath and databasesize and then disable them
so that the user cannot change their value. That way I can extract the data
via the VBScript into the SQL Server database.

Please let me know if anyone has any ideas or suggestions. I greatly
appreciate you time. Thank you.

 

[Sue Mosher [MVP-Outlook]]

"Sending it?" You're not going to be able to use a custom Outlook form to gather data this way unless you can publish it to the Organizational Forms library on the Exchagne server. If you meet that prerequisite, then you can use ADO code in the form's script to connect to the database, get data from records, and set Outlook property values. Since you apparently already know database code, the info you probably need about Outlook property syntax is here: http://www.outlookcode.com/article.aspx?ID=38

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

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