How do I send emails from an email field in a Form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Wanting to get a hyperlink field to open a blank email (Outlook/OE) Using a
hyperlink field one can get it to work putting "mailto:" though not wanting
to see the mailto bit, or have it as a default value. There must be an easier
way...any help gratefully appreciated!
 
Wanting to get a hyperlink field to open a blank email (Outlook/OE) Using a
hyperlink field one can get it to work putting "mailto:" though not wanting
to see the mailto bit, or have it as a default value. There must be an easier
way...any help gratefully appreciated!
Click to expand...

Change the field's datatype from Hyperlink to Text.
No need to write the "MailTo:" with each address, just the address.
On a form, either add a command button and code it's click event or
code the double-click evengt of the address control:

Application.FollowHyperlink "MailTo:" & [ControlName]
 
I can't get it to work. It pops up an error message saying, database cannot
find the macro 'Application'.

Please help.

Michelle

fredg said:
Wanting to get a hyperlink field to open a blank email (Outlook/OE) Using a
hyperlink field one can get it to work putting "mailto:" though not wanting
to see the mailto bit, or have it as a default value. There must be an easier
way...any help gratefully appreciated!
Click to expand...

Change the field's datatype from Hyperlink to Text.
No need to write the "MailTo:" with each address, just the address.
On a form, either add a command button and code it's click event or
code the double-click evengt of the address control:

Application.FollowHyperlink "MailTo:" & [ControlName]
Click to expand...
 
Michelle, you need to enter the code within a module that is called by the
"click event or code the double-click evengt of the address control:"

In design view, click the control and look at the properties. If you want it
to run on the double clisk, look for the event "On Dbl Click". Click on that
property and you will see 3 dots appear to the right of the property. CLick
those and select "Code Builder"

You should end up with

Private Sub Address_DblClick(Cancel As Integer)

End Sub

THEN put the code between the lines, ie


Private Sub Address_DblClick(Cancel As Integer)
Application.FollowHyperlink "MailTo:" & [ControlName]
End Sub




Michelle Lee said:
I can't get it to work. It pops up an error message saying, database cannot
find the macro 'Application'.

Please help.

Michelle

fredg said:
Wanting to get a hyperlink field to open a blank email (Outlook/OE)
Using a
hyperlink field one can get it to work putting "mailto:" though not
wanting
to see the mailto bit, or have it as a default value. There must be an
easier
way...any help gratefully appreciated!
Click to expand...

Change the field's datatype from Hyperlink to Text.
No need to write the "MailTo:" with each address, just the address.
On a form, either add a command button and code it's click event or
code the double-click evengt of the address control:

Application.FollowHyperlink "MailTo:" & [ControlName]
Click to expand...
Click to expand...
 
Hi JohnFol!!

Thank you so much for your help!! It works!! ^_^

JohnFol said:
Michelle, you need to enter the code within a module that is called by the
"click event or code the double-click evengt of the address control:"

In design view, click the control and look at the properties. If you want it
to run on the double clisk, look for the event "On Dbl Click". Click on that
property and you will see 3 dots appear to the right of the property. CLick
those and select "Code Builder"

You should end up with

Private Sub Address_DblClick(Cancel As Integer)

End Sub

THEN put the code between the lines, ie


Private Sub Address_DblClick(Cancel As Integer)
Application.FollowHyperlink "MailTo:" & [ControlName]
End Sub




Michelle Lee said:
I can't get it to work. It pops up an error message saying, database cannot
find the macro 'Application'.

Please help.

Michelle

fredg said:
On Fri, 12 Nov 2004 03:38:02 -0800, JohnnyD wrote:

Wanting to get a hyperlink field to open a blank email (Outlook/OE)
Using a
hyperlink field one can get it to work putting "mailto:" though not
wanting
to see the mailto bit, or have it as a default value. There must be an
easier
way...any help gratefully appreciated!

Change the field's datatype from Hyperlink to Text.
No need to write the "MailTo:" with each address, just the address.
On a form, either add a command button and code it's click event or
code the double-click evengt of the address control:

Application.FollowHyperlink "MailTo:" & [ControlName]
Click to expand...
Click to expand...
Click to expand...
 
Back
Top