Send an email with protected spreadsheet in body (1 Viewer)

[Chris RR]

Hi,
My users have a small Excel spreadsheet that they mail out each week. Their own users fill in the unprotected fields and then email it back. This works just fine when the spreadsheet is sent as an attachment.

But my users think it would be simpler and cleaner if the spreadsheet were in the body of the email that they send out. They want their users just to key in their own numbers, then hit reply.

Unfortunately, Outlook requires that the spreadsheet password be removed before the email is sent.

Is it possible to use Excel for this type of thing or does it need to be done in another tool?

By the way, we are working with Excel and Outlook 2003.

Thanks for your time!

 

[Trevor G]

Please have a look at the following link, when you look at the link if you down load the 3rd workbook sample it will deal with the sending as body.

http://www.rondebruin.nl/sendmail.htm