A macro cannot be distributed as an executable. See http://www.outlookcode.com/article.aspx?id=28 To open a browser window with a specific URL, you can use code like this: strURL = <expression to build the URL you want to navigate to> Set objWeb = CreateObject("InternetExplorer.Application") objWeb.Navigate strURL
Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54
<stathisgotsis@hotmail.com> wrote in message news:8e283bc8-0675-4c50-9751-e73ad398a592@m36g2000hse.googlegroups.com...
> Hello everyone, > > What i need to do is create an outlook macro using vba, which opens > an IE window (with some certain query string based on the appointment > that is selected on the calendar). What would be the proper way to do > that? > > Furthermore, i would like to distribute this macro to many users > perhaps as an executable. Any help appreciated. > > Thank you.
11 Jun 2008Create new macro in outlook.stathisgotsis@hotmail...
11 Jun 2008\ Re: Create new macro in outlook.Sue Mosher [MVP-Outlook]
All times are in (US) Eastern Daylight Time (GMT -4:00)