| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I access Outlook Express email address book using Excel | Excel Discussion (Misc queries) | |||
| send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| Cannot previous post - email via access to excel template | Links and Linking in Excel | |||
| Import query from access to excel, link to template, email on | Links and Linking in Excel | |||
Linear Mode
