I would like to map a macro to a button in a custom form that I have
designed. I already have the vbscript, which I got off of the VBScript
section of the MS website, and it works just fine. The script asks the user
if they want to visit the conference booking site, and when they click on yes
it opens the appropriate page. I just can't seem to figure out how to map
the macro to a button, so that when a user clicks the button in the form they
are asked if they want to visit the site, when they click yes an IE browser
windows opens directly to our conference booking site. I am trying to do
this using a CommandButton that I have inserted into my form, which I got
from the controls toolbox.

I am new at this and perhaps I am be trying to do something that cannot be
done in Outlook 2000, but I am not sure. I seem to remember using a form
once that had a button built into it that opened a webpage.

Any advice is appreciated.

Please advise.

Thank-you,
Charles

You need to be using not a VBA macro but VBScript code attached to your
button's Click event:

Sub CommandButton1_Click()
' your code goes here
End Sub



--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Cybordelic" <(E-Mail Removed)> wrote in message
news:1012719E-AF42-43E2-ACDF-(E-Mail Removed)...
>I would like to map a macro to a button in a custom form that I have
> designed. I already have the vbscript, which I got off of the VBScript
> section of the MS website, and it works just fine. The script asks the
> user
> if they want to visit the conference booking site, and when they click on
> yes
> it opens the appropriate page. I just can't seem to figure out how to map
> the macro to a button, so that when a user clicks the button in the form
> they
> are asked if they want to visit the site, when they click yes an IE
> browser
> windows opens directly to our conference booking site. I am trying to do
> this using a CommandButton that I have inserted into my form, which I got
> from the controls toolbox.
>
> I am new at this and perhaps I am be trying to do something that cannot be
> done in Outlook 2000, but I am not sure. I seem to remember using a form
> once that had a button built into it that opened a webpage.
>
> Any advice is appreciated.
>
> Please advise.
>
> Thank-you,
> Charles

Thank-you for responding to my question. Where do I find the button's Click
event? I don't see it under the "CommandButton1" Properties or Advanced
Properties.

"Sue Mosher [MVP-Outlook]" wrote:

> You need to be using not a VBA macro but VBScript code attached to your
> button's Click event:
>
> Sub CommandButton1_Click()
> ' your code goes here
> End Sub
>
>
>
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Cybordelic" <(E-Mail Removed)> wrote in message
> news:1012719E-AF42-43E2-ACDF-(E-Mail Removed)...
> >I would like to map a macro to a button in a custom form that I have
> > designed. I already have the vbscript, which I got off of the VBScript
> > section of the MS website, and it works just fine. The script asks the
> > user
> > if they want to visit the conference booking site, and when they click on
> > yes
> > it opens the appropriate page. I just can't seem to figure out how to map
> > the macro to a button, so that when a user clicks the button in the form
> > they
> > are asked if they want to visit the site, when they click yes an IE
> > browser
> > windows opens directly to our conference booking site. I am trying to do
> > this using a CommandButton that I have inserted into my form, which I got
> > from the controls toolbox.
> >
> > I am new at this and perhaps I am be trying to do something that cannot be
> > done in Outlook 2000, but I am not sure. I seem to remember using a form
> > once that had a button built into it that opened a webpage.
> >
> > Any advice is appreciated.
> >
> > Please advise.
> >
> > Thank-you,
> > Charles
>
>
>

You have to create the event handler by typing the code into the form's View
Code window.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Cybordelic" <(E-Mail Removed)> wrote in message
news:901B2BCA-890A-4523-874A-(E-Mail Removed)...
> Thank-you for responding to my question. Where do I find the button's
> Click
> event? I don't see it under the "CommandButton1" Properties or Advanced
> Properties.
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> You need to be using not a VBA macro but VBScript code attached to your
>> button's Click event:
>>
>> Sub CommandButton1_Click()
>> ' your code goes here
>> End Sub
>>
>>
>>
>> --
>> Sue Mosher, Outlook MVP
>> Author of
>> Microsoft Outlook Programming - Jumpstart for
>> Administrators, Power Users, and Developers
>> http://www.outlookcode.com/jumpstart.aspx
>>
>>
>> "Cybordelic" <(E-Mail Removed)> wrote in message
>> news:1012719E-AF42-43E2-ACDF-(E-Mail Removed)...
>> >I would like to map a macro to a button in a custom form that I have
>> > designed. I already have the vbscript, which I got off of the VBScript
>> > section of the MS website, and it works just fine. The script asks the
>> > user
>> > if they want to visit the conference booking site, and when they click
>> > on
>> > yes
>> > it opens the appropriate page. I just can't seem to figure out how to
>> > map
>> > the macro to a button, so that when a user clicks the button in the
>> > form
>> > they
>> > are asked if they want to visit the site, when they click yes an IE
>> > browser
>> > windows opens directly to our conference booking site. I am trying to
>> > do
>> > this using a CommandButton that I have inserted into my form, which I
>> > got
>> > from the controls toolbox.
>> >
>> > I am new at this and perhaps I am be trying to do something that cannot
>> > be
>> > done in Outlook 2000, but I am not sure. I seem to remember using a
>> > form
>> > once that had a button built into it that opened a webpage.
>> >
>> > Any advice is appreciated.
>> >
>> > Please advise.
>> >
>> > Thank-you,
>> > Charles
>>
>>
>>

Excellent! I was successful in inserting the code.

The form works when I run the form and click on the button (opens in
Internet Explorer and goes to the right webpage). But if I save the file
..oft and close the form, then re-open the form and try to click the button is
does nothing. How do I save the form so that the button will work when I
open the form or send it to my co-workers pc.

The idea is that we want to allow all users to be able to double click the
..oft and open the form, fill it out, and send it the address that is already
populated in the To: field.

Thanks again!
Charles

"Cybordelic" wrote:

> I would like to map a macro to a button in a custom form that I have
> designed. I already have the vbscript, which I got off of the VBScript
> section of the MS website, and it works just fine. The script asks the user
> if they want to visit the conference booking site, and when they click on yes
> it opens the appropriate page. I just can't seem to figure out how to map
> the macro to a button, so that when a user clicks the button in the form they
> are asked if they want to visit the site, when they click yes an IE browser
> windows opens directly to our conference booking site. I am trying to do
> this using a CommandButton that I have inserted into my form, which I got
> from the controls toolbox.
>
> I am new at this and perhaps I am be trying to do something that cannot be
> done in Outlook 2000, but I am not sure. I seem to remember using a form
> once that had a button built into it that opened a webpage.
>
> Any advice is appreciated.
>
> Please advise.
>
> Thank-you,
> Charles

Code doesn't run in one-off or unpublished forms. The right procedure
depends on whether you are working in an Exchange environment and, if so, if
you can publish to the Organizational Forms library. See
http://www.outlookcode.com/d/formsec.htm

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Cybordelic" <(E-Mail Removed)> wrote in message
news:16EEBA0F-02DE-4D01-AF99-(E-Mail Removed)...
> Excellent! I was successful in inserting the code.
>
> The form works when I run the form and click on the button (opens in
> Internet Explorer and goes to the right webpage). But if I save the file
> .oft and close the form, then re-open the form and try to click the button
> is
> does nothing. How do I save the form so that the button will work when I
> open the form or send it to my co-workers pc.
>
> The idea is that we want to allow all users to be able to double click the
> .oft and open the form, fill it out, and send it the address that is
> already
> populated in the To: field.
>
> Thanks again!
> Charles
>
> "Cybordelic" wrote:
>
>> I would like to map a macro to a button in a custom form that I have
>> designed. I already have the vbscript, which I got off of the VBScript
>> section of the MS website, and it works just fine. The script asks the
>> user
>> if they want to visit the conference booking site, and when they click on
>> yes
>> it opens the appropriate page. I just can't seem to figure out how to
>> map
>> the macro to a button, so that when a user clicks the button in the form
>> they
>> are asked if they want to visit the site, when they click yes an IE
>> browser
>> windows opens directly to our conference booking site. I am trying to do
>> this using a CommandButton that I have inserted into my form, which I got
>> from the controls toolbox.
>>
>> I am new at this and perhaps I am be trying to do something that cannot
>> be
>> done in Outlook 2000, but I am not sure. I seem to remember using a form
>> once that had a button built into it that opened a webpage.
>>
>> Any advice is appreciated.
>>
>> Please advise.
>>
>> Thank-you,
>> Charles

When I click on your hyperlink below I get the message "The page cannot be
found".

"Sue Mosher [MVP-Outlook]" wrote:

> Code doesn't run in one-off or unpublished forms. The right procedure
> depends on whether you are working in an Exchange environment and, if so, if
> you can publish to the Organizational Forms library. See
> http://www.outlookcode.com/d/formsec.htm
>
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Cybordelic" <(E-Mail Removed)> wrote in message
> news:16EEBA0F-02DE-4D01-AF99-(E-Mail Removed)...
> > Excellent! I was successful in inserting the code.
> >
> > The form works when I run the form and click on the button (opens in
> > Internet Explorer and goes to the right webpage). But if I save the file
> > .oft and close the form, then re-open the form and try to click the button
> > is
> > does nothing. How do I save the form so that the button will work when I
> > open the form or send it to my co-workers pc.
> >
> > The idea is that we want to allow all users to be able to double click the
> > .oft and open the form, fill it out, and send it the address that is
> > already
> > populated in the To: field.
> >
> > Thanks again!
> > Charles
> >
> > "Cybordelic" wrote:
> >
> >> I would like to map a macro to a button in a custom form that I have
> >> designed. I already have the vbscript, which I got off of the VBScript
> >> section of the MS website, and it works just fine. The script asks the
> >> user
> >> if they want to visit the conference booking site, and when they click on
> >> yes
> >> it opens the appropriate page. I just can't seem to figure out how to
> >> map
> >> the macro to a button, so that when a user clicks the button in the form
> >> they
> >> are asked if they want to visit the site, when they click yes an IE
> >> browser
> >> windows opens directly to our conference booking site. I am trying to do
> >> this using a CommandButton that I have inserted into my form, which I got
> >> from the controls toolbox.
> >>
> >> I am new at this and perhaps I am be trying to do something that cannot
> >> be
> >> done in Outlook 2000, but I am not sure. I seem to remember using a form
> >> once that had a button built into it that opened a webpage.
> >>
> >> Any advice is appreciated.
> >>
> >> Please advise.
> >>
> >> Thank-you,
> >> Charles
>
>
>

My typing appears to be particularly dyslexic this morning. Try
http://www.outlookcode.com/d/secforms.htm

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Cybordelic" <(E-Mail Removed)> wrote in message
news:64CAA371-2743-4D47-AB1A-(E-Mail Removed)...
> When I click on your hyperlink below I get the message "The page cannot be
> found".
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> Code doesn't run in one-off or unpublished forms. The right procedure
>> depends on whether you are working in an Exchange environment and, if so,
>> if
>> you can publish to the Organizational Forms library. See
>> http://www.outlookcode.com/d/formsec.htm
>>
>> --
>> Sue Mosher, Outlook MVP
>> Author of
>> Microsoft Outlook Programming - Jumpstart for
>> Administrators, Power Users, and Developers
>> http://www.outlookcode.com/jumpstart.aspx
>>
>>
>> "Cybordelic" <(E-Mail Removed)> wrote in message
>> news:16EEBA0F-02DE-4D01-AF99-(E-Mail Removed)...
>> > Excellent! I was successful in inserting the code.
>> >
>> > The form works when I run the form and click on the button (opens in
>> > Internet Explorer and goes to the right webpage). But if I save the
>> > file
>> > .oft and close the form, then re-open the form and try to click the
>> > button
>> > is
>> > does nothing. How do I save the form so that the button will work when
>> > I
>> > open the form or send it to my co-workers pc.
>> >
>> > The idea is that we want to allow all users to be able to double click
>> > the
>> > .oft and open the form, fill it out, and send it the address that is
>> > already
>> > populated in the To: field.
>> >
>> > Thanks again!
>> > Charles
>> >
>> > "Cybordelic" wrote:
>> >
>> >> I would like to map a macro to a button in a custom form that I have
>> >> designed. I already have the vbscript, which I got off of the
>> >> VBScript
>> >> section of the MS website, and it works just fine. The script asks
>> >> the
>> >> user
>> >> if they want to visit the conference booking site, and when they click
>> >> on
>> >> yes
>> >> it opens the appropriate page. I just can't seem to figure out how to
>> >> map
>> >> the macro to a button, so that when a user clicks the button in the
>> >> form
>> >> they
>> >> are asked if they want to visit the site, when they click yes an IE
>> >> browser
>> >> windows opens directly to our conference booking site. I am trying to
>> >> do
>> >> this using a CommandButton that I have inserted into my form, which I
>> >> got
>> >> from the controls toolbox.
>> >>
>> >> I am new at this and perhaps I am be trying to do something that
>> >> cannot
>> >> be
>> >> done in Outlook 2000, but I am not sure. I seem to remember using a
>> >> form
>> >> once that had a button built into it that opened a webpage.
>> >>
>> >> Any advice is appreciated.
>> >>
>> >> Please advise.
>> >>
>> >> Thank-you,
>> >> Charles
>>
>>
>>

Thank-you for all of your help Sue!
Since I cannot publish to the "Organizational Forms Library" due to
permissions, what I have suggested as a solution for those people who will
need to use the form is this: first I emailed it to them, then they can
Publish the form and save it in their Personal Form library, and then they
can open the custom form from there. This seems to be working ok. Would you
recommend I do this differently? Can you see a problem with this method?

Charles

"Sue Mosher [MVP-Outlook]" wrote:

> My typing appears to be particularly dyslexic this morning. Try
> http://www.outlookcode.com/d/secforms.htm
>
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Cybordelic" <(E-Mail Removed)> wrote in message
> news:64CAA371-2743-4D47-AB1A-(E-Mail Removed)...
> > When I click on your hyperlink below I get the message "The page cannot be
> > found".
> >
> > "Sue Mosher [MVP-Outlook]" wrote:
> >
> >> Code doesn't run in one-off or unpublished forms. The right procedure
> >> depends on whether you are working in an Exchange environment and, if so,
> >> if
> >> you can publish to the Organizational Forms library. See
> >> http://www.outlookcode.com/d/formsec.htm
> >>
> >> --
> >> Sue Mosher, Outlook MVP
> >> Author of
> >> Microsoft Outlook Programming - Jumpstart for
> >> Administrators, Power Users, and Developers
> >> http://www.outlookcode.com/jumpstart.aspx
> >>
> >>
> >> "Cybordelic" <(E-Mail Removed)> wrote in message
> >> news:16EEBA0F-02DE-4D01-AF99-(E-Mail Removed)...
> >> > Excellent! I was successful in inserting the code.
> >> >
> >> > The form works when I run the form and click on the button (opens in
> >> > Internet Explorer and goes to the right webpage). But if I save the
> >> > file
> >> > .oft and close the form, then re-open the form and try to click the
> >> > button
> >> > is
> >> > does nothing. How do I save the form so that the button will work when
> >> > I
> >> > open the form or send it to my co-workers pc.
> >> >
> >> > The idea is that we want to allow all users to be able to double click
> >> > the
> >> > .oft and open the form, fill it out, and send it the address that is
> >> > already
> >> > populated in the To: field.
> >> >
> >> > Thanks again!
> >> > Charles
> >> >
> >> > "Cybordelic" wrote:
> >> >
> >> >> I would like to map a macro to a button in a custom form that I have
> >> >> designed. I already have the vbscript, which I got off of the
> >> >> VBScript
> >> >> section of the MS website, and it works just fine. The script asks
> >> >> the
> >> >> user
> >> >> if they want to visit the conference booking site, and when they click
> >> >> on
> >> >> yes
> >> >> it opens the appropriate page. I just can't seem to figure out how to
> >> >> map
> >> >> the macro to a button, so that when a user clicks the button in the
> >> >> form
> >> >> they
> >> >> are asked if they want to visit the site, when they click yes an IE
> >> >> browser
> >> >> windows opens directly to our conference booking site. I am trying to
> >> >> do
> >> >> this using a CommandButton that I have inserted into my form, which I
> >> >> got
> >> >> from the controls toolbox.
> >> >>
> >> >> I am new at this and perhaps I am be trying to do something that
> >> >> cannot
> >> >> be
> >> >> done in Outlook 2000, but I am not sure. I seem to remember using a
> >> >> form
> >> >> once that had a button built into it that opened a webpage.
> >> >>
> >> >> Any advice is appreciated.
> >> >>
> >> >> Please advise.
> >> >>
> >> >> Thank-you,
> >> >> Charles
> >>
> >>
> >>
>
>
>

That should work just fine. Congratulations on writing what must have been
clear instructions!

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Cybordelic" <(E-Mail Removed)> wrote in message
news:8687B601-BAAE-4192-94F7-(E-Mail Removed)...
> Thank-you for all of your help Sue!
> Since I cannot publish to the "Organizational Forms Library" due to
> permissions, what I have suggested as a solution for those people who will
> need to use the form is this: first I emailed it to them, then they can
> Publish the form and save it in their Personal Form library, and then they
> can open the custom form from there. This seems to be working ok. Would
> you
> recommend I do this differently? Can you see a problem with this method?
>
> Charles
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> My typing appears to be particularly dyslexic this morning. Try
>> http://www.outlookcode.com/d/secforms.htm

>>
>> "Cybordelic" <(E-Mail Removed)> wrote in message
>> news:64CAA371-2743-4D47-AB1A-(E-Mail Removed)...
>> > When I click on your hyperlink below I get the message "The page cannot
>> > be
>> > found".
>> >
>> > "Sue Mosher [MVP-Outlook]" wrote:
>> >
>> >> Code doesn't run in one-off or unpublished forms. The right procedure
>> >> depends on whether you are working in an Exchange environment and, if
>> >> so,
>> >> if
>> >> you can publish to the Organizational Forms library. See
>> >> http://www.outlookcode.com/d/formsec.htm
>> >>
>> >> --
>> >> Sue Mosher, Outlook MVP
>> >> Author of
>> >> Microsoft Outlook Programming - Jumpstart for
>> >> Administrators, Power Users, and Developers
>> >> http://www.outlookcode.com/jumpstart.aspx
>> >>
>> >>
>> >> "Cybordelic" <(E-Mail Removed)> wrote in message
>> >> news:16EEBA0F-02DE-4D01-AF99-(E-Mail Removed)...
>> >> > Excellent! I was successful in inserting the code.
>> >> >
>> >> > The form works when I run the form and click on the button (opens in
>> >> > Internet Explorer and goes to the right webpage). But if I save the
>> >> > file
>> >> > .oft and close the form, then re-open the form and try to click the
>> >> > button
>> >> > is
>> >> > does nothing. How do I save the form so that the button will work
>> >> > when
>> >> > I
>> >> > open the form or send it to my co-workers pc.
>> >> >
>> >> > The idea is that we want to allow all users to be able to double
>> >> > click
>> >> > the
>> >> > .oft and open the form, fill it out, and send it the address that is
>> >> > already
>> >> > populated in the To: field.
>> >> >
>> >> > Thanks again!
>> >> > Charles
>> >> >
>> >> > "Cybordelic" wrote:
>> >> >
>> >> >> I would like to map a macro to a button in a custom form that I
>> >> >> have
>> >> >> designed. I already have the vbscript, which I got off of the
>> >> >> VBScript
>> >> >> section of the MS website, and it works just fine. The script asks
>> >> >> the
>> >> >> user
>> >> >> if they want to visit the conference booking site, and when they
>> >> >> click
>> >> >> on
>> >> >> yes
>> >> >> it opens the appropriate page. I just can't seem to figure out how
>> >> >> to
>> >> >> map
>> >> >> the macro to a button, so that when a user clicks the button in the
>> >> >> form
>> >> >> they
>> >> >> are asked if they want to visit the site, when they click yes an IE
>> >> >> browser
>> >> >> windows opens directly to our conference booking site. I am trying
>> >> >> to
>> >> >> do
>> >> >> this using a CommandButton that I have inserted into my form, which
>> >> >> I
>> >> >> got
>> >> >> from the controls toolbox.
>> >> >>
>> >> >> I am new at this and perhaps I am be trying to do something that
>> >> >> cannot
>> >> >> be
>> >> >> done in Outlook 2000, but I am not sure. I seem to remember using
>> >> >> a
>> >> >> form
>> >> >> once that had a button built into it that opened a webpage.
>> >> >>
>> >> >> Any advice is appreciated.
>> >> >>
>> >> >> Please advise.
>> >> >>
>> >> >> Thank-you,
>> >> >> Charles
>> >>
>> >>
>> >>
>>
>>
>>