Looking for a large file attachment solution for exchange/outlook

I can't see a reason why not going to www.rapidshare.com and sending the file directly from their, faster and easier!!! to any user!

You can ask users to use below website

www.transferbigfiles.com/

How would you like it to work, for example user adds a number of files to an email and clicks send.

A VBA script could pick on any attachments at that timem strip out those that are oversize, (10MB for example)  and if the accumulated set are over 10MB then process many more smaller sizes until the 'limit' is met.  Each deleted file attachment could be replaced by a link tot the 'X' drive, (I assume this will be the same for all users) and the mail is then sent.  Of course it also means the originator will not have the files either in outlook.

If acceptab;e then let us knw and we can work on it for you.

Chris

Chris, that sounds exactly like what I was thinking.  It would keep the big attachments off of Exchange and give our users some flexibility for large files.  Would this VBA script run on the clients workstation or on the Exchange server?

Thanks again.
Ben

Personally I cannot do exchange so I am simply envisioning an outlook client solution since that is within my capabilities.

Chris

Ok, that would actually work best since not all of our users would need it.

First off then ... do you have an idea for what constitutes a reasonable attachment limit for your business ... i.e. small files lcan be embedded for HTML as an example and you wouldn't to delete them so if for example a file size of over 1MB is considered 'unreasonable' we could try deleting all such and replacing with links.

Secondly do you want to tell me the folderpath or replace it yourself if I identify a dummy.

3. How are you for VBA programming in outlook?

Chris

1) I think 10MB is reasonable
2) I can replace the folderpath, we will be adjusting our FTP server paths/folders to accomodate so it isn't known right this second
3) I haven't really done any VBA in outlook, very little for Excel in the past

FWIW, I have put together som ecode that in my tests, (local directory) works fine.  Basically need to ensure the code is called hence it is important to know your skills base.  That aside try the following as a pointer to inserting teh code:

To Create a macro:
------------------

Alt + F11 to open the macro editor

  For Applicationevent handlers:
     In the project tree select as appropriate:
      OUTLOOK      : thisOutlookSession
     In the workpane select as appropriate:
      OUTLOOK      : Application
     In the workpane select the required 'event', (i.e. 'Send').
     Either
        Insert the required code from the supplied sub into the selected subroutine.
     Or
        Replace the template inserted by the VBE with the sub as supplied

  For User Code:
     Insert | Module to insert a code module into the project
     In the project tree select the module.
     Insert the required macro(s) into the selected module, ('Module1' or similar)

Close the Visual Basic Editor.

Check Security as appropriate:
------------------------------

In the application select Tools | Macro | Security
2003 and Earlier : Select Medium
2007 : Warnings for all Macros
Select OK


Chris

This needs to be the application event handler in thisOutlookSession

Chris

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
    saveAtt Item
End Sub

Select allOpen in new window