function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sales4sSales4s 

Macros in a MailMerge template: No longer allowed?

Hello All,
 
We have VBA macros in a mailmerge template to perform certain functions on document open/close events. Everything was working fine until Winter 09. Here's what we are seeing after W09:
 
1. When users with new laptops launch mail merge, the macros don't run. It appears they are blocked automatically by the MailMerge ActiveX control.
 
2. This happens in both Office 2003 and 2007. The security settings are set to Low
 
3. When we save the mail merge output to the disk and then open the document locally, the macros run just fine. So we suspect this has to do with the SFDC ActiveX control.
 
4. The macros work fine on existing laptops. I guess it is because the pre-W09 ActiveX is already downloaded
 
Has anyone else run into this? Any workarounds/solutions?
 
Thanks.