ajosephson
asked on
MS Outlook VBA - to launch a browser and/or goto a URL
Hi
Using Outlook rules to execute a VBA script upon receipt on an email, I'd like the script to go to a URL with the email subject appended..
Here is where I'm at -
ALT-11 to open VBA debugger in Outlook
The Outlook rule runs the following script (which displays a MSG box with the subject) ->
Sub CustomMailMessageRule(Item
MsgBox "Mail message arrived: " & Item.Subject
End Sub
I'd like to know how to do this (example)->
Sub CustomMailMessageRule(Item
" ExecuteInternetExplorer ("http://192.168.0.66/displaytext?text=New+email" & Item.Subject "
End Sub
I know very very little about VBA - pls only respond if you’re fairly sure you have an answer.
Rdgs
AJ
Using Outlook rules to execute a VBA script upon receipt on an email, I'd like the script to go to a URL with the email subject appended..
Here is where I'm at -
ALT-11 to open VBA debugger in Outlook
The Outlook rule runs the following script (which displays a MSG box with the subject) ->
Sub CustomMailMessageRule(Item
MsgBox "Mail message arrived: " & Item.Subject
End Sub
I'd like to know how to do this (example)->
Sub CustomMailMessageRule(Item
" ExecuteInternetExplorer ("http://192.168.0.66/displaytext?text=New+email" & Item.Subject "
End Sub
I know very very little about VBA - pls only respond if you’re fairly sure you have an answer.
Rdgs
AJ
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.... had come up with same from http://www.vba-programmer.com/VB_Code/URL_from_ShellExecute.txt
Works great!
Works great!
Glad I could help you (and also very good from you that you also look at other sites to see if there are solutions).
Is there somenthing not working from the solution I provided ?