Creat Macro in Outlook Script Editor

[nic6000]

Hi,

I'm hoping someone can help me with this. I'm completely new (just today) to custom forms on Outlook and have got a bit stuck. I Basically have created a form with a number of fields on which are to be completed by a user and sent back to a group email address.

When the group email address receives the msg, it is my intention to be able to open the msg and run a macro which exports the field data to MS Access. I have created a button and added a basic macro to the Edit Read Page, but can't seem to get it to work. This is what I've added:

Button Name: cmdSendtoDb2

Script Code:

Sub cmdSendtoDb2_Click()
msgbox "msg worked"
End Sub

Can anyone tell me if I have missed a step to initialise the macro. I have also added a similar button to the Edit Compose Page and this worked Ok?

Any help will be appreciated.

Thanks,


Nic

 

[ClulessChris]

Has your form been published?
What version of Outlook are you useing?
Take a look at

http://www.Slipstik.com

for all things Outlook.

Everybody body is somebodys Nutter.

 

[nic6000]

Hi, have published form which is on Outlook 2000.

 

[nic6000]

Hi,

UPDATE: I have solved this one now - found the answer on the net. I needed to uncheck the 'Send form definition with item' box on the (Properties) tab.

Cheers

Nic

 

[ClulessChris]

Yes, checking that option "one offs" the form.

Everybody body is somebodys Nutter.