By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 981 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Sending an email from Access

P: n/a
Tim
I have a field on a form in which the user can type an email address.
I would like to be able to double-click the field and it will open a
blank email to that address.

If you set it as a Hyperlink, it thinks it is a web address and tries
to open a web page.

Does anyone know some VBA that would enable this? I'm guessing it
would take the value from the field/record and pass it to a some kind
of SendEmail method that opens the default email program and inserts
the value as the "to" address.
Alternatively a command button could do it. I've found how to set up a
command button that will open a blank email to a predetermined
address. Is there a way of dynamically (runtime) updating that address
if the value in a field is changed (ie. the user changes the email
address)?

I am using Access 2000 on Windows 2000 and my email client is Lotus
Notes.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Make sure the link is formatted as MailTo:pe****@address.ext?Subject=, Body=
etc.
You can create this string in code and apply it to the Hyperlink Address
property.

Mike Storr
www.veraccess.com
"Tim" <ti**************@hotmail.com> wrote in message
news:b3**************************@posting.google.c om...
I have a field on a form in which the user can type an email address.
I would like to be able to double-click the field and it will open a
blank email to that address.

If you set it as a Hyperlink, it thinks it is a web address and tries
to open a web page.

Does anyone know some VBA that would enable this? I'm guessing it
would take the value from the field/record and pass it to a some kind
of SendEmail method that opens the default email program and inserts
the value as the "to" address.
Alternatively a command button could do it. I've found how to set up a
command button that will open a blank email to a predetermined
address. Is there a way of dynamically (runtime) updating that address
if the value in a field is changed (ie. the user changes the email
address)?

I am using Access 2000 on Windows 2000 and my email client is Lotus
Notes.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.