By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,373 Members | 1,792 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,373 IT Pros & Developers. It's quick & easy.

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

P: 57
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.
May 6 '08 #1
Share this Question
Share on Google+
2 Replies


jeffstl
Expert 100+
P: 432
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?
May 6 '08 #2

kadghar
Expert 100+
P: 1,295
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:

Expand|Select|Wrap|Line Numbers
  1. 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 :

Expand|Select|Wrap|Line Numbers
  1. dim obj1 as object
  2. set obj1= createobject("outlook.application")
and here you can find out how to work with it.

HTH.
May 6 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.