Hi,
I am trying to create a Macro (to eventually run on a network to all users). I ideally need this to sit in a toolbar in Outlook (2007) as a one click wonder button so its clicked and brings up the Outlook Form Template which I have already created.
The macro code is:-
Sub MakeItem()
Set newItem = Application.CreateItemFromTemplate("c:\your path\open test.oft")
newItem.Display
Set newItem = Nothing
End Sub
I create this, create the toolbar and put the macro onto it. Works fine until I close outlook. When I re-open Outlook, the button then doesn't work. I dont get any error message it just doesnt work. When I step into the macro I then get the message about macros being disabled.
I cannnot change the macro security setting as this is on a network and we need the security to be high. Is there a workaround for the macro to work from the toolbar?
and...does anyone know the best approach/how to make this avaialble to everyone on the network (I'm not the person who is going to be doing this step but I think the technical server guy is coming up against it on this too).
Any suggestions?
Thanks
B
I am trying to create a Macro (to eventually run on a network to all users). I ideally need this to sit in a toolbar in Outlook (2007) as a one click wonder button so its clicked and brings up the Outlook Form Template which I have already created.
The macro code is:-
Sub MakeItem()
Set newItem = Application.CreateItemFromTemplate("c:\your path\open test.oft")
newItem.Display
Set newItem = Nothing
End Sub
I create this, create the toolbar and put the macro onto it. Works fine until I close outlook. When I re-open Outlook, the button then doesn't work. I dont get any error message it just doesnt work. When I step into the macro I then get the message about macros being disabled.
I cannnot change the macro security setting as this is on a network and we need the security to be high. Is there a workaround for the macro to work from the toolbar?
and...does anyone know the best approach/how to make this avaialble to everyone on the network (I'm not the person who is going to be doing this step but I think the technical server guy is coming up against it on this too).
Any suggestions?
Thanks
B