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  5744 
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,511
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: Kemmylinns12 |
last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
|
by: Arjunsri |
last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
|
by: WisdomUfot |
last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
|
by: Matthew3360 |
last post by:
Hi,
I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
|
by: Carina712 |
last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
|
by: BLUEPANDA |
last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
|
by: Ricardo de Mila |
last post by:
Dear people, good afternoon...
I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control.
Than I need to discover what...
|
by: ezappsrUS |
last post by:
Hi,
I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
|
by: jack2019x |
last post by:
hello, Is there code or static lib for hook swapchain present?
I wanna hook dxgi swapchain present for dx11 and dx9.
| |
