none
Hyperlink from Outlook Agenda RRS feed

  • Question

  • My partner wants to be able to open the matching Excel sheets clicking on an appointment in Outlook (2007) Agenda.
    Appointments are put in the Agenda and the name should result in (right) clicking it to open the Excel sheet with the same name made before.
    She is a noknow in doing things with a PC other than simple opening things and write a letter or something like that.
    Making the appointment is the max she can do herself, the hyperlink should be created by a VBA or so at the moment the name is selected from Contacts.

    Can this be done with VBA and if yes what is the used code.

    I do know a bit about VBA but not enough to write it myself.

    Thanks, Bob



    • Edited by lobo405 Monday, April 2, 2012 3:54 PM
    Monday, April 2, 2012 3:52 PM

Answers

All replies

  • I'll proceed without knowing what you mean by the "Agenda".  Calendar?

    Anyway, it sounds like you need to access the names of people invited to a Meeting Request.  If so, you can get this from Recipient objects returned from the AppointmentItem.Recipients collection.  The best time to grab these Recipients is either as they're added (by monitoring the AppointmentItem.PropertyChange event - look for updates to the "To" field) or perhaps during the AppointmentItem.Write event.

    Adding hyperlinks would involve writing to the AppointmentItem.Body property; use text like "HYPERLINK "http://www.domain.com/" texttolink" to create links.  Unfortunately, you can't use HTMLBody like a MailItem object.


    Eric Legault
    MVP (Outlook)
    About me...

    Tuesday, April 3, 2012 2:50 PM
    Moderator
  • Hi lobo405,

    Thanks for posting in the MSDN Forum.

    Would you please clarify the mean of "Agenda"?

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us

    Friday, April 6, 2012 6:35 AM
    Moderator
  • Hi Tom, I already replied yesterday to Eric explaining it, but somehow it hasn't been posted.

    I mean the Calendar and then specifically the appointments made in it.

    My partner started a small business at home (very small :P ) but has enough customers to make it a bit easier to handle.
    She needs to keep track of measured information and show it to those customers (weight, fat, musclestrength etc.)
    So I made an Excsl sheet she can fill in and all results are calculate and compared with each other showing results and comparisons.
    That sheet works fine and is not important here.
    But she is a noknow with PC's so putting an appointment in Calendar of Outlook (or eventually any other usable program) is the max she wants to learn.

    However when she needs to open the Excel file she needs to open the correct one as there are some people with almost the same name :-(
    That's why I try to take care of that from within Outlook Calendar (or if somebody knows a better solution) with a kind of hyperlink to open the correct Excel sheet.

    I don't know much about VBA, can modify and make small things but are still struggling at my age to the VBA books finding it difficult to learn.
    So simple do this do that is not enough.

    Some time ago I was participating with Microsoft Technet so specialise but several things happened that made it impossible for me to continue and I had to stop in a professional way. I still have all books and software but for the rest it's to difficult after what happened.
    I don't want to explain more, hope you understand.

    Therefore I need more detailed help then you may be are used to give ;-)

    Hope somebody knows if it's possible or knows a better solution, help is welcome.

    Best regards, Bob



    • Edited by lobo405 Friday, April 6, 2012 10:12 AM
    Friday, April 6, 2012 10:12 AM
  • I'm not 100% clear on what you are trying to do.  From what I gather, you just want to insert a hyperlink to a file stored in the file system into the body of an Appointment?  If so, edit the AppointmentItem.HTMLBody property.  If your knowledge of VBA doesn't shed any light on how to do this quickly, then you really need to start with the basics.  I'd suggest diving into a couple of references:

    Using Visual Basic for Applications in Outlook:
    http://msdn.microsoft.com/en-us/library/ff863909.aspx

    OutlookCode.com - Developer Learning Center for Microsoft Outlook:
    http://www.outlookcode.com/default.aspx


    Eric Legault
    MVP (Outlook)
    About me...

    Monday, April 9, 2012 3:53 PM
    Moderator
  • Thank you for all advise, I will workout this tip.

    Besides I found the PIM from Essentials doing all this almost the way I want in a very easy way.
    So the thread can be closed.

    Greetings, Bob


    Is this needed?

    Thursday, April 12, 2012 7:30 AM