Printable View
Hi There,
I have Developed a VBA to send mails using Outlook.Mailitem Object...
It Works Fine ... if i start Microsoft Excgange Server first & activate my
acc..& then Start my VBA for sending mails..
it works fine. But if i directly start my VBA for mailing it givies a error
"No Transfer Provider Specified"..
Can Anyone plzz help me & tell me the way i can activate my mail acc
programmatically from my VBA itself & not by starting Microsoft Exchange
First...
Regards Rohan
As far as I know, you will have to put the Microsoft MAPI Session control on your form. If the database will be distributed, you will have to register it on the user's machine also. To use it, place the control on the form. Whenever you need to login to exchange, use this code:
BTW, I called the control acSession...
With acSession
.UserName = "YourName"
.Password = "YourPassword"
.SignOn
End With
If you are using Microsoft Exchange Server to host your mail box, then it will have to be running in order for you to access it.
If you created a local mail box, i.e. a pst file, then you would be able to access it with out Exchange, and send them via your local internet/intranet connection.