email from access
 

I want to email from access and there are many information on this .

I try using
http://www.datastrat.com/Code/OutlookEmail.txt
from Arvin Meyer, MCP, MVP
Microsoft Access

I copied his command to a the expression of a command button on click
and it highd the line


and it come up with an errore message

user-defined type not defined

and highlight the line
Dim objOutlook As Outlook.Application


I am not knowlwege of prgograming
can someone help me and tell my why?




--
klam

email from access
 

You have to add reference of Microsoft Outlook in VB editor/Tools/References.

"Klam" wrote:

I want to email from access and there are many information on this .

I try using
http://www.datastrat.com/Code/OutlookEmail.txt
from Arvin Meyer, MCP, MVP
Microsoft Access

I copied his command to a the expression of a command button on click
and it highd the line


and it come up with an errore message

user-defined type not defined

and highlight the line
Dim objOutlook As Outlook.Application


I am not knowlwege of prgograming
can someone help me and tell my why?




--
klam

email from access
 

You must set a reference to Outlook

Look on my site for examples(outlook object model) that use Late binding, no need to set a reference then
http://www.rondebruin.nl/sendmail.htm

If you want to use Early binding read the info below the macro

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Klam" wrote in message ...
I want to email from access and there are many information on this .

I try using
http://www.datastrat.com/Code/OutlookEmail.txt
from Arvin Meyer, MCP, MVP
Microsoft Access

I copied his command to a the expression of a command button on click
and it highd the line


and it come up with an errore message

user-defined type not defined

and highlight the line
Dim objOutlook As Outlook.Application


I am not knowlwege of prgograming
can someone help me and tell my why?




--
klam