Similar Threads
1. Outlook 2003 - does not allow me to access links emailed to me - Microsoft Office Outlook
2. Mail merge from Access/Link Access and Outlook
hullo - -
I have an Access contacts database with both email addresses and building
addresses. I'd like to be able to:
1) set up an 'email these contacts' function (not just copy and paste
emails) - i've already set up queries to select relevant groups
2) set up a 'use these addresses for mail merge' function
I've consulted the help file but can't seem to find anything - can anybody
advise?
thank you thank you
3. Corrupted Dates in Access Link Tables - Linking Access to Outlook( - External Data - Access
4. Linking the actual email-adress from an email-message into Access
In my Access 2003 database, I have a linked table to my Outlook 2003 Inbox.
However, in the "From"-field of the linked table, the actual email-adress is
NOT shown. Instead I see the "email-name" which the sender has chosen, for
instance:
"Reg Taylor"
What I want to see in my linked table is the email-address:
XXXX@XXXXX.COM
Don't know if this is something I fix in Access or Outlook?
Hope somebody can help me, I really need this to work!
5. MS Access linked table to Outlook Mail Folder - date problem - External Data - Access
6. E-mail links to Outlook in Access fields
In MS Word, if you type an email address, it becomes a link automatically. If
you click on that link, it opens Outlook with a new message, ready to create
and send.
I have a field in an Access form (Text Field) for email addresses, and I
would like to have the same functionality. I tried changing the field to a
hyperlink, but it took me to the web instead.
Any suggestions would be most appreciated. Thanks in advance.
--
Norm Shimmel
Butler, PA
7. Can't Access Web Links from Outlook Express Mail
8. Create Link in E-mail that opens an Access database
Hello,
I have read the thread "autofilling access database from outlook" and took
read the link that was posted in the reponse, but I cannot seem to get the
answer I'm looking for.
I have my database set up so that it automatically sends an e-mail to a
person based on form values. I would like to place an embeded link into the
message that will open up the database that sent the e-mail.
If that cannot be done, is there a simple way to add the link manually in
the Outlook message? I just want it to open the database right from the
e-mail so that they do not have to close the message and find the folder that
the database resides in.
I realize that this is an Outlook forum, but here is the VB code in Access
that send the e-mail to outlook:
Dim emailBody As String
Dim emailSubject As String
emailSubject = "Product Test Request"
On Error GoTo btnSend_Click_error
If Me!lboRequestor.ItemsSelected.Count = 0 Then
MsgBox "Please select a test requestor"
Exit Sub
End If
Me.PART_NO.SetFocus
emailBody = "Hello, " & vbCrLf & vbCrLf & _
"A product test request has been issued for the following Part Number: " &
Me.PART_NO.Text & _
vbCrLf & vbCrLf & "Please log into the Product Engineering test database to
review this request, Thank You!"
On Error GoTo btnSend_Click_error
If Me!lboRequestee.ItemsSelected.Count = 0 Then
MsgBox "Please select a test requestee"
Exit Sub
End If
For Each varItem In Me!lboRequestee.ItemsSelected
emName = emName & Chr(34) & Me!lboRequestee.Column(2, varItem) & Chr(34) & ","
Next varItem
For Each varItem In Me!lboRequestor.ItemsSelected
emName2 = emName2 & Chr(34) & Me!lboRequestor.Column(2, varItem) & Chr(34) &
","
Next varItem
'remove the extra comma at the end
'add the requestor to the e-mail list recipients
emName2 = Left$(emName2, Len(emName2) - 1)
emName = emName & emName2
'send message
DoCmd.SendObject acSendNoObject, , , emName, , , emailSubject, emailBody,
True, False
DoCmd.Close acForm, "frmRequest", acSaveNo
DoCmd.OpenForm "frmMain", acNormal, , , , acDialog
btnSend_Click_error:
If Err.Number = 2501 Then
MsgBox "You just canceled the e-mail", vbCritical, "Alert"
End If