Email sending with Access

[border20]

I tried sendind an Email throught outlook using some code a found on a mricrosoft website and in a book but I had an error on the following line telling me that avtiveX could not create an object..
:
Set olApp = CreateObject("Outlook.Application")

anyone know why that is ??

or anyone know a another way to send email without Outlook ??

Thx for your help!!

 

[scottfarcus]

You probably don't have a reference set to Outlook.

Open any code window.

Got to Tools>>References.

A dialog box will open.

Scroll down until you see Microsoft Outlook.

Check the box next to it.

Click OK.

Try your code again.

Good luck!

 

[border20]

Not it

No i though about the reference... that is not the problem

 

[Mile-O]

When I send stuff through Outlook via Access I use the DoCmd.SendObject command.

If you have problems with the code you can create a macro to do the same thing.

 

[scottfarcus]

I send email through Outlook all the time.

If you'd like, send me an email (with your code or db attached if you like) and I'll try to help noodle it through.