Email directly from Access into Outlook?

[Roger Tregelles]

Hi Folks,

I have a supplier contact database that I created. One of the fields is a
hyperlink which contains the contacts email address. How do I setup my
database (Access 2003) such that when a user is viewing the contact's
information in a form, when they click on the contact's email address it
opens a new email message in Outlook 2003 with the contact's email address
already inserted in the To section of the message? Any help, direction or
guidance provided would be greatly appreciated.

Roger Tregelles
Quality Assurance Engineer
Respironics Inc.

 

[freakazeud]

Hi,
there are many many different options to achieve this.
Since you are using hyperlink you could right click on your hyerplink
field...then choose hyperlink...edit hyperlink...in the link to option select
e-mail addresses.
This will put a mailto: in front of the emails and if you click on them then
outlook opens a new email with the address in the to field.
Another option would be to change the values to text datatype. Then use a
controls on click event with the sendobject method to create the email. Both
of these methods are fairly limitted, so if you want more control then use
automation to create the email or redemption...!
HTH
Good luck

 

[Roger Tregelles]

Oliver,

Thanks, editing the hyperlink worked great! The other option you mentioned
sounds good to, but I'm not 100% sure how you implement it. How do you use
the "sendobject method" to create the email message exactly? Any specifics
you could share with me would be greatly appreciated. Thanks again for your
help.

Roger Tregelles
Quality Assurance Engineer
Respironics Inc.

 

[freakazeud]

Hi,
glad it worked out. The sendobject method would be the programming way of
doing it. This way you can actually include db objects as attachments, or
insert information in the cc, bcc, subject, body of the email as well instead
of just bringing up a blank new email. Sendobject is fairly limited in the
respect to that it only allows ONE attachment at a time and only access db
objects. So if you would want to send more then one or outside files then
sendobject will not work for you.
You can find the whole syntax of sendobject here
http://msdn.microsoft.com/library/d...baac11/html/acmthactSendObject_HV05186513.asp
It is fairly streight forward. Let me know if you need anymore info or a
sample of the code.
HTH
Good luck