Open microsoft outlook by clicking field on SSRS report

  • I know this is possible in Business Objects, maybe it is here too, but I cannot seem to figure it out or find it. Any help or direction will be greatly appreciated.

    How can I open microsoft outlock by clicking on the email field on an SSRS report?

    Thanks,

    Sam 🙂

  • Simply add this linke in Action-->Go to URL -->fx : "MailTo:username"

  • Hi,

    What is the command for BCC and CC , I tried MailCC or MailBCC and it didn't work.

    Thanks

  • leefuji (10/22/2012)


    Hi,

    What is the command for BCC and CC , I tried MailCC or MailBCC and it didn't work.

    Thanks

    http://webdesign.about.com/od/beginningtutorials/a/aa041700b.htm

    code example:

    <a href="mailto:firstEmail@email.com, SecondEmail@email.com?bcc=TheBlidRecipient@email.com& cc=thirdaddress@email.com&subject=heres%20The%20Info%20You%20Asked%20For"> Click me!</a>

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Lowell,

    Your code didn't work as is because I'm working in SSRS and I had to tweak a few things but it definitely pointed what I needed to look for. thanks for your help 🙂

    Here is the final code I used to have a TO email and BCC email in SSRS that auto inserts into Microsoft Outlook.

    ="MailTo:FirstPerson@xyz.com" & "?bcc=BlindOne@xyz.com" & "&Subject=Here goes my Subjecet" & "&Body=And here goes the body messagel"

    Regards,

    Lee

  • Hi there

    I don't suppose it's possible to fire up the mail client with the report embedded or attached?

    Thanks

  • Hello,

    I am trying to get this to work. I have a text box that I have added an action. In the action I have go to URL. For the URL, I have:

    mailto:"recipient1@domain.com"&"?cc=recipient2@domain.com" & "&subject=Report Feedback"

    This opens Outlook as expected and has the subject, but it is only addresses to recipient1, there is nothing in cc.

    How can I get this report to go to both recipients? I have also tried just putting them both in the main line with a comma between them, but that doesn't work either.

    Thanks!

  • I had this same issue, I needed to send about 10 emails but I could only get one to show as well. I could only find a work around not a solution and that was to create a an email group in outlook and name that email group as the recipient. For example Client@EmailGroup and in outlook I would have all the emails needed grouped as that name.

  • We had this same trouble. We never found a solution to include multiple parties in the To line but we can include many in the CC line. We placed the following in the Action as 'Go to URL.'

    ="MailTo:user.one@email.com" & "?cc=user.two@email.com;user.three@email.com"

    However, in order to stop confusion we found that we could leave mailto blank and put all recipients in the CC line. This helped us politically.

    ="MailTo:" & "?cc=user.one@email.com;user.two@email.com;user.three@email.com"

  • Good to know. Thanks!

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply