1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Rep Power

    Text selection in email message Outlook 2010

    Here's the working code for Word 2010 and excel 2010. It's quite obviously what I'm trying to do - I'm selecting part of text and then I run macro. Is there any way to get this working on Outlook 2010 in email message?

    Sub macroGoogle()
    Shell("C:\Users\USERNAME\AppData\Local\Google\Chrome\Application\Chrome.exe -url http:google.co.uk/search?sourceid=chrome&ie=UTF-8&q=") & (Selection)
    End Sub
    The thing is that in Outlook 2010 "Selection" doesn't work at all.

    Could someone help me please?
  2. #2
  3. Type Cast Exception
    Devshed Supreme Being (6500+ posts)

    Join Date
    Apr 2004
    OAKLAND CA | Adam's Point (Fairyland)
    Rep Power
    You can't shell an executable from an email it's a security breach (besides making the assumption that your reader actually has chrome installed and it's installed at that absolute path) try a hyperlink :-\ VBA macros are for MS Office only, and if anyone has a mail server that does not block these in emails then I suggest that person find a mail server that does. Macros are simply not for outbound email.
    Last edited by medialint; April 19th, 2012 at 02:11 PM.

    “Today you are You, that is truer than true. There is no one alive who is Youer than You.” - Dr. Seuss

IMN logo majestic logo threadwatch logo seochat tools logo