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

espenskeie

Well-known Member
Joined
Mar 30, 2009
Messages
636
Office Version
  1. 2016
Platform
  1. 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:

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

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Forum statistics

Threads
1,214,430
Messages
6,119,443
Members
448,898
Latest member
drewmorgan128

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
Back
Top