Copy fields from active task to active worksheet

[Westy]

I have a custom task form in outlook that is used to store and manage opportunities. I only want to fill-in the customers details once, either in the outlook form or in the excel (quote) template that I use. Is there code to copy specific fields from an active task to the open (active) excel sheet or back the other way? Any VBA code for this would be very much appreciated. Thanks

[Bob Phillips]

Not done it myself, but did find this thread http://www.ozgrid.com/forum/showthread.php?t=15716

[westconn1]

do you want to write the code in outlook or excel?

[Westy]

I want have the macro in outlook - any ideas?