+ Reply to Thread
Results 1 to 3 of 3

Outlook Contacts Pop-up

  1. #1
    Registered User
    Join Date
    11-28-2005
    Location
    Saint Louis, Missouri USA
    MS-Off Ver
    2016
    Posts
    69

    Outlook Contacts Pop-up

    I want my spreadsheet of customer project info, to allow me to click on a button on my custom ribbon group and have Excel pop-up the contact's Outlook card (so I can email or call them using phone dialer).

    I have come across lots of ideas for emailing from Excel, and even creating a task or a calendar event, so I would think it would be very similar to that, but I am not smart enough with VBA to figure it out on my own.

    I'm not asking anyone to write this code for me, but if you've done this before would you please share your code here? Thank you!

    By the way, I am using Office 2007, and Visual Ribbon Editor (and I have that part figured out).

    Alternatively, I was thinking about have an "email", "cell" and "office" button that would still bring up the card, but would automate the process further and go directly to an email dialogue box or make the appropriate call to their phone.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Outlook Contacts Pop-up

    Hello Evanzo,

    I don't have Office 2007, but perhaps this 2003 code can be adapted if it doesn't work. Add in the Contact's full name (first and last name) in the code marked in blue.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    11-28-2005
    Location
    Saint Louis, Missouri USA
    MS-Off Ver
    2016
    Posts
    69

    Re: Outlook Contacts Pop-up

    Leith,

    This works perfectly! Thank you.

    Now, my next project is to have "email", "mobile phone" and "office phone" buttons that automate those processes. Do you have code for that??

    I'm using Outlook's phone dialer feature, but I'd like to turn that process from 4 clicks (using Outlook) to one click (on my new xRibbon buttons).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1