hibiscus27
04-20-2007, 09:46 AM
Hello
I'm hoping this is resolved with a VBA code...or something!
I have an excel form that users can attach/embed files to in order to serve as supporting documentation to the form.
Then they email the form to the approver. The approver can just click on the icons and can see the supporting documents attached to help make the approve/reject decision.
The problem is that this can create a very LARGE excel file. And in turn can reak havoc on Outlook.
Is there a VBA that can minimize the form size before emailing if the user has embeded a file to it?
Thanks
I'm hoping this is resolved with a VBA code...or something!
I have an excel form that users can attach/embed files to in order to serve as supporting documentation to the form.
Then they email the form to the approver. The approver can just click on the icons and can see the supporting documents attached to help make the approve/reject decision.
The problem is that this can create a very LARGE excel file. And in turn can reak havoc on Outlook.
Is there a VBA that can minimize the form size before emailing if the user has embeded a file to it?
Thanks