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

    Join Date
    Apr 2012
    Posts
    1
    Rep Power
    0

    Text selection in email message Outlook 2010


    Hi,
    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?

    Code:
    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
    Location
    OAKLAND CA | Adam's Point (Fairyland)
    Posts
    14,954
    Rep Power
    8617
    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 01:11 PM.
    medialint.com

    “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