Sending & recieving an excel worksheet

[Alex Craw]

Hi there

I have a spreadsheet set up to send out a blank form to multiple recipients with varying email clients. I always set up the worksheet with various blank cells which are left for the recipient to fill in and return to me so that I can compile a weekly list with each individual's responses added in their respective places.

Up until now I have been sending the worksheet directly from excel and manually typing the data back into the spreadsheet on reply. The number of recipients is growing, so I need to cut down on the time spent transposing the replies.

What I want to do is send out the worksheet and be able to copy directly from the body of each reply email and paste directly back into the spreadsheet, thereby saving me a huge amount of typing and reduce the possibility of typos.

I hope you can figure this out, and I hope it's possible.

Any help is much appreciated.

Regards

Alex.
Submitted using http://www.outlookforums.com

 

[Diane Poremsky [MVP]]

is everyone on your network/mail server? what version of outlook do the
recipients use? version of exchange? do you have sharepoint server/windows
sharepoint services available? does everyone have access to infoath?

there are a number of options with various levels of reduncant typing - if
you have sharepoint and infopath you can automate it the most.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.