+ Reply to Thread
Results 1 to 3 of 3

Lotus Notes and Outlook

  1. #1
    Forum Contributor
    Join Date
    05-13-2013
    Location
    Swindon UK
    MS-Off Ver
    Excel 2010
    Posts
    277

    Lotus Notes and Outlook

    HI

    I have a work book where the user can click on a button to send and email with Lotus notes and if the user is using Outlook they click another button to send the email.

    what i want to do is join then so if im using Outlook i click on the button thats linked to Lotus notes and it knows im not on lotus noets thens goes the the next code and use Outlook.

    I thought it would be a simple code like a " on error resume next" but i cout not get it to work

    here is the code that i have

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Lotus Notes and Outlook

    Does this help?

    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: Lotus Notes and Outlook

    There are 2 ways of determining which email client someone uses. Either set On Error Resume Next and try to instantiate an instance of (say) Lotus then Outlook and run with whichever one doesn't cause an error. Or use the registry key to see what the user's default client is (better if they might have both installed).
    The latter one is something like this:
    Please Login or Register  to view this content.
    And the former one is like this:
    Please Login or Register  to view this content.
    Hope that helps.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatic send email change from Outlook to Lotus Notes
    By thuydo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2015, 12:19 AM
  2. Send attached spreadsheet with outlook or lotus notes
    By RANDY LIPOSKY in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2014, 01:48 PM
  3. Send Email - Outlook to Lotus Notes
    By davix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2013, 08:54 AM
  4. Changing VBA code from Outlook to Lotus Notes
    By tommytee in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-01-2011, 07:05 AM
  5. Advantages of Outlook compared Lotus Notes
    By johnjohns in forum Outlook Formatting & Functions
    Replies: 5
    Last Post: 07-31-2010, 07:17 AM
  6. mailto LOTUS NOTES (not Outlook)
    By vicmartin in forum Excel General
    Replies: 1
    Last Post: 12-26-2009, 09:16 PM
  7. how to determine if user has Outlook or Lotus Notes
    By jseven in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2006, 08:30 PM

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