Hi,
You can use the programmatic part of Outlook, visual basic from access, very
easy ....
Public Sub SendOutlookMail(Subject As String, Recipient As _
String, Message As String)
On Error GoTo errorHandler
Dim oLapp As Object
Dim oItem As Object
Set oLapp = CreateObject("Outlook.application")
Set oItem = oLapp.createitem(0)
'
With oItem
.Subject = Subject
.To = Recipient
.body = Message
.Send
End With
'
Set oLapp = Nothing
Set oItem = Nothing
'
Exit Sub
errorHandler:
Set oLapp = Nothing
Set oItem = Nothing
Exit Sub
End Sub
Taken from
http://www.freevbcode.com/ShowCode.asp?ID=159
-----Mensaje original-----
De: AccessDevelopers@yahoogroups.com
[mailto:AccessDevelopers@yahoogroups.com] En nombre de C
Enviado el: sábado, 27 de octubre de 2012 11:30 a.m.
Para: AccessDevelopers@yahoogroups.com
Asunto: [AccessDevelopers] Re: Installed Access 2000 on Win 7 and now
getting a error msg
--- In AccessDevelopers@yahoogroups.com, "C" <advotee@...> wrote:
>
> Text is not an item in the list...
>
> WHEN IT IS AN ITEM IN THE DROP DOWN LIST...
>
> it is compiled properly... and when you select The ITEM from the drop down
list the after update event works just fine... but you cannot hit enter when
the item is in the text box else you get error
>
> Text is not an item in the list...
>
> Worked before with the enter key on win xp but not now with new install in
win 7 so ??
>
> thanks.. .
>
After a little time checking this from every direction... It finally dawned
on me to CHECK IF THE NEW INSTALL WAS WIN 7 64 BIT... and it was...
so these errors are 64 Bit errors... on Win XP 32 Bit this Access DB
software worked perfectly for nine years... and has made many redic errors
now on Win 7 64 Bit...
Now we either Roll back to 32 Bit Win 7 or ?
thanks... C
------------------------------------
Please zip all files prior to uploading to Files section.Yahoo! Groups Links
-----
Se certificó que el correo no contiene virus.
Comprobada por AVG - www.avg.es
Versión: 2012.0.2221 / Base de datos de virus: 2441/5357 - Fecha de la
versión: 27/10/2012
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar