ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   outlook and excel (https://www.excelbanter.com/excel-programming/403594-outlook-excel.html)

Excellaro

outlook and excel
 
I use this code normally for creating emails from template oft, but now i
get a
run time error -2147024770 on creating object statement

Of course i add the relation sto outlook object library but....?


Dim myOlApp As Outlook.Application
Dim myItem As Outlook.MailItem

Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItemFromTemplate("C:\Prova.oft")





Excellaro

outlook and excel
 
Found it on my own, thanks anyway




All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com