Send an email from access

[Guest]

I have a bunch of email addresses stored in an Access 2003 database. Is there
any way to set it up so that I can click on an email address stored in my
Access Table, and have a new message come up in Outlook, already populated
with the email address from Access?

 

[Guest]

Hi Spok,

An easy way is to use DoCmd.SendObject. You can use this to send an object,
such as a report. However, you don't need to include an object, if you just
want to send a text message.

Here is a link to several past threads on this subject:

http://www.microsoft.com/office/com...ada&catlist=&dglist=&ptlist=&exp=1&sloc=en-us


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have a bunch of email addresses stored in an Access 2003 database. Is there
any way to set it up so that I can click on an email address stored in my
Access Table, and have a new message come up in Outlook, already populated
with the email address from Access?

 

[David Lloyd]

One alternative is to make the data type of the email address field a
hyperlink and then prefix a "mailto:" to each email address. Or
alternatively, you could create a new hyperlink field and combine "mailto:"
and the email address from the email address field. You could use an UPDATE
query to do this for all email addresses.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a bunch of email addresses stored in an Access 2003 database. Is
there
any way to set it up so that I can click on an email address stored in my
Access Table, and have a new message come up in Outlook, already populated
with the email address from Access?