Hi, I am a volunteer for a small not for profit organization. I got the job to develop a database to store member info b/c I did a 3 day course on Microsoft Access. In the database, one of the fields is 'email address'. I want the field hyperlinked through VBA code so that when I click the address, outlook/outlook express opens a new email to send. Has anyone written the code to do this so that I can cut and past into my database? I use Access 2003. Cheers
6  5778 
Jenny,
I posted a link to your thread in the Access forum someone should be able to assist you better. Use the Access forum, not all the experts on TSDN check the general forums.
Welcome,
Aric
Jenny,
I posted a link to your thread in the Access forum someone should be able to assist you better. Use the Access forum, not all the experts on TSDN check the general forums.
Welcome,
Aric
Thanks Aric,
I'm very new to this- appreciate the help.
Jenny
Thanks Aric,
I'm very new to this- appreciate the help.
Jenny
No problem, this site has some real "Access Experts" if you need help I would post in that forum, .
NeoPa 32,556
Expert Mod 16PB
I'm not very experienced with e-mailing in code I'm afraid.
However, if you're not particular about needing the client then, VBA can e-mail something directly for you - without operator involvement.
I can't remember the exact command - as I say I don't use it myself - but a trawl through the Access forum should find something. I know it's been asked about before.
I'm not very experienced with e-mailing in code I'm afraid.
However, if you're not particular about needing the client then, VBA can e-mail something directly for you - without operator involvement.
I can't remember the exact command - as I say I don't use it myself - but a trawl through the Access forum should find something. I know it's been asked about before.
Just display an <a link on your screen and anyone who clicks opens the default email client. [html]<a href='mailto:you@yoursite.com'>Send an email</a>[/html]
Ronald
Hi, I am a volunteer for a small not for profit organization. I got the job to develop a database to store member info b/c I did a 3 day course on Microsoft Access. In the database, one of the fields is 'email address'. I want the field hyperlinked through VBA code so that when I click the address, outlook/outlook express opens a new email to send. Has anyone written the code to do this so that I can cut and past into my database? I use Access 2003. Cheers
If you change the datatype of the field 'email address' to hyperlink it should open the default outlook or outlook express with a new email. You may have to add 'mailto:' before some or all of the addresses already entered.
Mary
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Google Mike |
last post by:
I've got RH9 Linux with default PHP.
Is there a way to send email on Linux to an Exchange Server from PHP
and/or other tools when there is *NOT* SMTP access?
Has anyone figured out a way to...
|
by: Chuck Farah |
last post by:
I am unsuccessfullly trying to display an outlook email
from a vb web forms (.net) outlook 2002
#1. is it possible to use outlook client email from a web
form using the outlook object model...
|
by: Phil Stanton |
last post by:
Can anyone give me sone code to add addresses from a query to an Outlook
Address book. The problem is that I want to add the new email addresses to a
distribution list, not to the main email list
...
|
by: Strasser |
last post by:
In Access2000 mass emailing worked perfectly (very powerful tool!).
Doesn't work when using XP version of both Access and Outlook, even
though I checked the box to ensure that I was sending the...
|
by: lauren quantrell |
last post by:
Is there a way to open the MS Outlook address book using VBA and then
be able to do something with the return value?
I want users to click an icon to open the Outlook address book then
when an...
|
by: Thejus |
last post by:
Hi,
I want to launch Outlook express with attachment. Any ideas ?
Thanks
Thejus
|
by: cj |
last post by:
Say I could say for a fact the program would work only with Outlook.
Does outlook make any methods or properties available that would allow
me to launch it and populate subject and body?
How...
|
by: Larry Rebich |
last post by:
I'm trying to launch the user's email client using 'MailTo:'. So I put a button on an aspx page and wrote
some .vb code to use 'Mailto:' and it works on my development machine when I
press the...
|
by: emandel |
last post by:
I have searched the forum and the help and am still very confused.
I have a simple table with one of the fields e-mail.
I have a simle form for that table.
Where the contact's e-mail comes up,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
