Hello,

I am currently creating a custom form that will be used for all users new
email messages in Outlook 2003. I’m pretty new to forms but willing to learn.

I wish to add two fields, a Job number field where the user must select a
job number from a drop down box which is updated through access/excel with
new job numbers as needed. Here comes the first question...

1. I have created a drop down box from the controls tool box and wish to add
a source from where this information is gathered from (spreadsheet or
database, prefer spreadsheet) which will be the job numbers. How can I do
this?

2. How can I get this field to merge with the Subject field when this email
is sent?
for example they write: "Design One - Building" in the subject field which
is then merged with the job name "4500 Big_Building" selected from the drop
down box which when it is received by the other person has a subject off
"Design One - Building: #4500 Big_Building".

The other field is a description field where it will have a description that
can be updated each time the message is sent/received during the
correspondence. Currently this is added to the form, however when I send it
it does not display on the receivers computer?

Any help is much appreciated.