Mombu the Programming Forum sponsored links

Go Back   Mombu the Programming Forum > Programming > Sending Email from an Access Database
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 4th April 11:38
sarahegray
External User
 
Posts: 1
Default Sending Email from an Access Database


I have an access database (Access 2003) which we use to log all our tender
and contract information. I have 2 questions: -

1. I have fields which contain email addresses for external contacts and I
want to be able to click on these (like a hyperlink) and open Outlook as you
would with mailto: but I cannot figure out how to do this.

2. I also have a distribution list which is all internal contacts, I use a
report which I then want to email to the people on the distribution list, is
there a way I can set it up so that I can peform a macro which will attach
the report to an email within Outlook and enter the names into the To:
section in the message?
  Reply With Quote


  sponsored links


2 5th April 23:52
david lloyd
External User
 
Posts: 1
Default Sending Email from an Access Database


Sarah:

Regarding your second question, the SendObject method is one way to
distribute a report. If you are set on using Outlook, you can also use
Outlook automation to accomplish the task as outlined in the following KB
article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209948

Regarding, your first question, there is a hyperlink data type in Access
2003. If you use this data type and prefix a "mailto:" to your email
addresses, that will give you the desire effect, although I understand that
this may be restrictive to how you want to use the email addresses.

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

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


I have an access database (Access 2003) which we use to log all our tender
and contract information. I have 2 questions: -

1. I have fields which contain email addresses for external contacts and I
want to be able to click on these (like a hyperlink) and open Outlook as you
would with mailto: but I cannot figure out how to do this.

2. I also have a distribution list which is all internal contacts, I use a
report which I then want to email to the people on the distribution list, is
there a way I can set it up so that I can peform a macro which will attach
the report to an email within Outlook and enter the names into the To:
section in the message?
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666