Can you link - auto-fill two custom forms together?

[Guest]

I've created a custom form based on the contacts template at work for one
department to track all client communications we get from each client
individually. So currently there are thousands of these in its folder.

I've also created another custom form on the contacts template as a "client
database" of basic info for each of our clients. Currently there are about
260 of these.

My boss would like to...I dunno, duplicate the information somehow, and I
think this is impossible to do but he's making me ask.

If I added the same fields from the client communications form to the client
database form (date, description of event, client name, client number, etc).
is it possible to program a command button so that it will open a new client
communications entry form and fill in the right fields?

 

[Sue Mosher [MVP-Outlook]]

Yes, it's just a matter of creating the item (MAPIFolder.ITems.Add, specificy the custom form message class) and then setting the appropriate properties ( http://www.outlookcode.com/d/propsyntax.htm ). A bit of grunt work to write the code and test, but no rocket science.

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

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

 

[Guest]

Thanks, Sue!

That is WAY over my head for the simple reason that i haven't yet learned
how to do VBA programming in Outlook. I know some in Word, but I haven't
figured out how to do things in Outlook yet...I'll get there.

I have one follow-up question that may be hard to phrase...

My user fills out the fields (identical to the ones in the 2nd form which
will be auto-filled in). And they hit a command button which creates and
fills in the 2nd form automatically. Great. But I need to save (append) the
data they just filled in to the original form somehow.

So, I guess the question is: is it possible to dump information from one
field into another (huge, scrolling) text field in the same form? I know it
is possible to have one field = another but this field will have to be
capable of receving new information and "stacking" it ad infinitum without
overwriting any earlier data.

 

[Sue Mosher [MVP-Outlook]]

You can either use the Body property or add your own custom property to hold this information. If you need help with the property syntax, see http://www.outlookcode.com/d/propsyntax.htm

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

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