Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am launching an inter-company spreadsheet that sends an email in a macro.
I am using Outlook version 11, but many others have outlook version 9. Whenever a person using version 9 clicks the button that sends the email from excel, it gives a reference error showing that reference library for Outlook 11 is missing. How can I include some code that will allow both Outlook v.9 and Outlook v.11 users to use the form without an error? Here is my current code line for the outlook reference. Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Dim strdate As String Dim wb As Workbook Dim ws As Worksheet Application.ScreenUpdating = False Set OutApp = CreateObject("Outlook.Application") Any Help is greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set up Outlook email? | New Users to Excel | |||
Outlook Email | New Users to Excel | |||
Email & Outlook | Excel Discussion (Misc queries) | |||
Late Binding to Outlook from Excel: Outlook modifies email body | Excel Programming | |||
Email from Excel WITHOUT Outlook | Excel Programming |