Hi All
I am having a problem running some VB in a custom form.
Basically I am using Outlook 2013 after migrating from outlook 2003. I choose the form and enter a load of data in fields, then if I click a command button outlook runs some VB to open a word doc and copy’s some of the form data in to a table. This works fine.
But If I click Send on the form the Post/form is sent to a public folder. Now if I open this form and click the command button nothing happens. The code does not run.
I have set Outlook to run all VB but am I missing a security setting somewhere?
If I Design This Form and then View code I see
Sub cmdTypeText_Click
strDate = CStr(Date())
MsgBox "Date: " & strDate
Do lots of word opening stuff
End Sub
I put in the MessageBox for debugging.
If I select Run This Form then command button will run VB again.
Thanks very much for your help
Jase
I am having a problem running some VB in a custom form.
Basically I am using Outlook 2013 after migrating from outlook 2003. I choose the form and enter a load of data in fields, then if I click a command button outlook runs some VB to open a word doc and copy’s some of the form data in to a table. This works fine.
But If I click Send on the form the Post/form is sent to a public folder. Now if I open this form and click the command button nothing happens. The code does not run.
I have set Outlook to run all VB but am I missing a security setting somewhere?
If I Design This Form and then View code I see
Sub cmdTypeText_Click
strDate = CStr(Date())
MsgBox "Date: " & strDate
Do lots of word opening stuff
End Sub
I put in the MessageBox for debugging.
If I select Run This Form then command button will run VB again.
Thanks very much for your help
Jase