[RESOLVED] Populate/Edit Outlook 2003 Custom Form from Access 2003
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 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??
Please let me know if anyone has any ideas or suggestions. I greatly appreciate you time. Thank you.
Re: Populate/Edit Outlook 2003 Custom Form from Access 2003
1. create your custom outlook form
2. publish the form to your Organizational library
3. inside access use a outlook object to create an instance of the form
4. if you create custom fields for your data then reference them like this ...
outItem.UserProperties("MDBSize").Value
'where outItem is the variable you Set when creating the email inside access
Your code should still be bale to write values to the fields even if you set them to be disabled when you originally created them.
if you did not add new fields, you can do that by opening the outlook form in design mode, right click on the form background and select field chooser, click new and add you fields one at a time. after the fields have been added right click onn the controls your want to display those fields and select properties, cklick on the value tab and select from the Choose Field list.