Is it possible to use Outlook 2003 from Excel 2000 through VBA

[prakashsakthivel]

Hi Members,

Is it possible to use Outlook 2003 from excel 2000.

I am using Outlook 2003 and Excel 2000.

While try to send mail automatically from excel 2000 (VBA), Application is giving error msg like It can not be created.

What I have to do?
Could anybody please tell me to handle this issue.

[jeffstl]

Hi Members,

Is it possible to use Outlook 2003 from excel 2000.

I am using Outlook 2003 and Excel 2000.

While try to send mail automatically from excel 2000 (VBA), Application is giving error msg like It can not be created.

What I have to do?
Could anybody please tell me to handle this issue.

Can you be more clear?

Are you trying to create a email message within excel then import it into your outlook application for sending? Or are you trying to actually send an email message from Excel out to an email address?

Also what is the specific error message you are getting from your VBA code?

[kadghar]

Hi Members,

Is it possible to use Outlook 2003 from excel 2000.

I am using Outlook 2003 and Excel 2000.

While try to send mail automatically from excel 2000 (VBA), Application is giving error msg like It can not be created.

What I have to do?
Could anybody please tell me to handle this issue.

Well, Excel has some application dialogs, one of them allows you to send via e-mail the active file, is the xlDialogSendMail constant (189), so something like this will do:

Application.Dialogs(189).Show

But if what you want is the complete job done (sending it, etc), then i'll recomend you to open the Outlook from Excel's VBA as an object, and work with its ActiveX :

dim obj1 as object
set obj1= createobject("outlook.application")

and here you can find out how to work with it.

HTH.