good day, i have recently upgraded (lol) to office 2010. i have several vb projects i did in office 2007. and i am coming up with a pile of errors the current one i can not figure out is below here is a snipit of my code
Set oApp = CreateObject("Outlook.Application")
Set oMail = oApp.CreateItem(0)
With oMail
'send to person or group
'.To = "bfrancisco@occimofab.com; davidw@occimofab.com"
'subject of email
.Subject = "For Review And Modification " & ActiveWorkbook.Name & " "
.Attachments.Add oWB.FullName
.Display
End With
when i get to the .attachment.add i get an error that states
Run-time error
you dont have appropriat permission to perform this operation.
this worked with 2003 and 2007.
any help would be appreciated
thanks
andy
Set oApp = CreateObject("Outlook.Application")
Set oMail = oApp.CreateItem(0)
With oMail
'send to person or group
'.To = "bfrancisco@occimofab.com; davidw@occimofab.com"
'subject of email
.Subject = "For Review And Modification " & ActiveWorkbook.Name & " "
.Attachments.Add oWB.FullName
.Display
End With
when i get to the .attachment.add i get an error that states
Run-time error
you dont have appropriat permission to perform this operation.
this worked with 2003 and 2007.
any help would be appreciated
thanks
andy