A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Open Form from Macro



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 16th 06, 10:41 PM posted to microsoft.public.outlook.program_forms
asousa
external usenet poster
 
Posts: 3
Default Open Form from Macro

Sue,

Your answer did help. I've got little programming background. Even more
so with all the security restrictions nowadays. The problem was that
Outlook had the Macro Security setting set to "High". I found this as I
Googled thru to figure out how to Run the Macro in the VBA environment.

Now I have to figure out how to program a "secure" Macro.

Thanks for the help.

Best Regards,

Alexandre Sousa

Sue Mosher [MVP-Outlook] wrote:
Now, when I press the Button created based on the Macro, nothing
happens.


Repeating: What happens when you step through the macro in the VBA environment?

The reason why I add the recipient last, is because I want to fill the
To: field, which I deleted from the form. This is a tech support
request form. It's supposed to always be delivered to the same address.


No reason why you can't do that before you display it.

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

wrote in message oups.com...
Sue,

Now, when I press the Button created based on the Macro, nothing
happens. The first time, I clicked the button and it showed the form
right away, I filled it, and sent it. Then I could notice Outlook
sending the email. Now, nothings happens at all, after I click the
button.

I also tried to fill the Initial value field, but once I published the
form and then opened it, the address would get replaced with a date.

I'm kind of lost right now.

Best Regards,

Alexandre Sousa

Sue Mosher [MVP-Outlook] wrote:
What precisely didn't work? In other words, what happened when you stepped through the code.

In general when creating new items, Display should be your last statement .

wrote in message oups.com...
Hi,

I've followed the MS KB article to Open Form from a Toolbar Button.

This is the Macro, as I have it in ThisOutlookSession:

Sub DisplayForm()
Set myFolder = Session.GetDefaultFolder(olFolderInbox)
Set myItem = myFolder.Items.Add("IPM.Note.SuppRequest")
myItem.Display
myItem.Recipient.Add ")
End Sub

The only difference from the KB Article is the Recipient.Add. However,
my problem is that I got it to work just as I left my Office, and as
soon as I got home never worked again.

Anyone got a clue?

Best Regards,

Alexandre Sousa



  #2  
Old June 16th 06, 11:42 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Open Form from Macro

Now I have to figure out how to program a "secure" Macro.

See http://www.outlookcode.com/d/vb.htm#selfcert

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

"asousa" wrote in message ups.com...
Sue,

Your answer did help. I've got little programming background. Even more
so with all the security restrictions nowadays. The problem was that
Outlook had the Macro Security setting set to "High". I found this as I
Googled thru to figure out how to Run the Macro in the VBA environment.

Now I have to figure out how to program a "secure" Macro.

Thanks for the help.

Best Regards,

Alexandre Sousa

Sue Mosher [MVP-Outlook] wrote:
Now, when I press the Button created based on the Macro, nothing
happens.


Repeating: What happens when you step through the macro in the VBA environment?

The reason why I add the recipient last, is because I want to fill the
To: field, which I deleted from the form. This is a tech support
request form. It's supposed to always be delivered to the same address.


No reason why you can't do that before you display it.

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

wrote in message oups.com...
Sue,

Now, when I press the Button created based on the Macro, nothing
happens. The first time, I clicked the button and it showed the form
right away, I filled it, and sent it. Then I could notice Outlook
sending the email. Now, nothings happens at all, after I click the
button.

I also tried to fill the Initial value field, but once I published the
form and then opened it, the address would get replaced with a date.

I'm kind of lost right now.

Best Regards,

Alexandre Sousa

Sue Mosher [MVP-Outlook] wrote:
What precisely didn't work? In other words, what happened when you stepped through the code.

In general when creating new items, Display should be your last statement .

wrote in message oups.com...
Hi,

I've followed the MS KB article to Open Form from a Toolbar Button.

This is the Macro, as I have it in ThisOutlookSession:

Sub DisplayForm()
Set myFolder = Session.GetDefaultFolder(olFolderInbox)
Set myItem = myFolder.Items.Add("IPM.Note.SuppRequest")
myItem.Display
myItem.Recipient.Add ")
End Sub

The only difference from the KB Article is the Recipient.Add. However,
my problem is that I got it to work just as I left my Office, and as
soon as I got home never worked again.

Anyone got a clue?

Best Regards,

Alexandre Sousa



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot open Macro Editor antonio Outlook and VBA 2 May 10th 06 07:48 PM
Macro to open, retrieve contents, print, and loop through process Michelle Marie Outlook and VBA 2 February 24th 06 09:39 AM
How do I link a macro to a CommandButton in a custom form, want us Capone2377 Outlook - Using Forms 1 February 5th 06 12:15 AM
Outlook 2000 - Button to run Macro then open Database David C Outlook and VBA 1 January 25th 06 03:44 PM
open outlook data files from vbscript / macro? Mad Scientist Jr Outlook and VBA 2 January 24th 06 10:20 PM


All times are GMT +1. The time now is 12:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.