Email links on forms

  • Thread starter Thread starter John Hipskind
  • Start date Start date
J

John Hipskind

Using Insert->Hyperlink, individual email links can be
added to a form by manually entering all the required
information,

However, I would like to use email addresses that are a
field of the underlying table. When an address of any
record is clicked (as displayed in the form), Outlook
would open to complete the task.

Is there a way to do this?

Thanks.

John
 
This works if you mess with parsing the hyperlink entry using
HyperlinkPart() to ensure it has a prefix of
mailto:

However, I've found it easier to just use a Text field.
You can make it look and behave like a hyperlink if you use SendObject in
the Click or DblClick event of the text box.
 
But what if the link is on a subform? (I can get this to
work on one machine but not another, even though I have
copied the latest to another machine and even though all
references are the same for both machines.)For instance,
I have the following code placed inside the "subform"
instead of adding it somewhere on the Main form.

As I said, it works on my machine but not another's.
When we try it on another machine, the machine locks up.
We can save and exit Outlook but when we return to
Outlook, the message is not in the Drafts section but
rather in the "Inbox" without the "From" showing at this
point. The reason we want to open it for edit is because
we need to change a date and attach a document. (When we
do a mass mailing, we have something different set up in
a module that automates the entire process.)

At first I had set this to Private and then changed it to
Public, thinking perhaps this would make a difference but
it has not made a difference. Here is the code.

Public Sub ConEmail1_DblClick(Cancel As Integer)
DoCmd.SendObject acSendNoObject, , acFormatRTF,
[ConEmail1], , , "NRV/Mack " & _
"Routing Instructions", "Please replace any
previous routing instructions with " & _
"the attached updated copy. Confirmations are
required on this update dated " & _
"October 2, 2003. The attached document contains
your current routing instructions " & _
"for product shipped from the locations noted on
Page One to Mack " & _
"Trucks in Dublin, VA, and its third-party
suppliers. Make corrections to the shipping " & _
"location if necessary, then sign and date the first
page, and fax it back " & _
"to Volvo Logistics North America at 540-674-8730.
If you are " & _
"not the appropriate person to receive these
instructions, " & _
"please forward them to the responsible party.", True


End Sub

Thanks for any assistance.
--Linda Brown
 
What error message are you receiving?
It may be that the email software is not correctly registered in the
machines where it fails.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Linda Brown said:
But what if the link is on a subform? (I can get this to
work on one machine but not another, even though I have
copied the latest to another machine and even though all
references are the same for both machines.)For instance,
I have the following code placed inside the "subform"
instead of adding it somewhere on the Main form.

As I said, it works on my machine but not another's.
When we try it on another machine, the machine locks up.
We can save and exit Outlook but when we return to
Outlook, the message is not in the Drafts section but
rather in the "Inbox" without the "From" showing at this
point. The reason we want to open it for edit is because
we need to change a date and attach a document. (When we
do a mass mailing, we have something different set up in
a module that automates the entire process.)

At first I had set this to Private and then changed it to
Public, thinking perhaps this would make a difference but
it has not made a difference. Here is the code.

Public Sub ConEmail1_DblClick(Cancel As Integer)
DoCmd.SendObject acSendNoObject, , acFormatRTF,
[ConEmail1], , , "NRV/Mack " & _
"Routing Instructions", "Please replace any
previous routing instructions with " & _
"the attached updated copy. Confirmations are
required on this update dated " & _
"October 2, 2003. The attached document contains
your current routing instructions " & _
"for product shipped from the locations noted on
Page One to Mack " & _
"Trucks in Dublin, VA, and its third-party
suppliers. Make corrections to the shipping " & _
"location if necessary, then sign and date the first
page, and fax it back " & _
"to Volvo Logistics North America at 540-674-8730.
If you are " & _
"not the appropriate person to receive these
instructions, " & _
"please forward them to the responsible party.", True


End Sub

Thanks for any assistance.
--Linda Brown
-----Original Message-----
This works if you mess with parsing the hyperlink entry using
HyperlinkPart() to ensure it has a prefix of
mailto:

However, I've found it easier to just use a Text field.
You can make it look and behave like a hyperlink if you use SendObject in
the Click or DblClick event of the text box.
Click to expand...
Click to expand...
 
Back
Top