Hi,

A bit of a long shot but I am hoping that someone can help with creating a macro that will take cell values and write them to the fields of a custom outlook form.

In VBScript, for example, I can set the values of any field on a custom outlook form using -
Item.UserProperties("MyField")=Value

What I need to be able to do is access the user-form from within Excel and then programatically update the required fields. Once done, it would just be a matter of sending the mail.

I hope I am not expecting a little too much of the current abilities of Office automation? I'm pretty new to scripting. If someone has a a little time to at least point me in the right direction, I would be most grateful.

Thanks in advance,

Mike

Platform - WinNT4 SP6(I think), Excel97, Outlook 2000 SP1