Link to home
Start Free TrialLog in
Avatar of Michael
MichaelFlag for United States of America

asked on

Email outbound attachment prompt

I would like to setup a way to prompt a user upon sending an email with an attachment (particularily .doc and .docx) to remind them to convert the document to .pdf first before sending.  I don't want to deny them, just notify them, because sometimes the Word document does need to be sent.

Is their a policy, script, Outlook add in or separate application that can do this?
ASKER CERTIFIED SOLUTION
Avatar of David Lee
David Lee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Michael

ASKER

This is absolutely perfect.  I appreciate the quick response and the details for implementing.
Couple of questions:  I don't trust that the users will select enable macros so I want to setup for No security check.  I know it is not as safe but we have a mail filtering service and are very protected.  Is there another reason that No security check will affect this?
Also, what would you recommend for deploying this macro to each workstation?  GPO, script or manual configuration?
Thanks again
You're welcome.  Glad I could help.

No, there's no other concerns about setting Outlook for no security check.  

Unfortunately there is no built-in means of deploying Outlook macros.  GPO's work against the registry and it's not possible to add macro code via scripting.  If you are certain that none of the employees have any Outlook macros now, then you can use a logon script to overwrite the file that Outlook macros are stored in.  Here's what you'd do.

1.  Manually add the macro on your computer.
2.  Exit Outlook.
3.  Copy the file VbaProject.OTM.  On a Vista computer you'll find the file in the folder
        c:\Users\<username>\AppData\Roaming\Microsoft\Outlook\
    On a XP computer it'll be in the folder
        c:\Documents and Settings\<username>\Application Data\Microsoft\Outlook\
4.  Add commands to a logon script that overwrites VbaProject.OTM with your copy.

If you overwrite the existing VbaProject.OTM and it contains any macro code, then it'll be lost.  That's why you need to be confident that your employees don't have any macros.  Unfortunately VbaProject.OTM is in a unique format making it impossible to write to the file directly.
Avatar of Michael

ASKER

That worked great.  I configured GP for Outlook's Macro security level, saved the VbaProject.OTM file to \\domain\netlogon in a distribution folder.  It correctly copied and implemented.  Here is the final prompt - Thanks again!!!
 

Document-Send-Warning.jpg
Cool.  Glad it worked.  You're welcome.