Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: automated outlook reference in macro

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Leicestershire, U K
    Posts
    160
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    We run outlook 98 on laptops and outlook on dumb winterms on NT within our wan.

    I have designed a sheet for application within the company.

    It is possible to get the help desk to activate the outlook library within each persons excell.

    Is there any way this could be coded into the macro to load the library automatically ?

    My current application email without any issues.


  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this code before running the Outlook code

    Sub RefLibrary_outlook()
    On Error Resume Next
    ThisWorkbook.VBProject.References.AddFromGuid _
    "{00062FFF-0000-0000-C000-000000000046}", 9, 0

    End Sub


    NB: for Outlook 97 use 8 instead of 9


    Ivan

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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