Discussion Locked

Email with MS Access

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to have a field in a database with an email address. Is It possible to have an email nessage generated from that field? What would the Field type be?

5 replies

by 3wadman

The Exchange and Outlook Wizard in the ISAM driver, steps you through linking Outlook data using the Access user interface.
VBA code:(Dim wORKsPACE & dATAbASE first)
Set ws = CreateWorkspace("ws", "admin", "", dbUseJet)
sConnect = "Exchange 4.0;MAPILEVEL=Personal Folders|"
Set db = ws.OpenDatabase("C:\Example.mdb", False, False, sConnect)
Set ws.MailItem.Outbox = "To:John

by dklippert

Ought to be easy. Not quite.
From the web:
"you can save 14 bytes per record by simply using a text field, then use the Double-Click event of the text box that displays the email address.
Here's some code:

Private Sub txtEmail_DblClick(Cancel As Integer)
Dim strMail As String
strMail = "#MailTo:" & Me.txtEmail & "#"
Application.FollowHyperlink HyperlinkPart(strMail, acAddress)
End Sub

This discussion is closed to new replies.