Opening outlook from excel?????

S

Susan Lammi

I am unable to start Outlook from Excel (VBA) using either of the
following. I would prefer early binding but will take either....

Both of the set commands results in an Application error
"The instruction at 0x309ad857 referenced memory at 0x00000000. The
memory could not be read.

If I open Outlook manually then either one of the set commands will work
properly.

Excel has the appropriate reference set.

Can someone shed some light on this problem...... Thanks
Set ol = New Outlook.Application
Set myolapp = CreateObject("Outlook.Application")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Can't start outlook from Excel 4
Problem starting Outlook from Excel 0
Command Button - MsgBox 0
Scheduled Task Fails running Code to send Outlook Mail from Excel. 0
Save Excel Attachment Using VBA 2
Outlook Code Run from Excel 3
Can't open outlook from Access on Windows 7 64 bit PC 2

Top