How do I email from Access

G

Guest

Help.
I have a Contact management Database in Access, together with various
information including email address.
I want to be able to click on a contacts details and it opens up Outlook, in
the same way as it would in excel. I moved to Access from Excel to make
things easier, however, not being able to simply click to open Outlook
sometimes makes it more time comsuming.
Is there a simple way to achieve this? I say simple as I'm no programmer
etc.....
Thanks
 
G

Guest

Hi Mike

It's very simple. Just make sure you stroe the email address in the table
like this
MailTo:[email protected]
MailTo:[email protected]
etc
etc

The MailTo will open the outlook when you click the address

If you have mail addresses stored already you can use an update query to add
the "MailTo" to the addresses.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Email from access 4
use access button to send an email 1
How do I change the action of button in Access 2007 contact list? 1
email from access 2
Access and Outlook - Using email addresses from Access 7
How to export table from outlook into ms access table? 0
Bulk Email Directly from Access 2
accesshow too take different information from different templa 3

Top