Sending Email from an Access Database

[Guest]

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?

 

[David Lloyd]

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?

 

[Guest]

Sarah,
I had the same problem (1) some time ago. To find the answer, look for my
"mailto" item form 3/18/2006 in this discussion group.
In fact the answer is quite simple.
Format your "email" address field as a simple text field.
On the "double click" property, include following instruction
Apllication.FollowHyperlink "mailto:"& [controlname] (= your emailaddress
field)
This avoids also that the mailprogramm opens on simple, and by mistake,
clicking on the hyperlink.

As simple as that
Regards
Cram