PDA

View Full Version : Copy fields from active task to active worksheet



Westy
01-21-2014, 11:26 PM
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
01-22-2014, 03:26 AM
Not done it myself, but did find this thread http://www.ozgrid.com/forum/showthread.php?t=15716

westconn1
01-22-2014, 03:28 AM
do you want to write the code in outlook or excel?

Westy
01-22-2014, 03:20 PM
I want have the macro in outlook - any ideas?