Send an email from access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
 
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?
 
Back
Top