+ Reply to Thread
Results 1 to 5 of 5

Moving from Office 2003 to Office 2013 - code no longer works

  1. #1
    Registered User
    Join Date
    11-27-2014
    Location
    Midlands, UK
    MS-Off Ver
    2016
    Posts
    22

    Moving from Office 2003 to Office 2013 - code no longer works

    Some years ago I wrote some VBA code to send emails from within Excel for a school application.
    The spreadsheet automated the cover and invigilation process.
    I then retired from teaching and the school continued to use the spreadsheet.
    They have now upgraded to Office 2013 and have asked me for help because the emailing code no longer works.
    Unfortunately I wrote the code 10 years ago and have not kept up with it since, so I am not sure how to proceed.

    It would appear that the process to create an Outlook session in Office 2013 has changed.
    Could someone kindly point me in the right direction?

    The Outlook session code follows:

    Please Login or Register  to view this content.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,691

    Re: Moving from Office 2003 to Office 2013 - code no longer works

    Please explain what "no longer works" means.
    • Does the code run?
    • Does it run but do nothing?
    • Does it produce error messages? If so, what do the messages say?
    • Does it produce unexpected/wrong results?
    • Does it hang?

    Your code looks fine to me. I suspect that the issue is just setting the correct library reference to use the Outlook 2013 object library. If that doesn't ring a bell have a look at this: http://www.seiglefamily.com/excel/references.html
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-27-2014
    Location
    Midlands, UK
    MS-Off Ver
    2016
    Posts
    22

    Re: Moving from Office 2003 to Office 2013 - code no longer works

    Thanks for the reply. Unfortunately I do not yet know what the error messages are. The people at the school contacted me yesterday and did not provide much detail. I had password protected some macros and the passwords they were trying did not work. I suspect someone may have 'fiddled' with them over the years that I have been away.
    I sent them a copy of the spreadsheet with passwords that I knew worked, and I am awaiting a response. I will investigate the link you sent. Much obliged.

  4. #4
    Registered User
    Join Date
    11-27-2014
    Location
    Midlands, UK
    MS-Off Ver
    2016
    Posts
    22

    Re: Moving from Office 2003 to Office 2013 - code no longer works

    Jeff, reading that link refreshed my memory. I now recollect setting the library reference when I first wrote the VBA. If they have not selected the Office 13 Object libraries that would explain why the macro fails.
    Fingers crossed - I think you may have solved the problem!

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,691

    Re: Moving from Office 2003 to Office 2013 - code no longer works

    I think the one you want is "Microsoft Outlook 15.0 Object Library." The internal version numbers are different than the marketing version; Office 13 is version 15.0.

+ 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. Replies: 2
    Last Post: 10-28-2014, 08:32 AM
  2. Open PDf specific page, work with office 2007 but not on office 2013
    By haktak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2014, 01:58 AM
  3. After formatting PC and reinstall Office macro no longer works.
    By oteixeira in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2008, 10:43 AM
  4. [SOLVED] folderexists code no longer works after moving to excel 2003
    By sdharris - ExcelForums.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2005, 05:06 AM
  5. [SOLVED] Office 2003 - "autocomplete" in file | open or file | save no longer works
    By Lanwench [MVP - Exchange] in forum Excel General
    Replies: 4
    Last Post: 01-11-2005, 10:06 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