|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
11-29-2004, 08:36 AM
|
#1 |
|
Mechanical Guru
Join Date: Jul 2000
Location: Husker Country
Posts: 1,472
|
Excel protection ?
Our department uses a protected excel spreadsheet I created and we email daily to outside personnel.
We would like to be able to insert the sheet into emails without having to attach it (using Send To Mail Recipient instead of Mail Recipient (as Attachment). This way it will be visible when other recieve it and not have to open up an attachment. Is there a way to do this without having to turn the protection off? I looked through the options of the protection box and didn't see anything usefull for this. We are using Excel 2003 SE Thanks.
__________________
If you really want to understand - try changing it. Sys specs: NZXT Lexa_Asus P5E_E6750 2.66Ghz_GSkill 2GB PC6400_Mushkin 2GB PC6400_WD SE16 250GB_Pioneer 16x slot dvd_Pioneer 16x dvdrw Mitsumi 1.44_ATI x1600pro 512mb_Linksys WRT54GS_Samsung R237W LCD_Altec Lansing 641_WinXP PRO SP2 |
|
|
|
11-29-2004, 09:07 AM
|
#2 |
|
Member (9 bit)
Join Date: Sep 2004
Location: Victoria, Australia
Posts: 418
|
Would it be too clumsy to create a new email in HTML format, open up your excel worksheet, select the relevant cells, copy then paste directly into the message section of your email? it should port across but don't know how practical that is for you...
|
|
|
|
|
11-29-2004, 09:08 AM
|
#3 |
|
Ride 'em Cowboy
Join Date: Dec 1999
Location: Dallas, Tx
Posts: 9,109
|
99.9999% sure you can't do this. You'd have to make a "print screen" of it and insert it to the mail.
__________________
Stand Up 2 Cancer - SU2C |
|
|
|
11-29-2004, 10:22 AM
|
#4 |
|
Member (9 bit)
Join Date: Sep 2004
Location: Victoria, Australia
Posts: 418
|
In order for it to work usually you need to ensure the format of the email is in HTML or you don't get the formatting coming through. Though this also allows for the email data to be cut and pasted back into excel at it's destination if needed but it only transfers values and formatting as is (WYSIWYG), but not formulas.
I am not sure how big of a file image it would be trying to transfer a screen dump via the email/internet...possibly up to and over 2MB. Might be a bit of an overhead. Last edited by HyperTF; 11-29-2004 at 11:10 AM. Reason: mis-understanding - my bad, relevant info kept |
|
|
|
|
11-29-2004, 10:51 AM
|
#5 |
|
Ride 'em Cowboy
Join Date: Dec 1999
Location: Dallas, Tx
Posts: 9,109
|
HyperTF, I was typing while you were posting
|
|
|
|
|
11-29-2004, 11:08 AM
|
#6 | |
|
Member (9 bit)
Join Date: Sep 2004
Location: Victoria, Australia
Posts: 418
|
Quote:
 post has been edited. Apologies for the mis-understanding.
Last edited by HyperTF; 11-29-2004 at 11:11 AM. |
|
|
|
|
|
11-30-2004, 09:03 AM
|
#7 |
|
Member (9 bit)
Join Date: Sep 2004
Location: Victoria, Australia
Posts: 418
|
PardeGT, what did you end up doing here? Did you get it resolved?
I am always curious of the outcomes... cheers. |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
