espenskeie
Well-known Member
- Joined
- Mar 30, 2009
- Messages
- 636
- Office Version
- 2016
- Platform
- Windows
Hi
I have created a VBA for someone else, and on his computer it seem to not be able to start the "Outlook.Application" and therefore no emails are created.
When I test it on my computer it Works just as intended.
We both run Office 2016, and seem to have the same Librarys activated under References in the VBA module.
What could be the reason? I think he run his Excel file from a partition that is located on a server, but when I do the same on my computer it Works, but i do not use his folder on the server. Could it be some issue With the folder that prevents Outlook.Application not to run?
There are no error Messages, the runs and nothing happens.
I am not able to paste the code here, not sure why... but it is standard Outlook code:
Thanks
ES
I have created a VBA for someone else, and on his computer it seem to not be able to start the "Outlook.Application" and therefore no emails are created.
When I test it on my computer it Works just as intended.
We both run Office 2016, and seem to have the same Librarys activated under References in the VBA module.
What could be the reason? I think he run his Excel file from a partition that is located on a server, but when I do the same on my computer it Works, but i do not use his folder on the server. Could it be some issue With the folder that prevents Outlook.Application not to run?
There are no error Messages, the runs and nothing happens.
I am not able to paste the code here, not sure why... but it is standard Outlook code:
Code:
Sub email()
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application") 'Here it says "Outlook"
Set OutMail = OutApp.CreateItem(0) 'This seems to fail
Thanks
ES