In order to use macros without being prompted every single time to accept them, you need to create a personal digital certificate using the aptly named Digital Certificate for VBA Projects utility.

If you have users who prefer to push Excel data into Outlook instead of importing it from inside Outlook, try this VBA event procedure.