As you can see where I've put the ?????????'s, I have no idea how to reference my custom fields on the Outlook form. If I pull up the properties for each one, they are called things like Label2 but Excel refuses to recognise these.

Re: Writing values to custom Outlook form (Excel 97/Outlook 2000)

Hi Wassim,

I've created a custom form in Outlook, so ticket number is a user defined field of several numbers, date raised is a date, time raised is a time field etc etc.
Looking through the form, I think I've found the field names - things like date, desc, error, tickets, time1 and so on.
But if I put in my code: .desc=Activesheet.range("A2").value , Excel doesn't seem to know what '.desc' is. Do I need to somehow declare the Outlook custom field names to Excel first?
I also wondered whether I'm referencing the correct object. I'm defining olMailItem as Outlook.mailitem, when I'm actually trying to send data to a form. Does this make a difference? Or should I just forget the whole thing?!?