Topics Search

Email Addresses Changed From "mailto:" To "http://"

Email Addresses Changed From "mailto:" To "http://"
Views: 4
I have a hyperlink field meant for employee email addresses. I noticed, however, that some (not all) of the email addresses are now http addresses. I can see the full hyperlink in thetable with the F2 key and they look like:


A.) How is this happening in the first place?
B.) How can I prevent the "[LINK] from happening?
C.) How can I change all of the "[LINK] back to "mailto:"?
Sponsored Links:

More topics


I get duplicate values when I convert a hyperlink field to text

Every time I import a query containing email addresses from Access into Excel, I end up with a "rider" on each email that looks like this: "[@email]#mailto:[@email]#". I tried to overcome the problem by making a new table with the email field changed from hyperlink to text, but the result was the same as above. Does anyone know why this happens and how to prevent it?

How to change http:// to mailto: in hyperlink

I did it! I cant believe it!
I was trying to fix the problem of the hyperlink issue, changing it from http:// to mailto: if you want to send email by outlook do the following:

1. Temporarily change the datatype of your field to TEXT
2. Run the following update statement (changing the table name and field
name appropriately):

UPDATE HyperLinks SET HyperLinks.EmailAddress = "#Mailto:" &

3. Change the datatype of y our field back to Hyperlink.

I did it and worked

Email individuals Info

I have a quick question.

I am using the following code to send the contents of a record set row to email addresses in the contents of a different row.

Set rstAM = New ADODB.Recordset
rstAM.CursorLocation = adUseClient
rstAM.Open "Select * From tblTest", _
CurrentProject.Connection, adOpenKeyset, adLockOptimistic

Dim r1, r2, r3 As String

Do While Not rstAM.EOF
r1 = rstAM![EmpName]
r2 = rstAM![Email Address]
r3 = rstAM![Prim Bucket]

DoCmd.SendObject , "", "", _
r2, "", "", Hello, _
Chr(13) & r1 & Chr(13) & " You are selecting " & r3 & Chr(13) & Chr(13) & "Than You," & Chr(13) & "Management" & vbCrLf & vbCrLf, True, ""

The below is what appears in the "To:" section xxx.xxxx.xx#

It doubles up the recipient.
Any reason or fixes for this

Email with CC/ and Subject Line

I only use basic/easy codes to make my databases run more efficiently, I depend mostly on Macros. Can anyone help with a basic code to add a "CC" and "Subject" line to an outlook email populated from a command button?

but I want to add a CC email address and an automatic subject.

1) Private Sub SELECT_DblClick(Cancel As Integer)
2) FollowHyperlink "mailto: EMAIL ADDRESS"
3) End Sub

Multiple Reports in cmd.SendObject

This code works great to create an email with my report, but I have another report I would like to send, and possibly a third. How can I put in a record seperator, much like ; for email addresses, so that it looks for the second report as well. ; , - '*' none of these work.

DoCmd.SendObject acSendReport, "reportname", "PDF", strTo, ";", , "subject", "Text Body", , 0

Validation rule for email address

I am trying to put a validation rule into my table for an email address, to dictate that the last part of the email MUST be

I have reviewed this forum, as well as others and have tried various ways.

Is null or (Like "*?*")
Is null or ((Like "*?*") And (Not Like "*[ ,;]*"))
Is Null OR ((Like "*?@?*.?*.?*") AND (Not Like "*[ ,;]*"))

The problem is that when I either try to test the rule on exisiting data or import new data, I receive an error that my data does not match the rule. I have verified that my email addresses are all

send email to email addresses in database?

I have a table that keeps track of different managers for different departments. Each department has their own row of the table where we keep track of first/last names and email addresses of all the managers of each department (each departement has multiple managers). So, each row will have multiple email addresses.

How can I make a button that will automatically insert all the email addresses into the "To" field of a new Outlook message

Auto Send Outlook Email

I have some basic code that auto sends an email:

DoCmd.SendObject , , , "", , , "Onboard Notice", msg, 0

But before it sends I get a pop-up from Outlook that reads "A program is trying to access e-mail addresses. do you want to allow this? ."

address table with two foreign keys

My addresses table used to have a single foreign key - customers. Now that "buildings" entity is introduced, I also need to store addresses of buildings of interest.

If I were at the design stages of the database, I would have created a master "address owners" table, with one-to-one relationships to "customers" and "buildings" and a one to many relationship to addresses. However, the database is in use.

In order to relate "buildings" to "addresses" with referential integrity, I added another FK column to "addresses" to hold "buildings" PK. This works as intended, however now the addresses table have two FK columns that are both destined to be half null forever.

My fear is that would this structure cause problems down the road? Is itworth it to spend some hours to merge the PK's of my master tables (customers and buildings) into an "address owners" table whose sole purpose is to generate autonumber PK's forthose tables?

Sendobject to addresses in a query

I'm designing a database for a computer shop and one of the features is a report showing all the customer information. I put a button up the top of the report labelled 'Mass Mailout' and want it to send an email to every address listed. I created a query of just email addresses with the criteria


to remove any blank fields, and earlier in my project I used a sendobject to one address in this fashion:

DoCmd.SendObject _
Me.Text1, _
Me.Text3, _
Me.Text5, _
False MsgBox ("Message Sent")

My question is how do I get the 'to' field in outlook to list all the email addresses in the query