Page 1 of 3 123 LastLast
Results 1 to 15 of 37
  1. #1
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro for Outlook (2003)

    I wanted to run a program from a macro in Outlook, I can get the Macro to open to the folder and I can pick the program name and it works, but if I include the program name in the macro it will not work? any suggestions or assistance?
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macro for Outlook (2003)

    You can run a program like this:

    Shell "C:Program FilesMyProgramMyProg.exe"

    You should, of course, substitute the path and filename of the program.

  3. #3
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro for Outlook (2003)

    Not knowing what I am doing the first attempt was using the hyperlink feature, but it did not like the file name. I did try the "C:......" (other info), failed. I did try placing the word Shell and then the link, failed. I then attempted to write a VB program using your suggestion. I am going to insert the failure information. I think the failure is caused because I am not in the correct folder at the time I attempt to run the program. In the DOS days, I know you could do the Drive letter than a cd to the correct location and then run the program. I tried in the Hyperlink to tell it where to look, but when I re-open the link it switched back to C:My Documents.
    I think if I knew how to tell VB where to swapp to and I do know how to type the longer file names with the tindall !~
    Example: C:Program Files..... etc would be Crogra~1..... etc ? See information below:
    Screen Warning!
    Alphapage pro could not find its setup files in Crogram~1Common~1systemmsmap1033.
    Would you like to create those files now?

    After selecting "NO"
    Screen Note
    AlphaPage Pro cannot run without its data files. you may need to check and be sure
    the working directory specified by the icon you use to start the program is valid.
    Hope this allows someone to assist me? Thank you - Richard Memphis

    "C:Program FilesINFORADWINPAGE.EXE" This is a copy of the Desktop short cut and it dose work the the start in location is as follows. C:PROGRA~1INFORAD. All I want to do is have a way to click on an ICON on the Outlook tool bar and Launch this program? Is that a hard to do request? Very sorry if it is, It would just be very time saving. I also have the pogram AllChars and what a blessing. I learned about it from someone on Woody's - Thank you for that
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macro for Outlook (2003)

    Perhaps you could create a batch file that switches to the correct drive and directory (folder), then launches the program. You can use Shell to run the batch file.

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Macro for Outlook (2003)

    It would be helpful if you would post the code snippet that's causing you problems. (I'm puzzled that this program is looking for files in "Crogram~1Common~1systemmsmap1033", and it should be msmapi, the "i" is missing. Perhaps you could explain more, perhaps provide a vendor link?)

    You could use the VB CurDir function to get the present folder, and then the VB ChDir function to change to the target folder, and then reset to the current folder, like this "air code" example

    Dim strCurrActvFolder as String

    strCurrActvFolder = CurDir ' store current directory location
    ChDir "C:Program FilesINFORAD" ' change directory
    Shell "C:Program FilesINFORADWINPAGE.EXE" ' run program
    ChDir = strCurrActvFolder ' return to original directory
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro for Outlook (2003)

    Thank you, this was so great!
    Dim strCurrActvFolder as String

    strCurrActvFolder = CurDir ' stor current directory
    ChDir "C:Program FilesINFORAD" ' change directory
    Shell "C:Program FilesINFORADWINPAGE.EXE" ' run program
    ChDir = strCurrActvFolder ' return to original ddirectory
    Sub Pager()
    Dim strCurrActvFolder As String
    The following is the only changes I made I had problem after I pressed the OK key on the program that was loaded. Some fault popped up so I remove the last line, not knowing what I was doing. Now when it loads the progam an I press the OK key it moves to the tool bar, so I have to go back and click on it , but I can live with that. I tried removing the word shell to keep in on my desktop screen. then it did not work at all. I also tried changing the word Shell to run, so the program you just helped me load would stay active. Anyway now I want to use your great help to attempt to launch the Caculator from my Microsoft Word Tool bar. I need the caculator a lot.
    strCurrActvFolder = CurDir ' stor current directory
    ChDir "C:Program FilesINFORAD" ' change directory
    Shell "C:Program FilesINFORADWINPAGE.EXE" ' run program
    ' Shell "C:Program FilesINFORADWINPAGE.EXE" ' run program
    ' ChDir = strCurrActvFolder ' return to original ddirectory
    ' Came from WOPAR.COM after asking a question. JohnBf, what a help.

    End Sub
    THANK YOU SO VERY MUCH ! ! !
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Macro for Outlook (2003)

    Which version of Word, and which calculator - what is it called, does it have a separate application name?
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro for Outlook (2003)

    I did a properties and this is what loads my caculator. I was going to leave out the change directory command in your VB you sent and modify the Shell command to use the information below, I think it will work. Did you think of a way to keep the previous program I called pager from going to the tool bar? when you click on the short cut it pops open to the OK key, but when you click the OK your still in the program . I was just making a quick way to send pages to my co-workers and my management bosses. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    C:WINDOWSSYSTEM32calc.exe
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Macro for Outlook (2003)

    I don't know what the pager program is or how it behaves, so I can't help you with it. Many programs take command line instructions which can be used with the SHELL command, such as the imaginary:

    Shell "C:Program FilesINFORADWINPAGE.EXE" /dosomething

    You might see if there are command line instructions in the shortcut that need to be applied to WINPAGE.EXE in the SHELL code line.

    SHELL C:WINDOWSSYSTEM32calc.exe

    should work.
    -John ... I float in liquid gardens
    UTC -7ąDS

  10. #10
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro for Outlook (2003)

    Thank you, the caculator link is working and I will try your suggestion. I will try /open ??? something like that. I could send you a copy of the pager stuff it you like. It just lets you send Text to pagers or numbers. It will load fine if you go through and use the short cut to the program, but this VB is way way over my head. I appreciate people like you pointing us in the right direction. I used to do Basic and Basica <img src=/S/flee.gif border=0 alt=flee width=25 height=25>
    Now I am down to just batch files. I am still looking for a copy of the SUBST.EXE just in case you know where I can find that ? I posted it on the Win 95 section. Could not see any DOS section. <img src=/S/smash.gif border=0 alt=smash width=30 height=26> Thanks for taking the time to assist. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  11. #11
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Macro for Outlook (2003)

    Your questions are breaking into two threads:

    1. As a reminder, I previously asked for a link to the program vendor site, so that Loungers who are familiar with it could help. Text messages can be sent from Outlook just by knowing the text domain name; for example in the US, Verizon wireless customers can be texted at <phonenumber>@vtext.com; text domain names vary by service provider, I think there's a thread on it in the Outlook Forum. No support program is necessary. I suspect, though I don't know, that the same is true of pager services. The only danger in sending text (and pager?) messages from Outlook is forgetting the SMS character limit; long messages will be truncated. Regarding the pager program, it would be helpful if you looked at the application Shortcut Properties and posted the content of the "Target" dialog on the "Shortcut" tab.

    2. It would help if you explain what you want to accomplish - SUBST.EXE may not be necessary.
    -John ... I float in liquid gardens
    UTC -7ąDS

  12. #12
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Macro for Outlook (2003)

    <hr>The only danger in sending text (and pager?) messages from Outlook is forgetting the SMS character limit; long messages will be truncated.<hr>
    The other danger is running up the phone bill. When I was in Toronto, a single text message sent to me via Yahoo! mail arrived dozens of times due to some kind of problem with the gateway. Ouch.

  13. #13
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Macro for Outlook (2003)

    Subst.exe should be in your WindowsSystem32 directory - is it not there?
    Regards,
    Rory

    Microsoft MVP - Excel

  14. #14
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro for Outlook (2003)

    Yes it is, but I am trying to do it in 98, Dos mode before it ever loads to windows. I run the GUI=0 so 98 never goes beyond DOS, My application is out the door at this time. A computer Tech is trying to fix the fact that 98 will not see Drive E: like XP will.
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  15. #15
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro for Outlook (2003)

    John, could you point me in the right direction. When I am in MS Excel 2003, there are a lot of times I want to go stright to outlook and look at the sent folder to see if I completed sending a spreadsheet. how hard or possible is this to have a tool bar command that would switch to the Outlook and go to the sent items folder ? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> would be another handy item. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Or just one to take me over to Outlook and then I could use the macros there.
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

Page 1 of 3 123 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •