Using the Send To command 2

[juliaatpcgp]

At the moment, my users are clicking on "Send To as attachment" on the File menu of Word/Excel to pass documents to colleagues.

They're doing this unaware that the document their colleague is receiving is no longer on the network and is a separate copy of the document. This causes all kind of problems with mislaid documents and multiple versions.

I know the Send To option also has another option which changes the file into the body of the e-mail. This seems to work fine with most Word documents but some get corrupted or the layout goes all wrong with this option.

What they really want to do is create a e-mail containing a shortcut to the file (or even just the complete path/filename), so that the document remains on the network. Can SendTo (or another newly created menu item) be "taught" to do this sending it to our e-mail client (Outlook 2000) ?

I know it's possible to send a shortcut using the Outlook 2000 menus but this is rather fiddly and involves them searching through the disk structure to find the file again (whereas in the original program its already right there on the screen).

I'm prepared to do some customisation of the menus in Word/Excel or even some registry editing because it will be worth my while.

Can you help me ?

Regards,
Jay

 

[shellig]

What I do is display the Web toolbar in any Office program (e.g. View>Toolbars>Web), click in the address box, copy and paste what is in there into the body of the message in Outlook.
If there are any spaces, you need to put < > around the pasted text
e.g. <\\myfile\test 1.xls>
You may need to add the word file in front of it to make it hyperlink:
e.g. <file://C:\My Documents\MyFile.doc>

I like to copy directly from the web toolbar address field because the copied text gets the path name with the correct network path not the mapped drive path on the network in case someone has a different mapping (which is a problem where I work).
This takes up NO space in the e-mail (yeah no clogging up my inbox or sent files box) and points directly to the file on the network.
Hope this helps (people here are pretty impressed when I do this BTW!)

 

[shellig]

What I do is display the Web toolbar in any Office program (e.g. View>Toolbars>Web), click in the address box, copy and paste what is in there into the body of the message in Outlook.
If there are any spaces, you need to put < > around the pasted text
e.g. <\\myfile\test 1.xls>
You may need to add the word file in front of it with a colon and two back slashes to make it hyperlink:
e.g. <file://C:\My Documents\MyFile.doc>

I like to copy directly from the web toolbar address field because the copied text gets the path name with the correct network path not the mapped drive path on the network in case someone has a different mapping (which is a problem where I work).
This takes up NO space in the e-mail (yeah no clogging up my inbox or sent files box) and points directly to the file on the network.
Hope this helps (people here are pretty impressed when I do this BTW!)

 

[juliaatpcgp]

Thanks for your suggestion - it sounded like what I needed.

However, the path does not seem to work correctly when there is a space in it for example \\working data\filename.xls.

Can you (or any other forum members) offer a fix or another way - we use Office 2000.

Regards,
Jay

 

[KenWright]

Did you read the bit about:-

If there are any spaces, you need to put < > around the pasted text
e.g. <\\myfile\test 1.xls>

Works fine for me with spaces when done exactly as stated

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[juliaatpcgp]

Ah ... no ... I didn't !!

Thanks for pointing out my oversight.

Regards,
Jay

 

[KenWright]

You're welcome. I thought it was a good tip actually and have added that toolbar to all my apps, and have simply gotten rid of all th eothre icons on it except the address, so he can have a star from me for that one.

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------