VBA sending emails, works on one computer, does not work on another

espenskeie

Well-known Member
Joined
Mar 30, 2009
Messages
632
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:

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
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,130,176
Messages
5,640,614
Members
417,158
Latest member
jimmy1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top