Dear Techies
i have a excel file used by many users across various versions of Excel
The file has the facility to mail thru outlook
this causes reference errors
thanks
Youtham
Dear Techies
i have a excel file used by many users across various versions of Excel
The file has the facility to mail thru outlook
this causes reference errors
thanks
Youtham
Re: various versions of MSOUT.olb
We can't help if you don't explan fully, are you using code? If so what is it?
Re: various versions of MSOUT.olb
hi roy,
i m using the below code and add reference to outlook 11.0 library and send it across to my users sitting in different versions of excel ranging from 97/2003. users having outlook library version below 11.0/10.0 have object reference error.
so i have to manually ask them to add references
Dim OLF As Outlook.MAPIFolder, olMailItem As Outlook.MailItem
Dim ToContact As Outlook.Recipient
Dim SA, SB
SA = ThisWorkbook.Sheets("BC").Range("j2")
Set OLF = GetObject("", _
"Outlook.Application").GetNamespace("MAPI").GetDefaultFolder(olFolderInbox)
Set olMailItem = OLF.Items.Add
With olMailItem
.Subject = SA
.Body = " " & Chr(13)
.Attachments.Add "C:\DEALT.xls.pdf", olByValue, , _
"Attachment"
.OriginatorDeliveryReportRequested = False
.ReadReceiptRequested = False
.Save
End With
' ActiveWorkbook.Close
Kill "C:\DEALT.xls.pdf"
ThisWorkbook.Sheets("BC").Visible = False
ThisWorkbook.Sheets("BCPIC").Visible = False
ThisWorkbook.Sheets("NEWDEAL").Activate
Set ToContact = Nothing
Set olMailItem = Nothing
Set OLF = Nothing
Display More
Re: various versions of MSOUT.olb
maybe you should try setting the reference in the earliest version then distribute that one.
Don’t have an account yet? Register yourself now and be a part of our community!